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


Bringing DevOps to the database. Part 2: Continuous delivery
Many application developers already use continuous integration to automatically test their code, and release management tools to automate application deployment. Database developers can join them. read more...

Setting SQL Server Connection String Properties In Power BI and SSAS Tabular Modern Data Sources
It may not be immediately obvious, but you cannot set your own connection string properties when connecting to SQL Server using the built-in SQL Server connector from either Power BI or a modern data source in Azure SSAS/SSAS Tabular 2017: All you can ... read more...

Configuration Manager Missing - Windows 10
SQL Server Configuration Manager is one of the fundamental tools for a DBA to do basic tasks like starting or stopping SQL Service, knowing how many instances and what components of SQL Server are been installed on the machine.Imagine this, suddenly ... read more...

WIT: A Quick Thought
I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time. I loved it. So what does that have to do with Women in Technology (WIT)? The young lady standing up also DMed her first convention. She’s my daughter ... read more...

SQL in the City is coming Feb 28
The next edition of the SQL in the City broadcast is coming Feb 28, and I’m planning travel now to head back to the UK for the event. We don’t have a schedule yet, but once we do, it will be on the Redgate Hub Livestream page. This edition will likely ... read more...

More SSMS Tips & Tricks
Wayne Sheffield’s been busy since our last visit.  Here are six more SSMS tips and tricks. First, Wayne shows how to create keyboard shortcuts for common activities.  Then, he shows how to color-code SQL Server instances, which is very helpful when trying ... read more...

More DBA Salary Research
Ginger Grant digs into the DBA salary survey a bit further: I know that I have heard that if you want to make money you need to get into management. Being a good manager is not the same skill set as being a good database professional, and there are many ... read more...

Find Pipelines Currently Running in Azure Data Factory with PowerShell
This is a quick post to share a few scripts to find what is currently executing in Azure Data Factory. These PowerShell scripts are applicable to ADF version 1 (not version 2 which uses different cmdlets).Prerequisite: In addition to having installed ... read more...

Database Fundamentals #16: Removing Data With T-SQL
Deleting data from a table using T-SQL works quite a lot like the UPDATE statement. How it Works In the same way you supply the statement, DELETE, and then the table name. You’re not going to specify columns in any way because deleting data is all about ... read more...

Count_Big() function
Learned new function for count while going through the channel 9 video for salva. where for a very big table count it gave an error :   Count_Big() – BOL: Returns the number of items in a group. COUNT_BIG works … Continue reading → read more...

The world of Automatic Tuning – SQL Server 2017
Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged product. I was testing out SQL Server 2017 Automatic Tuning recently and I ended up with the following situation. Below shows an image ... read more...

An Easier Way of Pivoting Data in SQL Server
There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil Factor demonstrates how to take advantage of JSON support, introduced with SQL Server 2016, to create a function that makes pivoting data simple. read more...

Baselining a ReadyRoll project from an existing database
When creating a new ReadyRoll project, the schema of your production environment can also be imported as a baseline. Further work can be built on top of the baseline in a sandbox development environment and, when you’re happy with the changes, the project can be deployed to production. read more...

Cumulative Update #10 for SQL Server 2014 SP2
The 10th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing ... read more...

Checking Your SQL Server Instance for Spectre/Meltdown Patches
If you are running SQL Server 2008 through SQL Server 2017, you should be thinking about what you should be doing to protect your systems from the Meltdown and Spectre vulnerabilities. Microsoft has a number of KB articles that address this issue from ... read more...

How Much Can One Row Change A Plan, Part 4
Monte Carlo Or Bust In Part 3, I showed you how two queries with TOP clauses can produce wildly different plans. To figure some stuff out about why the plans changed, let’s focus on the Nested Loops Join plan. Why? Because when I force the Hash Join ... read more...

What Does REPAIR_ALLOW_DATA_LOSS in SQL Server Signify?
REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL users and even administrators at times get confused about the real functioning of this command. It is to be noted that ... read more...

Power BI Custom Visuals Class (Module 86 – Bubble Chart by Akvelon)
In this module you will learn how to use the Bubble Chart Custom Visual by Akvelon. The Bubble chart allows you to show the value of categories proportionally represented by the size of the bubble. Module 86 – Bubble Chart By Akvelon Downloads Power ... read more...

Microsoft Sees Need For Regulation, Laws For AI Advances
The rapidly advancing area of artificial intelligence will require a new field of law and new regulations governing a growing pool of businesses involved, according to Microsoft Corp., a 25-year participant in AI research. read more...

How to monitor the impact of patching on SQL Server performance
In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate. read more...