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


Sports Data in Transition | SQL Databases in Sports – Part 1
Sports data can help athletes and their teams understand anomalies in performance, create more effective training regimes, and improve recovery time – just to name a few. With all this data being thrown about, what good would all this be – without a good way to structure it and query it? To put it bluntly, SQL is “considered a must" for those considering a sports analyst career. read more...

The Importance of Provisioning in Compliant Database DevOps
Compliance shouldn’t mean that you are forced to slow down your development process or compromise the quality of your work. In this webinar we will highlight the importance of provisioning as a part of your Compliant Database DevOps story and how it can accelerate your delivery processes while remaining in line with relevant legislation. read more...

The single question to predict success for DevOps, and what it means for change control
In this 30 minute session, Microsoft MVP Kendra Little will share and discuss her three key insights from the 'Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report' webinar, and show why these insights make a compelling argument for rethinking your organization's change control process. read more...

Beyond SQL Server 2008 End of Life
Extended Support for SQL Server 2008 and SQL Server 2008 R2 will end on 9th July 2019. This could leave you in a vulnerable position. James Boother from Coeo exposes the problem, its scale and shares all the options you have for life beyond extended support. read more...

How to achieve true DevOps by including the database
As proven in the ‘The 2018 Accelerate State of DevOps Report’ including the database in DevOps initiatives greatly improves performance. In this webinar we will walk you through Redgate’s Database DevOps solution, showing reliable, scalable and repeatable processes for automating your database development and deployment. read more...

End of support for SQL Server 2008 & 2008 R2
If you are running SQL Server 2008 or SQL Server 2008 R2, what does July 9th, 2019 mean for you? With both of these versions of SQL Server reaching the end of their support lifecycle together, you will no longer be able to get critical security updates. read more...

SQL SERVER – How to Change Authentication Mode Using T-SQL Query
One of my clients asked an interesting question. It took a while for me to figure out the answer so sharing with my blog readers. In this blog, we would learn how to change authentication mode of SQL Server using T-SQL query instead of SQL Server Management ... read more...

Index Tuning Week: Missed Missing Index Opportunities
A Reminder With a new baby in the house, I often find myself comparing her to various things. Barnacles. Ham. Pugs. No, I swear, I love her. SQL Server Has A Baby, Too That baby is the optimizer, and when it starts crying, it uses missing index requests ... read more...

Have your say on the future of data masking
Back in 2017 Redgate acquired Net2000, a leading provider of data masking solutions for SQL Server databases. Since then, we’ve invested heavily in the data masking tools to ensure our customers can balance the need to deliver software faster with the ... read more...

The Economist's Big Mac Index is calculated with R
The Economist's Big Mac Index (also described on Wikipedia if you're not a subscriber) was created (somewhat tongue-in-cheek) as a measure to compare the purchasing power of money in different countries. Since Big Macs are available just about everywhere ... read more...

Life is dirty. So is your data. Get used to it.
The internet provides everyone the ability to access data at any time, for any need. Unfortunately, it does not help guarantee that the data is valid, or clean. In the past year I have earned certifications in three areas: Data Science, Big Data, and ... read more...

Auto-Scaling Azure SQL DB
When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee) about auto scaling capabilities. Quite simply there is nothing out of the box to achieve this. The idea of auto … Continue reading → read more...

Which is faster? IN (list) or IN (SELECT FROM Temp)
If you’ve done much with IN (list) then you’ve realized that it basically translates out to col=val1 OR col=val2 OR .... You’ve probably also realized that you can throw all the values into a temp table and do this SELECT * FROM tablename WHERE col ... read more...

SQL Prompt as a Layout Tool: A Survival Guide
Here is some SQL code to reveal the highest-performing salespeople at AdventureWorks and listing their managers. SELECT SalesValue, COALESCE(SalesPerson.Title+' ', '')+SalesPerson.FirstName +COALESCE(' '+SalesPerson.MiddleName, '')+' '+SalesPerson.LastName ... read more...

Resource Governor MAXDOP Setting Can Lead to Poor Plan Choices
Resource Governor can be used to enforce a hard cap on query MAXDOP, unlike the sp_configure setting. However, query plan compilation does not take such a MAXDOP limit into account. As a result, limiting MAXDOP through Resource Governor can lead to unexpected ... read more...

Veterans At PASS Summit ’18
Hello all! This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service Members(past or present).  I started this last year at PASS Summit and handed out quite a few ribbons.  I hope to hand out more this year!     I ... read more...

Microsoft Chief Backs Federal Privacy Law Over State Efforts
Microsoft Corp.’s Chief Executive Officer Satya Nadella says his company supports national privacy legislation, adding the voice of the world’s largest software maker to the chorus of tech giants seeking federal action over state-by-state efforts. read more...

The Road to Becoming GDPR Compliant Leads to Long-term Success
Click to learn more about author Daniel Mintz. Under the General Data Protection Regulation (GDPR), data has to be controlled, secured and deleteable or anonymized.  This means that all businesses housing large volumes of data are faced with a dilemma: ... read more...

Quick DAX – Word count
Here is a technique you might consider if you need to split text down to individual words.  This could be used to help count, rank or otherwise aggregate the words in some longer text.  The approach detailed here uses spaces as a delimiter and will not ... read more...

Spotting Unauthorized Configuration Settings in SQL Server
An attacker of SQL Server likes to be able to change the SQL Server configuration settings. In an ideal world, you will have left everything open for the intruder, but generally, every DBA reduces the surface of attack as much as possible. In this article, Phil Factor explain how to detect any changes in server or database configuration settings, using Extended Events, and a custom metric, in SQL Monitor. read more...