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


PASS Marathon GDPR in partnership with Redgate
This special edition of the PASS Marathon series will focus on the General Data Protection Regulation (GDPR). You’ll learn how the legislation impacts SQL Server data professionals around the globe and practical steps you can take to help ensure you’re ready for when GDPR enforcement takes effect on May 25th. read more...

Outputting Status in Your T-SQL Code
Often, you have some code that is taking a long time, and you want to know how much time sections of the code is taking, and you likely want to know immediately as your code executes. In this blog I will talk about a couple of the techniques you can use to make this happen, either in a permanent manner, as well so in a message. read more...

Get the join cheat sheet!
Download and print this nifty little PDF with all of the INNER, LEFT, RIGHT, FULL and CROSS JOINs visualized! It’ll look great on your office wall or cubicle. Your coworkers and your interior decorator will love you for it. How it works: For each join ... read more...

CROSS JOIN for fun
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts houses over a game of chess* with his brother: “ONE MILLION POINTS TO GRYFFINPUFF!” So I said, “Hey guys, I’m going to do a nerdy thing with my ... read more...

Capture SQL Server Reported Errors using Extended Events
In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may make you to start playing with it. In this tip, I will be discussing how you can find what caused SQL Server to ... read more...

New SQLChallenge: Defuse the Deadlock
When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.” This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes ... read more...

More Showplan enhancements – UDFs
As I mentioned on yesterday’s post, with the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements here. In this article I’ll talk about the second showplan improvement ... read more...

Data Governance vs. Data Architecture
While Data Architecture focuses on technology and infrastructure design, Data Governance encompasses the people, the process, the workflow, as well as the architecture needed to support governance.  So, even though Data Architecture is critical to Data ... read more...

Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure
One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into ... read more...

Free data privacy and protection livestream on February 28
Redgate’s Data Platform MVPs, Steve Jones, Grant Fritchey and Kathi Kellenberger, will head up the speaker line-up of this Data Privacy and Protection -themed livestream. Many of you will be aware that the new GDPR legislation comes into effect in May and, in light of this, the agenda will include sessions to help you become best equipped to deal with the challenges GDPR brings to compliant database management. read more...

How to build a DevOps roadmap to kickstart your digital transformation journey
By harnessing the concept of agility to a methodology that enables constant software innovation, DevOps allows organizations to respond dynamically to changing market conditions and rising customer expectations. read more...

How UPS delivers faster using $8 headphones and code that decides when dirty trucks get cleaned
Inside EDGE: the shipping giant’s ambitious, tech-driven bid to keep Amazon and others at bay. read more...

Migrating to Azure SQL Database with Zero Downtime for Read-Only Workloads
Special thanks to MSAsset engineering team’s Peter Liu (Senior Software Engineer),  Vijay Kannan (Software Engineer), Sathya Muhandiramalage (Software Development Engineer II), Bryan Castillo (Principal Software Engineer) and Shail Batra (Principal Software ... read more...

SCHEMABINDING and Why It Can be Useful?
In SQL Server, when we use the “WITH SCHEMABINDING” clause in the definition of an object (view or function), we bind the object to the schema of all the underlying tables and views. This means that the underlying tables and views cannot be modified ... read more...

SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
This was one of the hard lessons learned, so I am sharing with blog readers. This is about an error in cluster resource DLL. While applying the patch to SQL instance, I cluster, sometimes we get warning “Cluster Resource DLL Update Restart Check.” If ... read more...

Sync SQL data in large scale using Azure SQL Data Sync
This post is authored by Xiaochen Wu, Program Manager, SQL Server.   Azure SQL Data Sync allows users to synchronize data between Azure SQL Databases and SQL Server databases in one-direction or bi-direction. This feature was first introduced in 2012. read more...

The February release of SQL Operations Studio is now available
This post is authored by Alan Yu, Program Manager, SQL Server. We are excited to announce the February release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations Studio ... read more...

Data Science and Standard Patterns
In Data Science, the word “Pattern” has a specific meaning, involving the patterns that arise from data. This type of analysis is quite common in Data Mining and other technologies used by a Data Scientist. In IT practices such as systems architecture ... read more...

Then Why Doesn’t SQL Always Seek?
Scan The Man There seems to be a perpetual battle waged against the Index Scan. At some point it was declared that scans were inferior to seeks, and all energy should be dedicated to eradicating them. Much like asking why the whole plane isn’t made out ... read more...

Microsoft’s compiler-level Spectre fix shows how hard this problem will be to solve
Enlarge (credit: Aurich Lawson / Getty Images) The Meltdown and Spectre attacks that use processor speculative execution to leak sensitive information have resulted in a wide range of software changes to try to limit the scope for harm. Many of these ... read more...