(Hareesh Gottipati) If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should keep this script to generate URLs to be used in Read-Only Routing configuration.

(Jack Vamvas) Using a NULL value represents an unknown or missing value in a table column. Based on this definition , it’s easy to find examples of code where NULL is used an ordinary value. This antipattern leads to further problems.

(Pinal Dave) Performance troubleshooting are some of the most common things I get to see as part this blog. A number of you keep sending me interesting mails that keep me up-to-date on my learnings.

(Hareesh Gottipati) If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should keep this script to generate URLs to be used in Read-Only Routing configuration.

(Jack Vamvas) Using a NULL value represents an unknown or missing value in a table column. Based on this definition , it’s easy to find examples of code where NULL is used an ordinary value. This antipattern leads to further problems.

(Pinal Dave) Performance troubleshooting are some of the most common things I get to see as part this blog. A number of you keep sending me interesting mails that keep me up-to-date on my learnings.

(Erin Stellato) We’re teaching IEPTO2 in Dublin this week (and if Ireland is not on your list of places to see in this lifetime, you must add it… it’s fantastic here) and today I finished up the Query Plan Analysis module. One thing I cover is interesting things you can find in the query plan, for e

(Laerte Junior) IN the previous article on automating your SQL Server best-practice reports, we saw how to export, as CSV files, all the information we’d gathered about a SQL Server instance that related how closely the server conformed to best-practices.

(Ashish Kumar Mehta) DBCC CHECKDB, a long-awaited feature for SQL Server Analysis Services, provides the ability to perform database consistency checks against tabular and multidimensional databases.

(Koen Verbeeck) SQL Server Integration Services (SSIS) 2012 introduced a new concept of managing projects and their packages: the project deployment model. Using the project deployment model, it was not possible to deploy individual packages to the server. In the new and upcoming release of SQL Serv