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


PASS Summit 2014: Inside the World’s Largest Gathering of SQL Server and BI Professionals
PASS VP of Marketing Denise McInerney – a SQL Server MVP and Data Engineer at Intuit – began her career as a SQL Server DBA in 1998 and attended her first PASS Summit in 2002. The SQL Server Team caught up with her ahead of this year’s event, returning to Seattle, WA, Nov. 4-7, to see what she’s looking forward to at the world’s largest conference for SQL Server and BI professionals. read more...

Interviews: Going Beyond the Technical Quiz
In addition to the usual questions challenging the candidate’s knowledge of such things as b-trees, object permissions, database recovery models, and so on, sit the candidate down with the other database developers or DBAs. Arm them with a copy of Management Studio, and a few other tools, then challenge them to discover the flaws in a stored procedure, and improve its performance. read more...

Microsoft comes clean on 'weird things' in Windows Server 2012 R2, Server 2003
Microsoft issues a warning on a Windows Server conflict that's a model of clarity and insight. Yes, that Microsoft. read more...

Best SSDs: July 2014
Current SSD recommendations, split into different categories by form factor and performance. read more...

The clustered index columns are in all of the non clustered indexes
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. Let’s take a look! read more...

How to track inactive logins in SQL SERVER
A technique that involves auditing successful logins for a certain period, so that they are written to the error log,and then importing the data to a tracking table. read more...

Microsoft SQL Replication Between Windows Azure Virtual Machines
Chris Skorlinski explain how to use SQL Server Replication technologies to move data between local on premises SQL Server to SQL Server running in Windows Azure Virtual Machines or between Windows Azure Virtual Machines. read more...

Too many single use plans, now what?
Let's assume a great deal of memory is being taken by single use plans – say, 10% of total committed memory. What can we do about it? read more...

Size Matters: Keep Model Small
I recently discovered an undesirable behavior of SQL Server on a brand new SQL 2008R2SP2 cluster. If the cluster failed over once it was fine. If it was immediately failed back to the original node, it would hang when taking SQL Agent offline. read more...

Transitioning from SMP to MPP, the why and the how
Emma is the Database Administrator at Adventure Works Cycles, a bicycle manufacturing company. At Adventure Works, Emma and her team are using traditional SQL Server SMP as their data warehousing solution. The company has been growing rapidly and with growing competition in the bicycle industry, the business analysts at Adventure Works Cycles would like quicker insight into their data. read more...

Announcing the “100 Days of DevOps with PowerShell” Series
Starting August 1st, a team of my friends and colleagues from the community and I are going to begin sharing with you concepts, tips, tricks and examples of how to implement and support DevOps with Microsoft tools and technologies. read more...

SQL Monitor Custom Metric: Schema Modified
This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified. read more...

Calculating The Value Of Overdue Invoices Using Many-To-Many Relationships in SSAS Multidimensional
How can you calculate the value of your overdue invoices on any given date? Not just invoices that are overdue today – we want to be able to pick any date in the past and find out the value of invoices that were overdue at that point in time. read more...

Why do we need UPDATE Locks in SQL Server?
Klaus Aschenbrenner on Update Locks in SQL Server, and why they are needed to avoid deadlock situations and decreased concurrency. read more...

How to Edit Read-Only Non-clustered Columnstore Data
Creating a non-clustered Columnstore index will make the index as well as the base table read-only, which means you can’t insert, update, or delete any data until your drop the index. Patrick Keisler describes two methods you can use to edit your read-only data. read more...

What’s New in Oracle 12.1.0.2?
Oracle 12.1.0.2 was recently released with some fanfare. One of the most talked about features is Oracle Database In-Memory, but there’s more to this release than just columnar storage. read more...

Using Triggers to Automatically Add Indexes
Let’s say you’ve got a vendor application that creates tables, loads them, queries them, and drops them all the time. You can’t change the code. The tables involved desperately need an index in order to go faster, and they’re your biggest performance bottleneck. Enter DDL triggers. read more...

Scripting out Contained Database Users
Argenis Fernandez demonstrates that you can, indeed, script out contained database users and recreate them on another database, as either contained users or as good old fashioned logins/server principals. read more...

The 2008 R2 Bug Fix That Breaks RCSI
One of the fixes included in Cumulative Update 11 for SQL Server 2008 R2 Service Pack 2 addresses an "incorrect deadlock" that can occur in a specific scenario (explained later in this article). Unfortunately, the fix introduces a new bug, where SELECT queries under RCSI (read committed snapshot isolation) start taking table-level intent-shared locks. read more...

Clustered Column Store Index: Bulk Loading the Data
This blog describes locking behavior when data is inserted through Bulk Load command, when using a clustered column store index read more...