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


ReadyRoll for Database Deployments
The 4th post in the series named SQL Server and Continuous Integration. The first 3 posts covered the need for Continuous Integration (CI), the central part that Git (my version control system of choice) plays in the whole process and an easy way to use Git in Visual Studio. Now that we know how to use our tools, it’s time to use them with ReadyRoll. read more...

Using an ORDER BY in a view
Not only is putting an ORDER BY in a view considered a bad idea it has absolutely no effect. read more...

sp_rename to change schema?
Recently I was asked by a developer whether they could use sp_rename to change the schema of a table. I said no but I realized that I don’t know for sure as I’ve never tried it this way. read more...

Got a EMC DataDomain?
Lessons in speeding up restores after needing to restore a 5TB prod database to rebuild an AG node. read more...

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

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

The Trouble with Data About Data
Data about data -- even from authoritative sources -- may not be as accurate as the people working on the project or the audience believe. read more...

Yahoo Says at Least 500 Million Accounts Breached in Attack
Yahoo! Inc. said the personal information of at least 500 million users was stolen in an attack on its accounts in 2014, exposing a wide swath of its roughly 1 billion users ahead of Verizon Communications Inc.’s planned acquisition of the web portal’s assets. read more...

When heap data pages become linked…
Data pages in a heap are NOT linked together, as there’s no ordering in a heap.However, there is a special case when the data pages in a heap will become linked together in a doubly-linked list…Paul Randal explains. read more...

Build Your Own Tools
There are so many ways to look inside SQL Server. New extended events and dynamic management views are introduced every version. But if you want to collect something that’s unavailable, with a little bit of creativity, you can create your own tools. read more...

Unable to connect to SQL Server on azure VM due to an extra NSG applied to subnet
If you need to open up your SQL Server on an Azure VM to public internet access, then the document "Connect to a SQL Server Virtual Machine on Azure (Resource Manager)" has step-by-step instructions. However, you may run into problems if another NSG was applied to the subnet in which the VM resides. read more...

PSYaml: PowerShell does YAML
PSYaml is a simple PowerShell module that I’ve written that allows you to serialize PowerShell objects to “YAML Ain’t Markup Language” (YAML) documents and deserialize YAML documents to PowerShell objects. It uses Antoine Aubry’s excellent YamlDotNet library. read more...

Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)
Should you always index your foreign keys? What if you index them, and then the index never gets used? read more...

SQL 2016 CU2 is now Available
Microsoft just announced that Cumulative Update 2 for SQL Server 2016 is now available for download here. There are a number of fixes including one I have been looking forward to regarding the Query Store. read more...

DBCC CHECKDB Fails on a Database with files in Azure Blob Storage
Starting with SQL Server 2014 you can use SQL Server with Data Files in Microsoft Azure Blob Storage, but you may run into issues when running scheduled a job or maintenance plan to check for the database integrity. read more...

Generating an SSISDB DACPAC
DACPACs are handy as database references but getting the SSISDB extracted took more than a simple point and click. read more...

What is the weakest link in your security?
Here’s a sobering realization: You can have the most sophisticated computer security in the world and it won’t always protect you. Everything you rely on to keep your confidential data secure can be accidentally undone by one employee—in a matter of seconds. That’s because hackers, more and more, are attacking the weakest link in your cybersecurity—your end users read more...

SQL Server 2016 Report Builder update now available
Report Builder now fully supports Windows “snap” functionality and we also addressed a number of items in this release that were related to creating and editing shared datasets. read more...

Memory/Storage Technology Hierarchy and SQL Server
There is an old network saying which is: “Bandwidth problems can be cured with money. Latency problems are harder because the speed of light is fixed.” Glenn Berry explains. read more...

Determining Database Size in Azure SQL Database V12
A question that is frequently asked by customers using Azure SQL Database is “How can I determine the size of my database programmatically?” Interestingly, different people may be talking about different things when asking this question. read more...