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


New Laws Needed for Govt. Access to Cloud Data, Google Says
Current laws are outdated and are hindering access to data and threatening user privacy, the company says. read more...

Building the culture and collaboration layer for DevOps
Sean Regan says DevOps requires more than tools. It also needs high-performing people and teams.Continue reading Building the culture and collaboration layer for DevOps. read more...

Lessons learned from building a globally distributed database service from the ground up
Dharma Shukla covers Azure Cosmos DB, a massively scalable, multitenant, globally distributed database service.Continue reading Lessons learned from building a globally distributed database service from the ground up. read more...

SQL SERVER – Msg 3168, Level 16 – The Backup of the System Database on the Device Cannot be Restored
In the recent past, I have written a blog about Ransomware. Here is the link. SQL SERVER – How to Protect Your Database from Ransomware?. In this blog post we are going to discuss about system database. read more...

You’re not delivering DevOps to the database
I’ve read through a number of the industry thought leaders to get an understanding of how DevOps is being communicated out there. As with so much else in life, you can start at Wikipedia to get a general understanding: DevOps … is a term used to refer ... read more...

Seldom Used Keyboard Tricks
I was giving an internal talk on SSMS productivity trips and there were a few that I believe are seldom used but can be a real time or keystroke saver that I would like to mention. To the best of my knowledge these will work in any version of SSMS...(read ... read more...

Interactive R visuals in Power BI
Power BI has long had the capability to include custom R charts in dashboards and reports. But in sharp contrast to standard Power BI visuals, these R charts were static. While R charts would update when the report data was refreshed or filtered, it ... read more...

From the NFL to MIT: The Double Life of John Urschel
Whether he’s blocking a 300-pound defensive lineman or hitting the math books, this doctoral candidate just won’t quit. read more...

Working on my Microsoft Professional Program for Data Science
Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their daily life.  It consists of nine courses and a final project, you can get all the details about it on the Microsoft Academy site.  I started ... read more...

Modeling an Adjacency List Hierarchy with SQL Server 2017 Graph Database
The Northwind database implements the manager to employee hierarchy using an adjacency list, which is a type of graph. This post shows you how to migrate the adjacency list to a graph of one node and one edge. This is a continuation of what was started ... read more...

New Data Driven Episode: Rimma Nehme on CosmosDB, Planet-Scale Applications, and Selling Door-to-Door
This week on Data Driven , Frank and I are honored to interview Rimma Nehme , CosmosDB Architect at Microsoft. We had a fantastic time chatting about CosmosDB , open-source, reading, and what (or whom, rather) Dr. Nehme finds really important. As always ... read more...

Modeling Many-to-Many relationships in SQL Server 2017 Graph Database
Relational databases do not natively support many to many relationships although a junction table is an easy workaround. Graph databases natively support many-to-many relationships. One of the first sample databases Microsoft provided for SQL Server ... read more...

SQL 2016 – Temporal Tables – Triggers and Historical Data Tidbits
Hello again and welcome back to the series on Temporal Tables! Today we will take a look at two common questions.  What happens when I put a trigger on a Temporal Table and can I back populate the historical table?   Setup First thing’s first, let’s ... read more...

Is Continuing to Patch Windows XP a Mistake?
Last week, Microsoft issued a security patch for Windows XP, a 16-year-old operating system that Microsoft officially no longer supports. Last month, Microsoft issued a Windows XP patch for the vulnerability used in WannaCry. Is this a good idea? This ... read more...

NSA Insider Security Post-Snowden
According to a recently declassified report obtained under FOIA, the NSA's attempts to protect itself against insider attacks aren't going very well: The N.S.A. failed to consistently lock racks of servers storing highly classified data and to secure ... read more...

DevOps and incident management: A recipe for success
David Hayes explains why DevOps is now a requirement for success and he outlines challenges all DevOps teams will face over the next five years.Continue reading DevOps and incident management: A recipe for success. read more...

Perception and bias and metrics, oh my!
Dawn Parzych shows how understanding assumptions and biases can help your organization. Continue reading Perception and bias and metrics, oh my! . read more...

A scalable time-series database that supports SQL
The O’Reilly Data Show Podcast: Michael Freedman on TimescaleDB and scaling SQL for time-series.In this episode of the Data Show, I spoke with Michael Freedman, CTO of Timescale and professor of computer science at Princeton University. When I first ... read more...

Asus Releases XG-C100C 10GBASE-T NIC For $99
Asus rounded out the 10GbE ecosystem today with a desktop add-in network interface card to go with the previously released xg-U2008 switch. For less than $100 you get massive bandwidth with priority queuing for enhanced gaming support. read more...

SQL SERVER – Upgrade Failure – The Cluster Resource is Not Online. Bring the Analysis Services Server Online Before Starting the Upgrade Process
Many customers want to do in-place upgrade of SQL Server instance to avoid the hardware cost and downtime. There are various pros and cons for doing in-place upgrade or parallel upgrade and one need to evaluate them before making a final choice. Let ... read more...