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


Samsung Unveils 8TB Small Form Factor SSD for Data Centers
Samsung’s is an SSD that has been optimized for data-intensive analytics and virtualization applications in next-generation data centers and enterprise server systems. read more...

SQL SERVER – Save Auto Recover Information – SSMS
Though, I have many complaints about SQL Server Management Studio (SSMS) (read the latest one here), I also like some of the features for sure. In this blog post, we will take about Auto Recover feature of SQL Server Management Studio. This is one of ... read more...

SSMS 17.8 is now available
This post is co-authored byPam Lahoud, Senior Program Manager, SQL Server. We are excited to announce the release of SQL Server Management Studio (SSMS) 17.8! Download SSMS 17.8 and review the Release Notes to get started. SSMS 17.8 provides support ... read more...

Announcing My @DevIntersection Pre-Con: Developer’s Guide to SQL Server Performance
You’ve built an application that uses SQL Server or Azure SQL DB as a back end, and it’s starting to get popular. Unfortunately, the queries just aren’t returning data fast enough. You’ve run a few diagnostic queries, but you’re overwhelmed with conflicting ... read more...

Cumulative Update #8 for SQL Server 2017 RTM
The 8th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing ... read more...

A guide to working with character data in R
R is primarily a language for working with numbers, but we often need to work with text as well. Whether it's formatting text for reports, or analyzing natural language data, R provides a number of facilities for working with character data. Handling ... read more...

Creating Slopegraphs with R
Presenting data results in the most informative and compelling manner is part of the role of the data scientist. It's all well and good to master the arcana of some algorithm, to manipulate and master the numbers and bend them to your will to produce ... read more...

More Details On The RowsetSerializationLimit Server Property For Analysis Services
The recent blog post on the Analysis Services team blog about new memory options contained information about some very interesting functionality that has just been added. The first of the new features I decided to try was the RowsetSerializationLimit ... read more...

Overview of SQL Server 2017 Docker containers on Linux machine
SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the freedom that it gives to install the product anywhere. The advent of the Docker containers and growing emphasis on open source solutions ... read more...

Overview of File-group(s) and Piecemeal database restore operations in SQL Server
So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series, we are going to discuss, the file-group and piecemeal database backup and restore process. Database “Backup and Restore” strategies ... read more...

AVG() in TSQL: Watch Your Data Types
This week’s Quizletter featured a quiz on using the AVG() function in SQL Server. I was inspired to write this quiz because I’ve been teaching TSQL School each week. When we covered aggregate functions, I remembered just how tricksy and non-average that ... read more...

Updating Statistics with Ola Hallengren’s Script
I am a HUGE fan of updating statistics as part of regular maintenance.  In fact, if you don’t know if you have a step or job that updates out of statistics on a regular basis, go check now!  This post will still be here when you get back At any rate, ... read more...

Impact of FULL Scans in your SQL Server DB
Full scans of a HEAP or Clustered index in SQL Server aren’t necessarily a bad thing.  But sometimes they are scanned because the Query Optimizer (“Optimus” here at Dallas DBAs HQ) cannot find a suitable index to use.  Sometimes its just because the ... read more...

Fun with DAX – Sudoku
Carrying on from my recent article on how to build a game of Blackjack using Power BI and DAX, this time I thought I would see if I could build a fully playable game of Sudoku. A big thanks to my good friend Tom Martins over at minceddata  for giving ... read more...

Line Breaks And Auto-Indent In The Power BI DAX Formula Bar
The other day I discovered something new (at least to me) while writing the DAX for a measure in Power BI Desktop: when you insert a new line in your DAX expression using SHIFT-ENTER it also auto-indents the code. read more...

Building a SQL Azure Database from TeamCity
I’m in the process of setting up a new environment using Azure SQL Databases, previously in Azure we’ve just used an Azure VM with SQL Server on it.  I’m also fairly new to setting up a Continuous Integration environment and in-house we use Team City, ... read more...

SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin
While I was writing my earlier blog, I came across another interesting issue with sp_help_revlogin script. In this blog we would learn about the cause of Msg 15419, “Supplied parameter sid should be binary(16)” while transferring the login using sp_help_revlogin ... read more...

The June release of SQL Operations Studio is now available
We are excited to announce the June release of SQL Operations Studio is now available. Download SQL Operations Studio and review the Release Notes to get started. SQL Operations Studio is a data management tool that enables you to work with SQL Server, ... read more...

Database subsetting. What it is, what it’s for, and why we’d love to hear from you.
We’re looking into database subsetting, and if you need it or are investigating it, we want to hear from you. Please get in touch below. What is database subsetting? Database subsetting is creating a copy of a database that contains only a portion of ... read more...

Dates and Times in SQL Server: DATENAME()
Last time we looked at DATEPART(). This post is all about the DATENAME() function. So many similarities There are many similarities between DATEPART and DATENAME. Where DATEPART returns the date or time part as an integer, DATENAME returns the part as ... read more...