Ever wonder which specific T-SQL pattern is best for splitting strings? There are lots of ways to calculate running totals, but which is optimal? What CPUs are best for SQL Server 2012? For SQL Server 2014? Find out more in this post from Kevin Kline. Read More...

When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics. In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular resource, activity, or process. Since wait statistics are categorized by type, one look will quickly tell the variety of problem that needs your attention, assuming you know meaning for Microsoft's lingo for each wait type. Read More...

This morning Microsoft released some great updates to Windows Azure. These new capabilities include: SQL Server AlwaysOn Support: General Availability support with Windows Azure Virtual Machines for High Availability and Disaster Recovery Notification Read More...

The Database Lifecycle Management is an MSDN curated content view providing a single location to find many of the best solutions for common customer tasks in Microsoft SSDT, SSMS, and SQL Database. Read More...