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


Looking at wait stats differently with SQL 2016
Did you know from SQL 2016 you have the ability to work with wait stats at a session level? read more...

Setting SQL Server Maximum Memory
How to a) find out how much physical memory the server has b) calculate what the Maximum Server Memory (MB) should be, then c) call sp_configure to alter the setting. read more...

SQL Server Version Numbers – Do they matter?
It’s a trick question, yes. Your SQL Server version matters! In this post I’ll tell you how to check your version, talk about what makes up the version number and talk about why it matters so much and why you should get a plan in place to regularly upgrade or update SQL Server. read more...

SQL Server 2016 “Hidden Gems” Resources
Adam Machanic collates some useful resources from his SQL Server 2016 “Hidden Gems” talk for the GroupBy online conference. read more...

Core Database Source Control Concepts
Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. read more...

After WhatsApp Vulnerability, Are Any Messaging Apps Truly Secure?
Is there a truly secure messaging app? On Friday it was revealed that attackers could exploit a security vulnerability in WhatsApp to snoop on its users. The vulnerability was found in the service’s implementation of end-to-end encryption, which is supposed to make it all but impossible for messages to be read by anyone except their intended recipient. read more...

Your Favorite Bugs & Enhancement Requests: #TSQL2sday 86 Roundup
Brent Ozar summarizes your favorite SQL Server bugs & enhancement requests, from T-SQL Tuesday 86. read more...

More Detail On Detail Rows Expressions In SSAS Tabular V.Next
Chris Webb explores his second-favorite feature in SSAS Tabular v.next : Detail Rows expression property for measures. It not only brings drillthrough on measures to Tabular, it means that we can define meaningful drillthrough on any measure, no matter how it is calculated. read more...

Six ways to treat your data right
Not everyone understands just how important data is until it is gone. When disaster strikes, and you can’t recover, you are likely to be shown the door…if your company still exists at all. read more...

Identifying Logins with Default Database Connectivity Issues in SQL Server
Tim Ford shows how to identify logins where the assigned default database was dropped after login creation. read more...

Identifying SQL Server Logins without Default Database Users
Tim Ford dissects a case where a client migrated their SQL Server instances from SQL Server 2012 to SQL Server 2016, but didn't do a complete job of migrating over their logins. This caused connectivity issues because some of the logins were missing a corresponding user in their default database. read more...

Columnstore Index Performance: SQL Server 2016 – String Predicate Pushdown
Sunil Agarwal discusses how SQL Server columnstore index processes string data types. read more...

Bug: Incorrect modification_counter for Column Stats on Tables with a Clustered Columnstore Index
Kendra Little finds an issue with how SQL Server tracks and reports on modifications to column statistics on tables with a clustered columnstore index: it reports more modifications than actually occurred (and for columns that weren’t modified). read more...

Don't Design Databases Without Foundation Knowledge and Conceptual Models
Fabian Pascal dissects a design that seeks to " avoid tight coupling between the tables...by storing the primary key value in the child table." read more...

Columnstore Index Performance: SQL Server 2016 – Window Aggregates in BatchMode
SQL Server 2016 introduces BatchMode execution model for aggregates computed over a set of rows defined by Over Clause. A set of rows so defined is referred to as ‘window’ and the aggregates are being computed on this set of rows are referred to as Window Aggregates. read more...

Animated barplot and google map with R
It might happen that you will need a animated graph of any kind. For purposes of plotting demographic data and changes through the years, Google Maps and plotting maps, merging and converting jpg files into a animated gif, sure will give a nice visualization effect. read more...

What is COPY_ONLY?
Did you know, for example, that a COPY_ONLY full backup can be used as the base for a log backup but not a differential? read more...

Case study: Troubleshooting Doomed Transactions
Michael J Swart investigates why a doomed transaction was still trying to do work. Summary? Don’t program in T-SQL. Avoid triggers. Extended events are awesome. read more...

Replication: Snapshot Agent fails on date conversion
Having setup replication from an on-premise SQL Server instance to an Azure SQL database, Jeffrey Verheul is stopped in his tracks by a strange bug. read more...

SQL Server Firewall Settings: A Complete Guide
How to configure a firewall for SQL Server using SQL Server configuration manager. read more...