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


DBA Reminders from an FAA Fire
Last Friday a long time employee set fire to the FAA’s Chicago Control Center. You can read about the fire and the 2,000+ flight cancellations that resulted  here and here. Keeping with the spirit of ripping lessons from headlines like I did in last ... read more...

PASS Rocks SQL Saturday
I had another piece that looked at some issues with PASS slated for today, but it’s been a tough morning. Both with work, and with the conflict with PASS, so I’m going to move this up and give PASS more praise. As conflicted as I am about the organization, ... read more...

PASS got it right
This morning I received an email (really 3 emails) about an extension for voting for the Board of Directors giving anyone registered with PASS before June of 2014. I think this is fair and gives those that have been active, but did not update their profile ... read more...

Database default locations
One of the options you had when installing your instance was setting some default file locations. Defaut data file location Default log file location Default backup file location   If you are new to installing SQL Server (and even if you aren’t) you ... read more...

A real life table variable performance problem.
TweetG’day, I’m sure we’ve all heard and read about the differences between table variables and temporary tables. In case you haven’t here’s one of many articles that you can read on the subject. Anyway, there is a business process in one of my databases ... read more...

The Fallacy of Internal Access Only
In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only through the management interface but everything is okay because if best practices have been followed, the management interface isn’t/hasn’t ... read more...

Advanced DAX Workshops in the upcoming months –#dax #tabular #powerpivot
The adoption of DAX is slowly growing and we can see that from comments to article, blog posts, web site traffic (including DAX Formatter usage). For this reason, the demand for more advanced training about DAX is also increasing. We had great feedback ... read more...

From SQL to DAX: Grouping Data
The GROUP BY condition of a SQL statement is natively implemented by SUMMARIZE in DAX. This article shows how to use SUMMARIZE and an alternative syntax to group data. Consider the following SQL query: SELECT OrderDate, SUM(SalesAmount) AS Sales FROM ... read more...

How to Make Sure Your Clients Can Connect to a Multi-Subnet Cluster
When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you understand a few things in order for your applications to work properly after a failover. For the sake of our discussion, ... read more...

SQL Server 2008 R2 Service Pack 3 has released.
Dear Customers, Microsoft SQL Server Product team is pleased to announce the release of SQL Server 2008 R2 Service Pack 3 (SP3). As part of our continued commitment to software excellence for our customers, this upgrade is free and doesn’t...(read more) ... read more...

Microsoft Azure Storage Queues Part 2: Hands on Working with Queues
This article is one in a series of articles on Azure Storage Queues. If you would like to jump to other articles in these series: Part One: Getting Started Part Two: Hands on Working with Queues In my last article I’ve explained the main idea and ... read more...

SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures
Earlier I wrote a blog post about the Location of Natively Compiled Stored Procedure and Naming Convention. In this blog post, I wrote about location of natively compiled stored procedures. In the blog post, I have used following image. One of the questions ... read more...

SQL SERVER – How to Check Snapshot Isolation State of Database
It is very easy to know the snapshot Isolation State of Database and here is the quick script for the same. SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc , is_read_committed_snapshot_on FROM sys.databases s Upon running above ... read more...

2014 PASS Summit Haiku Contest Rules
Contest time! Need a pass to PASS Summit? Tell us why with 140 characters in the form of a HAIKU. Contest starts Friday October 3, 2014. Read the official rules below.   COMMON TERMS USED IN THESE RULES: These are the official rules that govern how the ... read more...

Advanced Options For Loading Data From SQL Server With Power Query
Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example). However there are a few advanced options, not all of which are currently shown in the online help although they are in ... read more...

Change Your #SQLPASS Password Right Now.
What you need to do: log into SQLpass.org and change your password. If you use the same password anywhere else, change it on all of those sites immediately as well. Why you need to do it: anytime you ever logged into SQLpass.org or SQLsaturday.com, or ... read more...

How SQL Server Licensing Works [Video]
You have a sneaking suspicion that your servers aren’t all paid for, and you need to get a rough idea of how SQL Server licensing works. You’ve never bought a box of SQL Server before, and you have no idea where to get started. Microsoft Certified Master ... read more...

Shellshock fixes beget another round of patches as attacks mount
Over the past few days, Apple, Red Hat, and others have pushed out patches to vulnerabilities in the GNU Bourne Again Shell (bash). The vulnerabilities previously allowed attackers to execute commands remotely on systems that use the command parser under ... read more...

Why Microsoft's engineering changes will be the real Windows 9 (Threshold) story
Microsoft is building, testing and updating Windows in a very different way, starting with Windows Threshold. In many ways, those changes matter more than the new bits themselves. read more...

Microsoft christens the next version of Windows as Windows 10
Call it 'Threshold' no more. The next and last major version of Microsoft's Windows client operating system will be called Windows 10 when it is released next year. read more...