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


Cumulative Update #9 for SQL Server 2017 RTM
The 9th cumulative update release for SQL Server 2017 RTM 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...

The July release of SQL Operations Studio is now available
We are excited to announce the July release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations Studio is a data management tool that enables you to work with SQL Server, ... read more...

How to Test Disaster Recovery Before You Go Live
When I build a server, success means not touching the server again for 2-3 years. I already have enough crappy, unreliable servers that fall over when someone walks past. I only wanna build good, permanent stuff going forward. So when I build disaster ... read more...

$1 million heist on Russian bank started with hack of branch router
A prolific hacking group has struck again, this time stealing close to $1 million from Russia’s PIR Bank. The July 3 heist came about five weeks after the sophisticated hackers first gained access to the bank’s ... read more...

Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)
Reviewed by: Kun Cheng, Borko Novakovic, Jovan Popovic, Denzil Ribeiro, Rajesh Setlem, Arvind Shyamsundar, Branislav Uzelac In this article, we describe database storage architecture on Azure SQL Database Managed Instance (MI), for General Purpose (GP) ... read more...

Microsoft crosses $100 billion annual revenue mark for the first time
Microsoft officials say the company also closed the highest number of multi-million-dollar deals ever across its commercial cloud during its fiscal 2018. read more...

Selecting a Random Row From a Table
A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from a table?’. There are often a few ways of doing this suggested, most seem to rely using CTEs or temp tables.  I thought I’d share, in a quick post a ... read more...

Behavior Change for VSS Backups on VMs with Basic Availability Groups
This week we released SQL Server 2016 SP2 CU2 and SQL Server 2017 CU9. In this blog, I’d like to go into a little more detail on one of the fixes that is part of these CUs which involves the SQL Writer Service. If you are running SQL Server 2016 (or ... read more...

The march of DevOps from the backroom to the boardroom
By encouraging collaboration and teamwork, removing the barriers between development and operations, and introducing automation, DevOps speeds up software delivery and enables features to move from the fingers of developers into the hands of customers ... read more...

Cumulative Update #9 for SQL Server 2017 RTM
The 9th cumulative update release for SQL Server 2017 RTM 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...

Using Process Monitor To Find Out How Much Data Power Query Reads From A File
This post is really just a quick follow-on from my post earlier this week on using Process Monitor to troubleshoot Power Query performance issues with file-based data sources, which I suggest you read before carrying on. I realised, after playing around ... read more...

Data Masker for SQL Server and Temporal Tables
A customer had a question recently about using Data Masker for SQL Server and temporal (or system versioned) tables. I decided to make a quick demo that will show how this works. This is a simple demo, using just a few changes, but the concepts are useful ... read more...

Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio
In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers using SQL Ops Studio (SOS). Before proceeding, you need to have Docker engine installed and SQL Ops studio ... read more...

ALTER TABLE ALTER COLUMN failed because one or more objects access this column
Recently I ran across an issue with manually created statistics objects preventing datatype modification for a column from varchar to nvarchar. This issue occurred because the client has a policy in place where auto create... The post ALTER TABLE ALTER ... read more...

Figuring out a PowerShell version of Dynamic SQL
Next step is wondering if we can avoid SQL/PowerShell injection... read more...

Query Store Training – Portugal
I am so excited to announce that I am presenting a full day of Query Store Training, in-person, this September in Lisbon, Portugal! The SQLskills team will be in London for two weeks in September for a set of Immersion Events (IEPTO1, IEAzure, IECAG, ... read more...

Power BI 101 – Log Files and Tracing
Knowing where log files are and how to turn on debugging is an essential part of any technical job and this goes for Power BI, too.  Remember, as I learn, so does everyone else….Come on, pretty please? Power BI Desktop Log files and traces can be accessed ... read more...

A Very Unproductive Day in the Life of Brent Ozar: July 18, 2018 #SQLCareer
Yesterday, I blogged what I did in a random work day per Steve Jones’ suggestion. And yesterday, I said I’d blog today as well because it was going to be a different schedule. You shouldn’t read this. It’s useless. It’s useless because as I look back ... read more...

TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates to anyone who pays for a plan and sends me a screen shot of a unit test they have written and answer a question on unit testing. I will generate ... read more...

Oracle Patches 334 Flaws in July Critical Patch Update
Oracle releases it largest Critical Patch Update, with security fixes for products across the company's portfolio. read more...