BI Edward Pollack in BI Vertipaq optimization and its impact on columnstore compression Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you need to know to manage... 19 January 2022 21 min read
Azure Mike Wood in Azure Azure Policies and Management Groups You can define policies for your Azure SQL Databases for security and meeting your organization’s standards. Management groups simplify policies over multiple subscriptions. Michael Wood... 13 December 2021 11 min read
Performance Edward Pollack in Performance Automating Extended Events data collection It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates... 04 October 2021 18 min read
Editorials Kathi Kellenberger in Editorials The challenges of ever-growing estates Each year Redgate runs a survey to determine the state of database monitoring. This year, instead of one large report, we are publishing four insight... 21 September 2021 3 min read
Database Administration Edward Pollack in Database Administration Building blocks of Extended Events data collection Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.… 14 September 2021 14 min read
T-SQL Programming Kathi Kellenberger in T-SQL Programming How LAG compares to other techniques LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques… 07 September 2021 13 min read
Azure Robert Sheldon in Azure The Azure SQL portfolio Microsoft provides many ways to run SQL Server in Azure, but which do you choose? In this article, Robert Sheldon explains the Azure SQL options.… 01 September 2021 14 min read
Performance Fabiano Amorim in Performance SQL Compilations/sec is not what you think it is SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec,... 29 July 2021 24 min read
Database Administration Greg Larsen in Database Administration Improving performance with instant file initialization Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.… 23 July 2021 12 min read
Performance Edward Pollack in Performance Collecting SQL Server performance monitor data SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.… 20 July 2021 20 min read
Learn SQL Server Priyanka Chouhan in Learn SQL Server SQL Server High Availability and Disaster Recovery Plan Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.… 14 July 2021 26 min read
Editorials Kathi Kellenberger in Editorials How to learn about Azure SQL It was always important to me to keep up with the latest versions of SQL Server, but especially so when I was a database administrator... 09 July 2021 3 min read
Performance Edward Pollack in Performance SQL Server performance monitor data: Introduction and usage Monitoring SQL Server for performance is a critical part of a DBA’s job. In this article, Edward Pollack explains some of the SQL Server performance... 29 June 2021 13 min read
Azure Mahendran Purushothaman in Azure Autoscaling in Microsoft Azure The ability to scale up and down without maintaining extra hardware is one of the best cloud computing features. In this article, Mahendran Purushothaman explains... 16 June 2021 10 min read
Database Administration Robert Sheldon in Database Administration SQL Server and hyperconvergence To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider... 15 June 2021 16 min read
Learn SQL Server Greg Larsen in Learn SQL Server SQL Server transaction log architecture The transaction log file for a SQL Server database critical for for maintaining database integrity. In this article, Greg Larsen explains SQL Server transaction log... 08 June 2021 12 min read
Database Administration Robert Sheldon in Database Administration SQL Server performance tuning: Nine best practices SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance... 28 May 2021 14 min read
Learn SQL Server Pamela Mooney in Learn SQL Server DBA in training: SQL Server high availability options DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.… 19 May 2021 23 min read
Editorials Kathi Kellenberger in Editorials What is an ad hoc query? Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query not included in a stored... 04 May 2021 4 min read
Performance Edward Pollack in Performance SQL Server plan cache mining – Plan attributes Edward Pollack demonstrates how SQL Server plan cache mining can uncover a wealth of information to help with troubleshooting performance issues. … 26 April 2021 20 min read
