Sites anglophones


Estimated Number of Rows to be Read

Publié le 6 février 2017 sur sqlservercentral.com
 

Rob Farley uses this month’s T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explai …

SQL SERVER – Database mirroring connection error 4 – An error occurred while receiving data: 10054

Publié le 6 février 2017 sur journey to sqlauthority
 

I was trying to set up database mirroring in my freshly created Azure Virtual Machines and encountered an error. The error was talking about the connectivity problem, but it was something else. Let us learn about Database mirroring connection erro …

SQL SERVER – SQL Server: Getting OS information using DMV

Publié le 6 février 2017 sur journey to sqlauthority
 

I am used to exploring what is available in the technology of love – SQL Server. As I was exploring into one of the simplest set of DMVs which have been available for ages. There are several ways to get the OS information inside SQL Server. One o …

Azure Functions, Dapper and SQL Server JSON to store form data

Publié le 5 février 2017 sur sqlblog.com
 

A common problem Recently we had to setup a couple of contact form pages to allow users to register to the App 2.0 Beta program (now RTM) or to tell us which of the products we launched at CES 2017 they are interested into. Such kind of request are qui …

Introducing SDU Tools: Free T-SQL Tools for DBAs and Developers

Publié le 5 février 2017 sur sqlblog.com
 

I’ve worked with T-SQL for a very long time, and over the years I’ve lost count of how many tools I’ve found the need to create to help me in my work. They have been in a variety of script folders, etc. and whenever I go to use them n …

How to Enable Auto Update Statistics and Auto Create Statistics with T-SQL – Interview Question of the Week #108

Publié le 5 février 2017 sur journey to sqlauthority
 

Question: How to Enable Auto Update Statistics and Auto Create Statistics? Answer: I have received this question after watching my free webinar on group by conference by one of the user. I really loved his question so I am re-posting the question …

Intelligent Data Integration, SSIS Design Patterns, and Biml

Publié le 4 février 2017 sur sqlblog.com
 

On Friday, 24 Feb 2017, I have the privilege and honor of delivering a full-day precon titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration as part of SQL Saturday Boston . If you’re interested in learning more or attending …

SQL SERVER – Database Mirroring Connection Error 4 – An Error Occurred While Receiving Data: 10054

Publié le 4 février 2017 sur journey to sqlauthority
 

I was trying to set up database mirroring in my freshly created Azure Virtual Machines and encountered an error. The error was talking about the connectivity problem, but it was something else. Let us learn about how to fix the database mirroring conne …

SQL Saturday Pordenone is back!

Publié le 3 février 2017 sur sqlblog.com
 

Another SQL Saturday event has been scheduled in Pordenone (Italy), it will be the SQL Saturday #589 and this year it will be more international than the previous editions because the Data Science track will be completely in English language, as s …

On DevOps…

Publié le 3 février 2017 sur sqlblog.com
 

DevOps is getting a lot of attention in SQL Server and Developer communities these days. Two friends have blogged about the outage and accompanying data loss experienced by GitLab : Brent Ozar ( blog | @BrentO ) wrote SQL Server DBA’s Guide to th …

User Acceptance Testing and the Application Lifecycle

Publié le 3 février 2017 sur simple-talk.com
 

A software application can be robust, scalable, easily maintained, and easy to use, but if it doesn’t do what the customer needs then it is useless. The success of a new product or software application is at the mercy of how precisely it fulfils …

Memory Grants and Data Size

Publié le 3 février 2017 sur brentozar.com
 

What does memory do? In SQL Server, just about everything. We cache our data and execution plans in it (along with some other system stuff), it gets used as scratch space for temporary objects, and of course queries use it for certain operations, most …

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Publié le 3 février 2017 sur sqlservercentral.com
 

Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.

Is your SQL Server remote?

Publié le 3 février 2017 sur sqlservercentral.com
 

If the answer is yes, this survey is for you. Redgate is looking at building solutions to the issues associated with remote SQL Servers. They want to know your pain points, and whether there’s anything they can do to assist. If you think you could help …

Performance of the SQL MERGE vs. INSERT/UPDATE

Publié le 3 février 2017 sur sqlservercentral.com
 

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?


Pages :