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


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...

Table Rebuild Avoids Excessive Lookups After Data Type Change
If you go through your code and dutifully replace all the ntext, text, and image data types with nvarchar(max), varchar(max), and varbinary(max) data types, you'll need to rebuild the table to get the best results. read more...

Using Stored Procedures to Provide an Application’s Business-Logic Layer
When faced with a complex business application that had to be delivered with minimum staffing, on-time and within budget, Dwain's team chose to encapsulate and implement most of an application’s business logic in SQL Server, using an interface made up of stored procedures. read more...

Understand SQL Server’s impact on .NET performance with ANTS Performance Profiler 9
Ben Emmett describes how the new release of ANTS Performance Profiler can help you with the all-too-common problem of slow SQL Server queries causing performance issues for your .NET application. read more...