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


The Top Three Barriers to Cloud Adoption and What to Do about Them
Kong Yang talks through how to deal with security and compliance concerns, support for legacy systems, and budget limitations when implementing cloud services. read more...

CPU Scheduling Basics – Windows and SQL Server
Anthony Nocentino introduces the basics of CPU scheduling in Windows and SQL Server so that when you see things slow down in either of one of these technologies you know where you can start to look first. read more...

Ask the CTO: Measuring team performance
The former head of engineering at Rent the Runaway, Camille Fournier, looks at how to measure the success of an engineering team. read more...

Docker Containers as the new Binaries of deployment
Microsoft's Steve Lasker briefly explains the benefits of using containers compared to VMs read more...

Dear SQL DBA – Bleeding In Edgeville
Kendra answers a question about early adoption of SQL Server, discusses why testing in production isn’t necessarily crazy, and recommends how to handle requests to upgrade your SQL Server to use new features. read more...

How to Query Comma Seperated Value Columns in SQL
Karthik provides a simple solution to querying a table that has comma separated values. read more...

How to version a SQL Server Master Data Services model
In SQL Server Master Data Services all the entities are organized in a model. Once a model is ready to be released to subscribers, it should be frozen and marked as ready for subscribers. Until a model is marked as ready, a model is typically deemed as work in progress. In this article, Siddarth Mehta covers the standard process that's required to release a completed version of the model to subscribers. read more...

SQL Server AlwaysOn Endpoint Encryption Algorithm Compatibility Error
Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard. read more...

Getting Started with the Query Store Feature in SQL Server 2016 – Part 1
Arshad Ali discusses SQL Server 2016 Query Store and how it greatly simplifies the performance troubleshooting process. In the first part of the series, he explains what the Query Store is, how it works, and when you might use it. read more...

Using design patterns to find greater meaning in your data
Julie Rodriguez and Piotr Kaczmarek talk about how visualizations that show comparisons, connections, and conclusions offer analytical clarity. read more...

SQL Server Random Workload Generator
Bradley Ball shares his own Random Workload Generator, and talks through how and why he tweaked the original created by Jonathan Kehayias a few years ago. read more...

Understanding the Database Options - AutoClose
Vitor Fava looks at how AutoClose property works, and why it's recommended you disable it. read more...

How Oracle made its case against Google, in pictures
Oracle's lawyers have made their final pitch to paint Google as a copyright outlaw, and the decision is now up to a 10-person jury. Joe Mullin gives some more details on the case and presents some of the slides used in the closing statement of Oracle attorney Peter Bicks. read more...

Why DBAs Need to Know about Kerberos
Though most DBAs don’t have the permissions to change the settings in Active Directory (AD) that affect Kerberos, it's still a good idea to understand Kerberos authentication so that you can help troubleshoot issues that come up. Kathi Kellenberger demonstrates how to see the settings, and what happens when you change the service account. read more...

The Future of Analytics: Collaboration, Deep Learning, and Telling the Story
Dr. Athanasios Gentimis’ field of expertise is Algebraic Topology, with a special interest in Geometric Group Theory. In a recent DATAVERSITY interview, Dr. Gentimis discussed how analytics is changing and what the future might look like. read more...

Oracle Announces 5 Key Enhancements to NoSQL Database
Oracle is introducing a major new release of its NoSQL database - version of 4.0. Joyce Wells runs through the five key talking points of the new release. read more...

Intel’s internal IoT platform for real-time enterprise analytics
Moty Fania, principle engineer for big data analytics at Intel IT, talks through the company's internal IoT platform read more...

Database Restore Fails with Msg 3154
Have you ever tried to restore over an existing database only to receive an Msg 3154 error message? You could easily avoid this error by using the WITH REPLACE option in the RESTORE DATABASE command, but we want to know why this error occurs and how SQL Server knows they are not from the same family. The answer is the database_guid, Patrick Keisler explains. read more...

Observations and thoughts on the LinkedIn data breach
Microsoft Regional Director and MVP, Troy Hunt, shares his thoughts on the LinkedIn data breach, talks about HIBP, and discusses the broader issues related to searchable breach data. read more...

Query Optimizer Additions in SQL Server 2016
Gjorgji Gjeorgjievski summarizes the Query Optimizer improvements coming to SQL Server 2016, and explains how you can leverage the benefits of these new enhancements. read more...