Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.

Sign up to our newsletter now, to keep up to date with all the latest news.

Latest Database Weekly Newsletter Articles


Capture the Flag – The Trace Flag
Many people work in a tightly controlled environment. Every change requires a change control form and approval to make a change. In some environments, things are more lax, but you still wish you could tell when certain changes were made. That is even ... read more...

Azure SQL Managed Instance Business Critical tier is Generally Available
We are happy to announce General availability of Business Critical tier in Azure SQL Managed Instance – architectural model built for high-performance and IO demanding databases. After 5 months of public preview period Azure SQL Managed Instance Business ... read more...

Overview of Data Compression in SQL Server
The database is a critical and vital part of any business or organization.  The growing trends predict that 82% of enterprises expect the number of databases to increase over the next 12 months. A major challenge of every DBA is to discover how to tackle ... read more...

Producing Data and Schemas in JSON array-of-array format.
JSON was initially designed for the informal transfer of data that has no schema. It has no concept of a table, or of an array of identical arrays. This means that it must tell you each key for each object, even if the original data object was a table. read more...

I Have an Exclusive Lock, My Row Is Safe, Right?
Note: This is an update of a blog I posted in 2006 with a lot of additional information (I was less wordy in my 30s apparently). It is just as relevant today. I have a presentation I do occasionally on concurrency entitled “Let Me Finish” that covers ... read more...

How to Linux for SQL Server DBAs — Part 3
The series so far: How to Linux for SQL Server DBAs — Part 1 How to Linux for SQL Server DBAs — Part 2 How to Linux for SQL Server DBAs — Part 3 As you jump into Part 3, you’ll begin to realize how involved your education will be with Linux, and how ... read more...

Your Personal Data is Already Stolen
In an excellent blog post, Brian Krebs makes clear something I have been saying for a while: Likewise for individuals, it pays to accept two unfortunate and harsh realities: Reality #1: Bad guys already have access to personal data points that you may ... read more...

Quora Discloses Data Breach, Doubts It Will Result in Identity Theft
DAILY VIDEO: Quora discloses a data breach impacting 100 million users, and NeuVector improves container security with admission control. read more...

Surface Book 2 Owners Encounter BSOD After Windows 10 Cumulative Update
Surface Book 2 owners have complained about getting the Blue Screen of Death (BSOD) after installing the KB4467682 update for the Windows 10 April 2018 Update. read more...

Innodisk Launches Ultra-Slim M.2 Graphics Card
Innodisk has launched a graphics card in the M.2 form factor. It's based on the Silicon Motion SM768 controller and supports 1920x1080 resolution at 60Hz and 3840×2160 at 30Hz. read more...

SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
This was an interesting error which I received while trying to uninstall SQL Server.  In this blog, we would learn how to fix error Index was outside the bounds of the array, which might come during uninstallation of SQL Server. I must say this was an ... read more...

SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect
Recently, I was trying to uninstall SQL Server via command prompt and faced an interesting situation. In this blog, we would learn about the error “The syntax of argument “/ACTION” is incorrect” and how to fix it. THE SITUATION As I mentioned in one ... read more...

The November release of Azure Data Studio is now available
We are excited to announce the November release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studioand review the Release Notes to get started. Note: If you are currently using the preview version, ... read more...

SQL Server 2014 Service Pack 3 is now available
The SQL Server team is excited to bring you the third service pack release for SQL Server 2014. This service pack is now available for download from the Microsoft Download Center as well as the Microsoft Update Catalog, Microsoft Developer Network, Microsoft ... read more...

SSMS 17.9.1 is now generally available
We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1. Download SSMS 17.9.1 today and for details please see the Release Notes. This is a minor update to 17.9 with the following important improvements: Occasionally, SSMS ... read more...

Indexed View Matching With GROUP BY And DISTINCT
Bit Of A Kick I’ve been playing with indexed views a little bit lately for some demos in my Bits Precon. There are a whole bunch of limitations in creating indexed views. One of them is that you can’t base the query on DISTINCT. Fair enough, but you ... read more...

Azure SQL DB is Slow: Do I Need to Buy More DTUs?
You’ve got an Azure SQL DB, and your queries are going slow. You’re wondering, “Am I hitting the performance limits? Is Microsoft throttling my queries?” There’s an easy way to check: run sp_BlitzFirst. sp_BlitzFirst is our free performance health check ... read more...

“Surely this one will get a clustered index scan.”
I love building demos for our training classes because I’m constantly in a battle of the minds with SQL Server. I try to guess what he’s going to do next, and I love it when he surprises me. I started by building a new parameter sniffing demo with the ... read more...

Neither bird nor plane: Captain Marvel blasts into space in new trailer
Enlarge / Captain Marvel (Brie Larson) in all her iconic glory. (credit: Marvel Studios) Captain Marvel took off into space Monday night, delivering knock-down punches and lots of adrenaline-fueled action in the character’s first starring film this ... read more...

Australia passes new law to thwart strong encryption
Enlarge / The Member for Sydney Tanya Plibersek speaks as the Labor party stay for the end of parliament in the House of Representatives at Parliament House on December 06, 2018, in Canberra, Australia. (credit: Tracey Nearmy/Getty Images) On Thursday, ... read more...