By Michael Otey, 12/12/2011
New to SQL Server 2012, the AlwaysOn Availability Groups feature is the next evolution of database mirroring. Find out what AlwaysOn Availability Groups are, what you need to use ...
By Maurice Pelchat, 12/12/2011
In the SQL Server community, most examples of dynamic T-SQL code are plagued with a severe readability problem. Find out the four techniques that you can use to solve this ...
By Itzik Ben-Gan, 11/21/2011
SQL Server 2012 enhances support for window aggregate functions by introducing window order and frame clauses, support for offset functions, and support for window distribution ...
By Itzik Ben-Gan, 10/26/2011
Itzik explains how to handle type conversions when you need to convert a character string value to another type, in both SQL Server 2008 and SQL Server Denali.
By Michael K. Campbell, 10/21/2011
SQL Source Control takes all the pain and potential problems out of implementing version control in SQL Server.
By Michael Otey, 10/18/2011
Common problems DBAs face when using Windows PowerShell.
By Andrew Kelly, 10/18/2011
When done correctly, dynamic SQL can be used effectively. Make sure you know how to get the most out of it.