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


Redgate at SQLServerGeeks Annual Summit 2016 – Bangalore
For the first time this August, the Redgate team are heading to SQLServerGeeks Annual Summit 2016. Catch some great sessions from Grant Fritchey and Alex Yates over the three days, or just stop by and say hello at the booth. With 5 tracks, over 100 sessions, and multiple deep dive pre-con seminars, Asia’s only Data Platform conference is an event you do not want to miss! There’s only a few weeks to go, so get your tickets now. read more...

Source Control for the Reluctant DBA
In the second part of his ongoing SQL Server and Continuous Integration series, James Anderson looks at using the version control system Git with SQL Server. read more...

Redgate’s 2016 roadmap
What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more. read more...

SQLSaturday #513 - Albany 2016
Albany, NY. Jun 30, free training. read more...

Trace Flag 2389 and the new Cardinality Estimator
One of the SQL Server trace flags that’s been around for a while is 2389.  It’s often discussed with 2390, but I just want to focus on 2389 for this post.  The trace flag was introduced in SQL Server 2005 SP1, which was released on April 18, 2006 (according ... read more...

Introducing the Microsoft Data Science Summit, Sep 26-27
Microsoft has a brand-new conference, exclusively for data scientists, big data engineers, and machine learning practitioners. The Microsoft Data Science Summit, to be held in Atlanta GA, September 26-27, will feature talks and lab sessions from Microsoft ... read more...

SQL 2016 SSIS new feature AutoAdjustBufferSize
If you have not already seen in the What’s New in Integration Services list there is a new property for Data Flows that is called AutoAdjustBufferSize.  Why is this important and what does it actually do? First, let’s remember that in SQL 2014 we had ... read more...

Another Query to Help Find the Right Event
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to Extended Event Help Queries, I will ... read more...

Understanding SQL Server 2016 Backup Options
Maximum availability is the goal for almost all enterprise database implementations. To achieve that availability, you need to implement a layered approach to your infrastructure. First, you need to build your infrastructure out on an enterprise-level ... read more...

Creating Ranked Position Time Series with SQL
The Los Angeles Lakers were the top NBA team in 2008 but the last in 2016. We wanted to compare their downfall to the rise of other teams in the league, so we built a comparison of each team’s rank in the standings over the past ten years. Let’s explore ... read more...

Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)
You finally got approval to move to new hardware and a fresher version of SQL Server. After months of work,  you do the migration and then… performance gets worse. What can cause this, and what do you look for? This is a “listen-able” 27 minute video. read more...

Calculating SQL Saturday Distances
A couple of days ago, Argenis Fernandez put up a notice that PASS is changing the rules for SQL Saturdays: The first change we are going to make is to the amount of funding support we provide organizers. Currently any organizer, whatever the size of ... read more...

Unit testing anti-patterns: Structural Inspection
This post is about the practice of Structural Inspection in unit testing and why I personally consider it an anti-pattern. Structural Inspection But first, let me explain Structural Inspection itself. Structural Inspection is generally about writing ... read more...

Growth or Control – #sqlpass
I’m disturbed. I read an announcement from the PASS organization this week that bothers me. I am less upset with the content than the manner in which it was presented, though I am not pleased with either. Making SQL Saturday Sustainable was released ... read more...

Building SSIS packages using the Biml object model
Programmatically building SSIS packages via the Biml Object Model I thought it might be fun to try and figure out how to use the Biml Api to construct SSIS packages. This post is the first in the occasional series as I explore and find neat new things. read more...

Why am I in a data breach for a site I never signed up to?
This question in the title of this post comes up after pretty much every data breach I load so I thought I'd answer it here once and for all then direct inquisitive Have I been pwned (HIBP) users when confusion ensues in the future. Let me outline a ... read more...

Paying Attention to Estimates
Last week I published a post called #BackToBasics : DATEFROMPARTS(), where I showed how to use this 2012+ function for cleaner, sargable date range queries. I used it to demonstrate that if you use an open-ended date predicate, and you have an index ... read more...

Use Catalog Compare to Migrate to the SSIS 2016 Catalog
I recently tried to use the SSISDB Upgrade Wizard to upgrade a restored SSISDB (backed up in an earlier version) to SQL Server 2016. It didn’t go well. I decided to use SSIS Catalog Compare to generate the scripts and ISPAC files from the previous instance, ... read more...

Columnstore Index: Differences between Clustered/Nonclustered Columnstore Index
SQL Server 2016 provides two flavors of columnstore index; clustered (CCI) and nonclustered (NCCI) columnstore index. As shown in the simplified picture below, both indexes are organized as columns but NCCI is created on an existing rowstore table as ... read more...

Columnstore Index: Parallel load into clustered columnstore index from staging table
SQL Server has supported parallel data load into a table using BCP, Bulk Insert and SSIS. The picture below shows a typical configuration of a Data Warehouse where data is loaded from external files either using BCP or SSIS. SQL Server supports parallel ... read more...