Editorials Kathi Kellenberger in Editorials Key Insights from the 2020 State of SQL Server Monitoring Report This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This... 20 May 2020 3 min read
PowerShell Greg Moore in PowerShell How to Add Help to PowerShell Scripts PowerShell scripts are the tool of choice for many admins, but how do you make them easy for others to... 13 May 2020 12 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Modern Storage Technologies In this article of the series, Robert Sheldon discuses emerging trends in storage like virtual SANs, intelligent storage, computational storage... 28 April 2020 13 min read
Database Administration Pamela Mooney in Database Administration How to Set Up Transactional Replication Replication is one way to copy data to another database or server. In this article, Pamela Mooney describes how to... 16 April 2020 11 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Data Center Storage Configurations In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.… 08 April 2020 11 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 Cain in Database Administration How to Create an Ubuntu PowerShell Development Environment – Part 2 You’ll need several tools in place to effectively work with SQL Server in Linux. In this article, Robert Cain explains... 03 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
T-SQL Programming Monica Rathbun in T-SQL Programming SQL Server Memory-Optimized Tables: Beginner’s Guide Learn how memory-optimized tables work in SQL Server - In-Memory OLTP architecture, creating durable and schema-only tables, natively compiled stored... 14 February 2020 18 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 Robert Sheldon in Database Administration Storage 101: Welcome to the Wonderful World of Storage Understanding all the storage options available today is not easy. In this new series, Robert Sheldon will explain what you... 03 December 2019 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
Editorials Kendra Little in Editorials SQL Server Management Studio is as Relevant as Ever After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management... 24 September 2019 3 min read
Database Administration Joshua Feierman in Database Administration How to Use SQL Audit and Azure Log Analytics to Comply with Audit Rules You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance... 09 September 2019 16 min read
Database Administration K. Brian Kelley in Database Administration The End of SQL Server 2008 and 2008 R2 Extended Support Many organisations still run their companies on SQL Server 2008 or 2008 R2. There are many reasons to upgrade, but... 21 June 2019 26 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration Navigate Linux for SQL Server DBAs Kellyn Pot’Vin-Gorman shows how to navigate Linux for SQL Server DBAs, using aliases, setting up environment variables, and examining processes.… 17 June 2019 18 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 6 SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features... 29 May 2019 15 min read
Database Administration Greg Larsen in Database Administration SQL Server Resumable Online Index Rebuild: Pause and Resume Index Operations SQL Server 2017 introduced resumable online index rebuilds - pause and resume large index operations without losing progress. SQL Server... 05 March 2019 15 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 3 SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the... 25 February 2019 14 min read
PowerShell Greg Moore in PowerShell Using a Server List to Control PowerShell Scripts PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how... 29 January 2019 13 min read
