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


Unsharing the Database
Randy Shoup talks about how a shared database has become more of a liability than a benefit as his company has gotten larger. read more...

All Those Little Internets of Things
James M. Connolly shares what he learned in moderating the Interop IoT Summit, and explains why he thinks the current IoT concept covers too many possible use cases. read more...

Microsoft EMS Components: Azure Rights Management
While enterprises create valuable information for their customers or themselves out of their processes, data or the results of applying data to their processes, those components need to be protected. This process is called intellectual rights management. Azure Rights Management is Microsoft’s service that facilitates the protection of information. Diego Samuilov expands on the topic. read more...

Study: Containers Are Great, but Skilled Admins Are Scarce
Michael Cusanelli breaks down a recent study that showed while container solutions are more popular than ever, many companies are still struggling to find the personnel capable of utilizing the new tech. read more...

To own productivity, Microsoft needs to build new tools
Joseph Finney considers why companies like Slack, Hipchat, Trello, Google for Work, Dropbox, and Box are beating Microsoft's own offerings at attracting the next generation of customers. read more...

Google Migrates All Blogspot Sites to HTTPS but Some Features May Not Work
Jef Cozza takes a look at the recent announcement from Google that they're making all the blogs hosted on the Blogspot domain safer by launching an HTTPS version of every existing blog. read more...

IT Innovators: Developing a Data Exit Strategy—What’s Your Next Move in the Cloud?
Christy Peters tackles questions such as "When should a company exit a cloud storage arrangement?", "What are the risks associated with moving data?", and "What is the value of a hybrid cloud deployment?". read more...

New Azure storage account type
James Serra takes a look at the new "Cool Blob Storage" account type in Azure. read more...

Deadlock vs Blocking
Dave Mason illustrates the difference between a deadlock and blocking with a simple example that uses two global temp tables. read more...

How to Script Out Indexes from SQL Server
Sometimes you need to script out all the indexes in a database. Maybe you’re concerned something has changed since they were last checked in, or maybe the indexes aren’t checked into source control, and you’re working on fixing that. Kendra Little shares her solution. read more...

Reconciling set-based operations with row-by-row iterative processing
Paul Randal provides two explanations to the questions "if SQL Server is passing single rows around, how is that set-based operations?". read more...

How to deal with metadata lock
MySQL uses metadata locking to manage concurrent access to database objects, and to ensure data consistency when performing modifications to the schema: DDL operations. In this post, Vineet Khanna looks at common metadata locks on tables and triggers. read more...

Understanding Hyperconverged Infrastructure Use Cases
Technology is forcing fundamental changes in business landscape, and the data center is at the core of these changes. There needs to be a better way to deploy powerful, scalable systems that are integrated and easy to manage. To address this need, a new type of platform has emerged: hyperconverged infrastructure. Bill Kleyman explains. read more...

Writing a ReleaseManagement extension for cloning an existing release definition
Chandan Anjani provides a step-by-step guide to writing a ReleaseManagement extension for cloning an existing ReleaseDefinition. read more...

8 mistakes that can derail your IoT project
The Internet of Things has already begun to shape consumer electronics for the next decade. But every new capability brings new possibilities for failure: when those new capabilities require taking a straightforward product with a simple feature set and connecting it to an entire planet’s worth of digital information and input, things get complicated quickly. read more...

How to Find Blocked Processes
Blocked processes are often a big problem for DBA’s. They're difficult to monitor - we receive desperate calls saying “Everything is slow!” and before we can do anything a second call “Oh, don’t worry, everything's OK again”. Most times it happens because an ill-behaved process is blocking other tasks for a short period. But how can we find this kind of problem? Dennes Torres explains. read more...

Azure Database and Query Store support in ANTS Performance Profiler
If you’re using Azure SQL DB or SQL Server 2016 in your project, now you’ll find it even easier to diagnose database-related performance bottlenecks in your application, by using the execution plan view in ANTS Performance Profiler. Redgate product manager Ben Emmett explains more in his blog. read more...

In-Memory OLTP – Understanding Memory-Optimized Tables
How do you get started with In-memory OLTP? Murilo Miranda first advises on the setup of the server and the other prerequisites, and then, after explaining about the two alternative types of memory-optimised table and their stucture, provides sufficient explanation to enable you to create your first Memory-optimised table. read more...

Automatically Creating UML Database Diagrams for SQL Server
SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. read more...

In-Memory OLTP - Row Structure and Indexes
There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature and usage of memory-optimised indexes. Murilo Miranda continues his series by explaining how such an index is unlike a conventional index read more...