Database Administration Greg Larsen in Database Administration Understanding SQL Server Recovery Models The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg... 27 August 2020 12 min read
Career Pamela Mooney in Career DBA in training: Preparing for interviews Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains... 26 August 2020 17 min read
Database Administration Robert Sheldon in Database Administration Storage 101: The Future of Storage Robert Sheldon continues his series on storage by discussing the latest storage innovation and ideas. … 21 August 2020 13 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 3 Nonclustered Indexes Uwe Ricken continues his series on heaps. This time he demonstrates a common scenario where the query against a heap... 18 August 2020 8 min read
Career Pamela Mooney in Career DBA in Training: So, you want to be a DBA… Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives... 11 August 2020 14 min read
BI Vince Iacoboni in BI Clarifying Data Warehouse Design with Historical Dimensions The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this... 04 August 2020 17 min read
Phil Factor Temporary Tables in SQL Server Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or... 01 August 2020 22 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Data Security and Privacy No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what... 22 July 2020 12 min read
Performance Edward Pollack in Performance Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options In this article of this series, Edward Pollack demonstrates the maintenance of columnstore indexes. He also takes a look at... 21 July 2020 22 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 2 Best Practices and Guidelines In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to... 24 June 2020 20 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 2 Optimizing Reads In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including... 22 June 2020 18 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Cloud Storage Throughout this series, I’ve discussed a range of storage-related topics, some of which I mentioned only briefly. One of those... 22 June 2020 12 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Connecting to a SQL Server Docker Container Running in macOS Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting... 22 June 2020 14 min read
Database Administration Alejandro Cobar in Database Administration Using a Public Web Service to Consume SQL Server Build Numbers Keeping SQL Server instances patched can be a time-consuming task for DBAs. In this article, Alejandro Cobar explains how he... 15 June 2020 10 min read
Database Administration Robert Cain in Database Administration How to Create an Ubuntu PowerShell Development Environment – Part 3 Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of... 28 May 2020 20 min read
Database Administration Robert Sheldon in Database Administration Storage 101: Convergence and Composability In this article in the storage series, Robert Sheldon explains infrastructure options that simplify administration and improve resource utilization. He... 28 May 2020 13 min read
Performance Greg Larsen in Performance Improve Row Count Estimates for Table Variables without Changing Code Table variables can cause performance issues with joins when they contain a large number of rows. In SQL Server 2019,... 26 May 2020 12 min read
T-SQL Programming Uwe Ricken in T-SQL Programming Heaps in SQL Server: Part 1 The Basics Most advice you see online about heaps is to avoid them. In this article, Uwe Ricken describes the basics of... 21 May 2020 9 min read
T-SQL Programming Edward Pollack in T-SQL Programming Hands-On with Columnstore Indexes: Part 1 Architecture Microsoft introduced Columnstore with SQL Server 2012 and have improved the feature in every version since then. You may be... 21 May 2020 22 min read
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
