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
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
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Analysis with R In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating... 13 May 2020 19 min read
Performance Greg Larsen in Performance Right-Sizing Row Mode Query Memory Requirements When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be... 29 April 2020 16 min read
BI Imran Quadri Syed in BI Implementing a Data Quality Monitoring Framework For any Business Intelligence solution to be useful for analytical and decision-making purposes, it is imperative that the underlying data... 29 April 2020 26 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
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
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
T-SQL Programming Edward Pollack in T-SQL Programming Tracking Underlying Object Changes in Views Views in SQL Server are used to simplify writing queries and managing security, but’s it’s easy for views to eventually... 31 March 2020 23 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
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial... 18 March 2020 22 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
