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


PowerShell Remoting in Multi-Platform Environments using OpenSSH
This post introduces PowerShell Remoting in Multi-Platform Environments, specifically using OpenSSH. read more...

Finding Queries that Cause Wait Stats in SQL Server
You’ve got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits? Learn the pros and cons of different techniques to track down the cause of both common and tricky waits in SQL Server, including CXPACKET, PAGEIOLATCH, LCK, RESOURCE_SEMAPHORE, and THREADPOOL waits. read more...

Visual Studio Toolbox: SQL Server Data Tools in your DevOps Pipeline
Visual Studio 2017, SSDT and SQL Server 2016/SQL Database (on Azure) can be used in both migration and state based database development approaches. read more...

How To Use Temporal Tables For Easy Point-In-Time Analysis
Have you ever needed to look at what data in a table used to look like? If you have, it probably took a knuckle-cracking filled session of writing group-by statements, nested sub-queries, and window functions to write your time-travelling query. Fortunately SQL Server 2016 introduces a new feature to make our point-in-time analysis queries easy to write: temporal tables. read more...

Now Available: Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform
Data privacy and data security have become one of the most prominent topics in organizations in almost every industry across the globe. New regulations are emerging that formalize requirements around these topics, and compel organizations to comply. The upcoming EU Global Data Protection Regulation (GDPR) is one of the most noteworthy of these new regulations. read more...

Disabling the identity cache in SQL Server 2017
One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable the cache that SQL keeps on identity values by using the ALTER DATABASE SCOPED CONFIGURATION command. read more...

Microsoft Said To Buy Cyberecurity Firm Hexadite for $100 Million
Reports indicate that Microsoft has agreed to buy Israeli cybersecurity company Hexadite for around $100 million. Hexadite uses artificial intelligence (AI) to analyze and address small-scale network attacks, a frequent problem for many large enterprises. read more...

The Biggest Threat To Microsoft’s Future is Artificial Intelligence
Artificial intelligence will not only change how and where compute happens but also the underlying structure of the technology that we use every day. read more...

Microsoft Introduces Low Priority VMs to Cut Batch Processing Pricing
By using low-priority VMs, Microsoft is enabling a way to use Azure Batch with price reductions of up to 80%. read more...

Properly Persisted Computed Columns
A major cause of poor performance is a simple failure to use an indexed or persisted computed column value as expected. read more...

Coming Soon – PowerShell in Azure Cloud Shell
At BUILD 2017, Microsoft announced the preview of Azure Cloud Shell supporting the Bash shell, and are now adding PowerShell support to Azure Cloud Shell, which gives you a choice of shell to get work done. read more...

Microsoft R Open 3.4.0 now available
Microsoft R Open (MRO), Microsoft's enhanced distribution of open source R, has been upgraded to version 3.4.0 and is now available for download for Windows, Mac, and Linux. read more...

Announcing SQL Server 2012 Service Pack 4
Microsoft have announced the last service pack for SQL Server 2012. read more...

Now Available: Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform
The GDPR takes effect on May 25, 2018 and sets a new global bar for privacy rights, security, and compliance. It mandates many requirements and obligations on organizations across the globe. Complying with this regulation will necessitate significant investments in data handling and data protection for a very large number of organizations. read more...

SSRS Subscription Schedules – Enhanced
SSRS provides the capability to review the scheduled reports (subscriptions) in a highly-detailed fashion. This article will dive into the source of this scheduling information within the ReportServer database. read more...

How to compute index numbers at top speed
This article presents different techniques to compute a rownumber column in DAX-based on a specific ranking, comparing slow and optimized approaches. read more...

When a Nonclustered Index and Statistics Make a Query Slower
Nonclustered indexes are awesome in SQL Server: they can get you huge performance gains. But we can’t always create the perfect index for every query. And sometimes when SQL Server finds an index that isn’t quite perfect and decides to use it, it might make your query slower instead of faster. read more...

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role
Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face. read more...

Flaming Hair And The Apocalypse
There will be times when you're approached by someone in a frenzy, their hair seemingly on fire. They'll go on to insist the world will come to an end if you don't handle some task for them immediately. read more...

Announcing HASSP
Oh, you put your database in the cloud? We're putting one through them. read more...