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


SQL Server 2019 New Features
Microsoft’s leading database is an essential tool, with in-cloud and on-premises versions providing incredible storage and analytic tools. It’s additionally turned into an essential application for data scientists, giving a structure to building and ... read more...

USB Cable with Embedded Wi-Fi Controller
It's only a prototype, but this USB cable has an embedded Wi-Fi controller. Whoever controls that Wi-Fi connection can remotely execute commands on the attached computer. read more...

SQL SERVER – Update Table Statistics in Parallel with FULLSCAN
SQL Server Performance Tuning is a much simpler job if you know exactly where to look for and how to tune the configurations. Here is the real world scenario which I encountered during the recent Comprehensive Database Performance Health Check. During ... read more...

The February release of Azure Data Studio is now available
Were excited to announce the February 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 youre currently using the preview version, ... read more...

Should you run SSAS/SSIS/SSRS on the SQL Server?
When you’re building a new SQL Server, you’re going to see a few intriguing checkboxes during setup. It’s all free, right? Check everything! The services are all free, right? You can just check the boxes for Machine Learning Services, R, Python, Data ... read more...

[Video] How to Capture Baselines with sp_BlitzFirst
Everybody tells you to capture baselines – but what exactly are you supposed to capture? Which Perfmon counters matter? How do you track which data files are growing, and which ones are slow? How can you track which queries are using the most resources? All ... read more...

Microsoft begins work on its 2020 Windows releases in new preview
Enlarge / Windows is now perpetually under construction. (credit: David Holt) Microsoft has published a new preview release of Windows 10, build 18836, to participants of the "Skip Ahead" group. But it's not quite the preview that they were expecting ... read more...

Microsoft shaking up how Windows feature updates are rolled out—again
Enlarge (credit: Microsoft) Customers using Windows Update for Business will lose some ability to delay the deployment of each new Windows feature release once version 1903 goes live. When Microsoft first started delivering Windows 10 "as a Service" ... read more...

Azure Content Spotlight – Azure Data Factory
Welcome to another Azure Content Spotlight! These articles are used to highlight items in Azure that could be more visible to the Azure community. This week our content spotlight is about Azure Data Factory. From my experience as a Cloud Architect, moving, ... read more...

Deeper integration and new connector for SSIS in ADF
Expanding our efforts to integrate SQL Server Integration Services (SSIS) deeper into Azure Data Factory (ADF), we have recently improved the configurability of Execute SSIS Package activities in ADF pipelines.   With the enhanced “Settings” tab and ... read more...

Microsoft to launch Visual Studio 2019 on April 2
Microsoft is planning a day-long launch event for Visual Studio 2019, the latest release of its developer platform, on April 2. read more...

Adding Objects to our SCA Project
In my last post, I started out with a new SCA project, getting a connection to my database up and running. Now, let’s start the new project by adding some objects. Adding Objects I’m going to start with a couple objects to make this simple, but we’ll ... read more...

Violin Plots in Power BI
In case you aren’t familiar, I would like to introduce you to the violin plot. A violin plot is a nifty chart that shows both distribution and density of data. It’s essentially a box plot with a density plot on each side. Box plots are a common way ... read more...

DBA Myths: Can a differential backup get bigger than the full backup?
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one until I posted What’s a differential Backup? and Randolph West (b/t) pointed out that my belief that differential backups can’t get larger ... read more...

Partitioning 4: Finding partitioning in DMVs and Object Explorer
Happy Friday! Today’s post will be light on the performance side and instead, I’m going to talk about how to take a look at your server’s partitioning. First, partitioning in SQL Server Management Studio Object Explorer, that thing on the left side of ... read more...

Practical Web Scraping–Getting Started
As part of my learning goals for 2018, I wanted to work through various books. This is part of  my work with Python. After going through a few first chapters, I decided to start my February learning with Practice Web Scraping for Data Science, which ... read more...

Are All Delimited-String Parsers Created Equal?
Overview In short, no.  However, for many years there was no alternative to the T-SQL option, and even when there were other viable options, it was unclear whether it was worth changing existing code to take advantage of the new technologies.  With the ... read more...

How to create and refresh development and test databases automatically, using SQL Clone and SQL Toolbelt
In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build, when there is a proliferation of copies, and the database ... read more...

New Free Videos on SQL Prompt, SQL Compare, and SQL Doc with Redgate’s SQL Change Automation
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials playlist on Redgate’s YouTube channel. These videos step through setting up and working with a project in one of my favorite Redgate tools: SQL Change ... read more...

How to Calculate a Cumulative Percentage in SQL
A fun report to write is to calculate a cumulative percentage. For example, when querying the Sakila database, we might want to calculate the percentage of our total revenue at any given date. The result might look like this: Notice the beautifully ... read more...