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


ALM meets DLM
. I am just excited to see new tools being developed by a leader in database management software that is effectively addressing this difficult aspect of application lifecycle management. They do this by making the data tier a first class ALM citizen. read more...

Setting up continuous integration for databases in minutes (not weeks, days or hours)
Priya Sinha describes how her team at Red Gate brought SQL CI up-to-date and ready for a wide range of source control systems, and the benefits this brings. read more...

An Overview of the Microsoft Cloud Platform System
CPS is not, as many in the media have dubbed it, Azure-in-a-box. That’s because you will find the real Azure in Microsoft’s data centers and possibly the two partner-operated regions that are in China. CPS actually takes components that you can purchase for yourself and bundles them up into a package that is sold directly by Microsoft. read more...

Crowdfunding project promises a “laptop that respects essential freedoms”
Purism pitches Librem, a 15-inch laptop (nearly) free of proprietary code. read more...

Researchers craft molecule that works as flash storage
As features on chips get smaller, we're edging closer to where we bump up against basic physics, which dictates that the behavior of wiring will become unpredictable once the number of atoms involved gets small enough. As a result, there's been some preliminary work done on producing processor components out of single molecules, like carbon nanotubes. read more...

Data as a Service: The Next “As a Service” Wave?
There is increasing demand to deliver data through platform-agnostic open-standard APIs so it can be consumed in a variety of ways, whether refined, aggregated, or combined with additional information. Are we heading towards a shared understanding of applications as data-providers, feeding other services such as BI, or even in the right circumstances, publishing it? read more...

SOA and message based integration - the challenge of bulk data changes
Copying data around the various enterprise systems takes time. Traditional ETL solutions are fine for data warehouses that are updated overnight, but if we need changes propagated rapidly to all applications then event and message based patterns are a better fit. But how do they cope with bulk data loads? read more...

You don’t really need ORDER BY do you?
You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject, describing how the ordering can change due to an change in execution plan. read more...

PowerShell Problem Solver: Find Installed Software Using PowerShell
Identifying installed applications is pretty easy and once you have the information you can do much with it from exporting to a CSV file to creating an HTML report. read more...

A New Free CA
Announcing Let's Encrypt, a new free certificate authority. This is a joint project of EFF, Mozilla, Cisco, Akamai, and the University of Michigan. read more...

Patch Tuesday one week later: update woes and out-of-band patch release
Some of the most serious problems are occurring with MS14-066 (KB2992611), the SChannel patch that got so much press when it was released. This patch is reported to cause severe performance problems on SQL Server, problems with the Chrome browser communicating with IIS web servers, and more. read more...

Timing Power Query Queries
If you’re interested in performance-tuning a Power Query query, you’re going to need a reliable way of telling how long your query takes to run. read more...

Reading the New Fast Track Reference Architectures from HP & EMC
Three new SQL Server 2014 Fast Track Data Warehouse Reference Architecture designs have been released by EMC, HP, and Lenovo. I love reading these because they show each vendor’s state-of-the-art storage infrastructure. read more...

When Does Index Fragmentation Matter?
Sometimes, fragmentation may not be the source of your woes. However, there are data access patterns where fragmentation really does matter. read more...

SQL Server’s Cost Threshold for Parallelism
Behind the scenes, the optimizer is considering many possible plans. The Cost Threshold for Parallelism setting comes into play during that process and uses costs that you don’t see in the final plan. read more...

Developers, Ready for a New SQL Server Version?
Focusing on the database engine, Michael J. Swart explores ways to find out for sure if your application ready to have its SQL Server upgraded to the next version. read more...

Microsoft says Storage service performance update brought Azure down
Microsoft officials are attributing a nearly 11-hour Azure outage across a large part of the world earlier this week to a performance update the company made to its Storage services. read more...

Recompilations, Part 2
With table variables, recompilations based on database schema changes can be avoided. In addition a table variable has no statistics. Therefore statistics don’t have to be maintained, and the second cause of recompilations just disappears. Both things sounds great at first, but we will find huge drawbacks when we look further. read more...

SQL Server 2012 SP2 Cumulative Update 3
Microsoft has released SQL Server 2012 SP2 Cumulative Update 3, which is Build 11.0.5556. This CU has 34 hotfixes in the public fix list. If you are running SQL Server 2012, this is the build you should be planning to get installed, after you have done your testing and planning for the installation. read more...

Allowing specific non-sysadmin users to query group membership for a login
How to let a specfic user be able to find the group membership for another login, without the user being a sysadmin to run the code. read more...