Aaron Bertrand (@AaronBertrand) explains the ups and downs of a cohesive, consolidated, version-agnostic Books Online for SQL Server.
Kevin Kline and Ben Lezin hold a short Q & A with Gavin Payne and Mike Wood about Azure architecture and improvements.
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.
SQL Server 2014 is now at Service Pack 2, with plenty of enhancements back-ported from recent SQL Server 2016 updates.
Find out the build number of each SQL Server v.Next CTP as it is released, discover where to download, and how to get details on new fixes and features.
Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.
February 13th, 2017: Find information about the builds of SQL Server Management Studio and SSDT in their new release cycle approach, and locate the latest build of SSMS for previous versions.
Melissa Coates provides an overview of in-memory technologies in SQL Server, including columnstore indexes and memory-optimized tables, with an emphasis on columnstore indexes.
In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
Strategies and best practices for SQL Server alerts. Alert priorities, avoiding alert fatigue, and having a solid overall strategy are key.