Melissa Connors (@MelikaNoKaOi) explains how visualizing data compression (through DBCC PAGE) helps you better understand SQL Server compression methods.
Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
Find out what new features have been released for the SentryOne Cloud, including a new Performance Dashboard!
Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.
Way back in the summer of 2014, I told you about how I used DB-Engines.com to determine the popularity of various data management tools and vendor platforms. Plus, by adding in an analysis Google Trends I can see where the overall trends that I'm interested in are headed. Staying up with the trends isn't just
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.
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.
There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server. READ MORE… Originally Posted February 08, 2017
Strategies and best practices for SQL Server alerts. Alert priorities, avoiding alert fatigue, and having a solid overall strategy are key.
When monitoring SQL Server for performance, you should know which counters matter, and why. MVP Allen White explains 15 common and relevant counters.
For T-SQL Tuesday #86, Lori Edwards promotes one of the most frustrating SQL Server error messages in existence, "String or binary data would be truncated."