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


Microsoft ships replacement patch KB 2993651 with two known bugs
Even by Microsoft standards, this month's botched Black Tuesday Windows 7/8/8.1 MS14-045 patch hit a new low. The original patch (KB 2982791) is now officially "expired" and a completely different patch (KB 2993651) offered in its stead read more...

Microsoft Azure makes nice with Google to get a piece of Docker
Microsoft Azure digs deeper into Docker, with visual tool and Kubernetes support for containers read more...

Should Microsoft kill Windows Phone?
The company is backing away from Android and doubling down on its own smartphone OS just when the smart move seems to be to surrender read more...

PowerShell Summit Europe 2014
The PowerShell Summit Europe 2014 will be held from September 29th to October 1st in Amsterdam. read more...

Introduction to Azure PowerShell Modules for the SQL Server DBA Part 1
Our organization is starting to deploy more virtual machines on Azure for both testing and DR environments. I would like to create and administer Azure virtual machines using Windows PowerShell. How do I get started? read more...

SSAS Tabular as Analytical Engine
This article describes pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it. read more...

When you really need to know why your SQL Query’s slow
For some developers, execution plans are as easy to read in SSMS as ancient Babylonian. The information is there but not in an intuitive way geared for the occasional user. Regardless of how or where developers write or generate their SQL code, it needs to support not just an easy way to return the execution plan, but also to present it in a digestible format that makes for easier interpretation, and quicker troubleshooting. read more...

Small Enhancement to Microsoft SQL Server CU Knowledge Base Articles
There is now a new column in the hotfix table that lists the major functional area to which the hotfix applies. Having this information readily available and visible can help you focus your efforts as you scan the overall hotfix list looking for relevant fixes for the SQL Server components you are using, which is something you should be doing when each new Cumulative Update is released. read more...

Fixing SQL Server Management Studio’s Tab Text
Brent recently tweeted an 'SSMS Makeover' tip that he published several years ago. I wish I'd been paying attention at the time! read more...

SQL Monitor Custom Metric: Time Since Last Restore
If your log restores aren't happening when they’re meant to, you want to know about it. You’ll be relying on restoring from logs should anything happen to your databases, and if you can’t restore to a certain point in time, you risk losing valuable data. read more...

SQL Server 2014 Setup Error: 'BIDS' is not a valid value for setting 'FEATURES'
In SQL 2012, we can install SSDT from the command line using FEATURES="BIDS". In SQL 2014 this raises an error. A SQL Server Support Engineer explains why. read more...

Microsoft cuts Azure SQL cloud database prices
Microsoft is tweaking its Azure SQL cloud database pricing, guaranteed uptime and more ahead of making its new tiers generally available. read more...

Is SQL Server Losing Mindshare?
Thomas Kejser analyzes data from dba.stackexchange.com to assess where things are, and then offers some advice to the the communities and corporations behind MS SQL Server, MySQL and PostgreSQL. read more...

Using indexed views on ANY core SQL server edition
You can create and use indexed views on express, web, standard, BI and enterprise editions. The difference is that for non-enterprise editions, you have to “force” the optimizer with a hint to use the index whereas enterprise editions will automatically consider the index and use it. read more...

SQL Server Reporting Services Basics: Customizing SSRS Reports
While the Reporting Wizard and basic report tables will do for prototyping, very soon we'll want to add some finesse to our reports, and allow our report users to create different views of the same data, dynamically. Kathi Kellenberger shows how to use expressions, functions, grouping, the matrix control, and other features, to add a degree of user control to the reports while maintaining visual clarity. read more...

4 Attitudes I Wish I Had Earlier as a DBA
Empathy – I sorely lacked that early in my career. Some recent conversations with folks in the SQL community and colleagues and customers at Linchpin People had me thinking about empathy. That got me thinking about how I judged too quickly and spoke too soon early in my career. Which led to this post… read more...

How to Tell If You’re Good At SQL Server Transaction Replication (Quiz)
Let’s play the quiz! We’re using the honor system: be honest with yourself. read more...

Data-Driven Load Tests using Visual Studio Online and SQL Azure
Nearly everyone in corporate IT can tell you war stories about some application whose performance died within 6 - 18 mths of going into production. Why do they blow up? More often than not, the root cause is inadequate stress testing, with inadequate data. read more...

Performance Monitor user-defined data collector set doesn’t collect 32-bit SQL data when installed on a 64-bit OS
When a 32-bit SQL Server is installed on a 64-bit Windows Operating System, Performance Monitor user-defined data collection set does not capture SQL Counter data. Don Castelino provides a workaround. read more...

Seagate’s new 8TB hard drive is for all you digital hoarders
3.5" drive hits the enterprise first, but consumer versions will surely follow. read more...