Performance Fabiano Amorim in Performance Tempdb – Here’s a Problem You Didn’t Know You Had Because of its many roles, tempdb is the source of performance issues in SQL Server, and there are recommended configuration... 21 April 2020 14 min read
T-SQL Programming Greg Larsen in T-SQL Programming Reduce CPU of Large Analytic Queries Without Changing Code Microsoft introduced several features called Intelligent Query Processing for SQL Server in 2017 and 2019 that can improve performance without... 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? Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to... 22 July 2019 15 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 The Performance of Window Aggregates Revisited with SQL Server 2019 T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations... 11 February 2019 11 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 The Extended Events (or XEvents) feature has been part of SQL Server since 2008, but many database professionals struggle to... 27 September 2018 34 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
Blogs Kathi Kellenberger in Blogs 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 and Performance T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article,... 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
