T-SQL Programming Greg Larsen in T-SQL Programming SQL Server Batch Mode on Rowstore: Reduce CPU on Analytic Queries SQL Server 2019 Batch Mode on Rowstore reduces CPU usage of large analytic aggregate queries by 20–30% without rewriting any... 25 March 2020 19 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Understanding the NAND Flash Solid State Drive Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this... 11 March 2020 13 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Understanding the Hard-Disk Drive In this article in the series, Robert Sheldon provides a deep dive into HDDs.… 18 February 2020 12 min read
Performance Greg Larsen in Performance Get Your Scalar UDFs to Run Faster Without Code Changes Microsoft has added a group of features called Intelligent Query Processing to SQL Server 2017 and 2019. In this article,... 10 February 2020 14 min read
Database Administration Robert Sheldon in Database Administration Storage 101: The Language of Storage Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.… 22 January 2020 13 min read
Database Administration Forrest McDaniel in Database Administration How Does Accelerated Database Recovery Work? Accelerated Database Recovery is new with SQL Server 2019 and Azure SQL Database and used to decrease the time for... 26 November 2019 12 min read
T-SQL Programming Monica Rathbun in T-SQL Programming What Are Columnstore Indexes in SQL Server? Explained Learn what columnstore indexes are in SQL Server, how they store data by column instead of row, and why they... 22 July 2019 16 min read
Performance Samir Behara in Performance Designing Highly Scalable Database Architectures While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and... 09 April 2019 13 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming SQL Server 2019 Window Aggregate Performance: Batch Mode on Rowstore SQL Server 2019 Batch Mode on Rowstore dramatically improves window aggregate performance - running totals, moving averages, and accumulating SUM... 11 February 2019 12 min read
Database Administration Laerte Junior in Database Administration What Is SQLPSX? SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior... 29 October 2018 12 min read
Database Administration Robert Sheldon in Database Administration Adaptive Query Processing in SQL Server 2017 As new versions of SQL Server have been released, the Query Optimizer has undergone many improvements. Adaptive Query Processing, new... 01 October 2018 17 min read
Database Administration Phil Factor in Database Administration Extended Events Workbench: SQL Server Recipes Practical Extended Events (XEvents) recipes for SQL Server. Ready-to-use sessions for error tracking, query monitoring, wait stats, and performance troubleshooting.… 27 September 2018 35 min read
Editorials Kathi Kellenberger in Editorials Why Everyone Developing T-SQL Needs to Learn About Graphical Execution Plans Just recently, my local .NET user group asked me to present at their meeting on the topic of graphical execution... 08 August 2018 3 min read
Other Kathi Kellenberger in Other The Top Five Things That DBAs Need to Monitor Being a database administrator is much more than knowing how to install SQL Server and set up a database. One... 14 July 2018 3 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming T-SQL Window Functions: Performance, NTILE & Framing Master T-SQL window function performance: understand OVER clause sorting, PARTITION BY, NTILE, framing (ROWS vs RANGE), indexing strategies, and how... 27 June 2018 11 min read
Editorials Kathi Kellenberger in Editorials Why Database Administrators Need Monitoring Tools I was recently asked about which tools I used back when I was a full-time SQL Server database administrator. I... 02 May 2018 3 min read
Data Privacy and Protection Hugo Kornelis in Data Privacy and Protection Execution Plans and Data Protection One of the most important tools for query tuning is the ability to view execution plans. They are even portable;... 10 April 2018 23 min read
Performance Uwe Ricken in Performance READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it... 06 March 2018 12 min read
Career Monica Rathbun in Career How to Survive as a Lone DBA Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived... 06 February 2018 16 min read
Other Dennes Torres in Other SQL 2017 new DMF: Managing VLOGs in our databases SQL Server 2017 brings to us some new interesting DMV’s and DMF’s, one of them is sys.dm_db_log_info. This new DMF... 20 June 2017 4 min read
