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


Microsoft Releases Preview of GDPR Compliance Dashboard
With the European Union's General Data Protection Regulation is set to go into effect in a little over six months, Microsoft's cloud customers can start evaluating their readiness now. read more...

Free Upcoming Webcasts: Query Store, R, AGs, Encryption, Security, and More
Here’s the lineup for the next free GroupBy online conference: Friday, December 1: 8:00 AM Eastern – Query Store and Query Optimization on SQL Server 2017 by Dean Savovi? 9:00 – Elegant T-SQL Solutions for Real World Problems by Matan Yungman 10:30 ... read more...

Redgate data governance survey reveals database DevOps is the key to GDPR compliance
A major new data governance survey from Redgate demonstrates there are important GDPR compliance issues that need to be addressed – and that a DevOps approach to database development can provide the answers. A first glimpse into the results of the 2017 ... read more...

Tesla promises a new wicked-fast $200,000 Roadster
Tesla HAWTHORNE, CALIF.—At tonight's Tesla Semi event we got a lot more than a vague truck design. After a short presentation of the Semi's intended specs, one of the trucks backed onto the stage and a new red Roadster rolled out. "The foundation of ... read more...

Converting natural gas to hydrogen without any carbon emissions
Enlarge / Hard to believe that this stuff could cut carbon emissions. (credit: Department of Energy) The boom in natural gas production has been essential to the drop in carbon emissions in the US, as methane, the primary component of natural gas, releases ... read more...

The wrong way of benchmarking the most efficient integer comparison function
On StackOverflow, there's a question about the most efficient way to compare two integers and produce a result suitable for a comparison function, where a negative value means that the first value is smaller than the second, a positive value means that ... read more...

The City of Chicago uses R to issue beach safety alerts
Among the many interesting talks I saw a the Domino Data Science Pop-Up in Chicago earlier this week was the presentation by Gene Lynes and Nick Lucius from the City of Chicago. The City of Chicago Tech Plan encourages smart communities and open government, ... read more...

How does Query Store capture cross database queries?
When I was writing my post  Capture the most expensive queries across your SQL Server using Query Store a question crossed my mind: Query Store is a configuration that is enabled per database, and the plans and stats for queries executed in that database ... read more...

Can I pause or resume an index rebuild operation?
One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database) is the option to pause and resume an online index rebuild operation. This option can be useful for several use cases. Imagine you have a very ... read more...

Training Day in London: Building Better SSIS Packages
I am delighted to announce that I’ll be delivering my full-day course, Building Better SSIS Packages, at the SQLBits conference in London on Thursday, February 22nd. This course is aimed at data professionals with experience in SQL Server and a general ... read more...

Geek Sync Recording: Taking Control of Your SQL Server Sprawl
Back in July, I gave a webcast for Idera’s Geek Sync. They’ve published the recording. You can find it here: Take Control of Your Organization’s SQL Server Sprawl It’s about an hour long and it focuses on automation, setting up sized templates for servers, ... read more...

Post-WannaCry, White House Clarifies Approach to Vulnerability Disclosure
The government is starting to open up around how it decides which security vulnerabilities to disclose. read more...

Oracle Issues Emergency Patch to Plug JoltandBleed Vulnerability
Patches plug five vulnerabilities plaguing Big Red's Tuxedo application server, including one offering remote server access. read more...

SQL Server Service Broker – Security  
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine. Previous posts: SQL Server Service Broker – Introduction SQL Server Service ... read more...

Using Your Data Corpus to Further Digital Transformation
Every day we see freshly created data streams. From new mobile apps, to new connected appliances and automobiles, to new business applications capturing information from all corners of the ... read more...

SQL Prompt Hidden Gem: Auto-fill the GROUP BY clause
Once you install SQL Prompt, you become aware immediately of how it enhances the native IntelliSense features of SSMS, but this can blind you to a lot of other features, hidden in various parts of the tool. In this post I share another gem of a feature that I found myself using frequently once I realize it existed! read more...

Redgate data governance survey reveals database DevOps is the key to GDPR compliance
A major new data governance survey from Redgate demonstrates there are important GDPR compliance issues that need to be addressed – and that a DevOps approach to database development can provide the answers. read more...

ASP.NET Core Tag Helpers for Bootstrap
The ASP.NET Core tag helpers improve on the HTML templated helpers in ASP.NET MVC 5. ASP.NET Core comes with some useful stock tag helpers for common tasks such as creating custom elements or extending existing HTML elements, but their use can be extended to making a framework such as Bootstrap easier to work with. Dino shows how helpers are used, and demonstrates a Bootstrap Modal Tag Helper read more...

Questions About the GDPR That You Were Too Shy to Ask
The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask. read more...

The Power of Three and the Wooden Computer
The mystery of one of the almost-forgotten pioneers of the computer starts Phil Factor on a quest to explore and simulate in SQL the arithmetic operations of the lost wooden computer of Thomas Fowler. It is a homage to a little-known genius and an illustration of some curious SQL techniques. read more...