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


Major new study reveals the true ROI of database DevOps
Redgate has launched a new research study that reveals the benefits different stakeholders can expect from DevOps, and provides a powerful methodology for calculating the ROI of database DevOps. read more...

Extending DevOps practices to SQL Server databases with ReadyRoll and VSTS
Microsoft MVP Steve Jones, and Redgate’s Tom Austin, will show you how Redgate’s Database DevOps solution works to improve your database development and deployment processes. In this demo heavy session you’ll see how Redgate’s SQL Toolbelt allows you to take a local development database, source control it, set up automated builds and automate deployments to an Azure SQL database in less than an hour using VSTS. There will also be plenty of time to ask Steve and Tom questions. read more...

Free virtual event: SQL in the City Streamed
Technical sessions will dive into the latest Microsoft SQL Server releases, and cover topical issues such as data compliance, protection & privacy. read more...

How to Customize Schema Comparisons using Auto Map in SQL Compare
SQL Compare includes many options to make comparing objects easier on the developer. Auto mapping is one of these, and if often saves a little time and frustration. However, there are times that you many need to customize your mapping, and this gives you a technique for doing so. read more...

5 tips for achieving continuous delivery
If you’re struggling to set up a reliable, repeatable release process you’re not alone. The good news is that most of the problems you’ll encounter have been solved before. read more...

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...