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


When should I add an Index?
Kenneth Fisher offers his general rules of thumb for when and when not to add indexes. read more...

SQLCLR in SQL Server 2017
Microsoft is recommending enabling “CLR Strict Security” in SQL Server 2017, which means users cannot create any CLR assemblies unless they have elevated permissions. This could be a breaking change anywhere you want to use dynamic CLR. read more...

SQL Server 2017: Unpublished Gems
Erik Darling uncovers some new stuff in SQL Server that they don't mention in the release notes. read more...

Table Column Differences with T-SQL and PowerShell
We've identified the tables with similar structure, but what about if we want to know which column names match exactly? read more...

Is it ever worth adding indexes to table variables?
Erik Darling discovers that regular ol’ join simplification can help the optimizer 'optimize away' a table variable operator. read more...

Creating Active Directory User Accounts with ADSI and PowerShell
The Active Directory module from RSAT is the way to go but sometimes you may want a bit more control. You also may have a need to roll your own tools. Today, I want to give you some ideas on how to create user accounts using LDAP and ADSI. read more...

Cumulative Update #5 for SQL Server 2014 SP2
The 5th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. read more...

Power BI and Data Security - Row Level Security
Row level security is the ability to filter content based on a users role. There are two primary ways to implement row level security in Power BI – through Power BI or using SSAS. read more...

Delivering AI with data: the next generation of Microsoft’s data platform
Joseph Sirosh announces the close integration of AI functions into databases, data lakes, and the cloud to simplify the deployment of intelligent applications. read more...

Graph Data Processing with SQL Server 2017
Graph extensions are fully integrated in the SQL Server 2017 engine. This article introduces two new types of tables in SQL Server 2017 databases, Node and edge tables, as well as the new MATCH clause for pattern matching and navigation. read more...

Introducing Batch Mode Adaptive Joins
SQL Server 2017 and Azure SQL Database introduce a new set of adaptive query processing improvements, such as batch mode memory grant feedback, batch mode adaptive joins, and interleaved execution, to help fix performance issues that are due to inaccurate cardinality estimates. In this post, we’ll introduce batch mode adaptive joins. read more...

Using and optimizing DirectQuery in PowerBI and SSAS Tabular
Marco Russo explains the right and wrong reasons to use DirectQuery. read more...

SQL Server 2017 Community Technology Preview 2.0 now available
SQL Server 2017 CTP 2.0 adds a number of new capabilities, including the ability to run advanced analytics using Python in a parallelized and highly scalable way, the ability to store and analyze graph data, the Adaptive Query Processing family of intelligent database features and resumable online indexing. read more...

Mandatory ISP data retention and the law of unintended consequences
Well, good one Australia, UK and whoever else has embarked on this hare-brained scheme, you've just made things a whole lot worse. read more...

Wanna speak at the PASS Summit? Here’s how
The PASS Summit is the biggest SQL Server community event, and a lot of us speakers have “present at PASS” on their bucket list. it means getting in is legendarily difficult because competition is fierce. Brent Ozar shares what he's learned over the years about getting sessions accepted. read more...

How to Join the SQL Server Community Chat in Slack
Brent Ozar brings to our attention the Chat rooms at SQLcommunity.Slack.com. read more...

What are different ways to replace ISNULL() in a WHERE clause that uses only literal values?
If you have a query where ISNULL() is used in the WHERE clause to replace NULL values with a canary value for comparison to a predicate, what are ways to rewrite it to make it more efficient, and perhaps even SARGable? read more...

Blob Auditing for Azure SQL Database
While auditing features were available before in Azure, Blob auditing is a huge leap forward, especially in having more granular control over what audit records are captured. read more...

SQL Server 2014 SP2 Cumulative Update 5
Microsoft has released SQL Server 2014 Service Pack 2 Cumulative Update 5, which is Build 12.0.5546.0. There are 24 hotfixes in the public fix list. read more...

SQLskills SQL101: Using DDL Triggers
Glenn Berry explains why he thinks it a shame that many people actually use Data Definition Language (DDL) triggers on their systems. read more...