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


The Mindset of the Enterprise DBA: Delegating Work
A lot of the routine jobs demanded of a DBA can be automated, but a tougher prospect is to automate these jobs in a way that the requester rather than the DBA can actually set of the job running themselves without compromising security and without risk. Is it true to say that some tasks can be made self-service? In the final part of his series, Joshua considers delegation. read more...

Microsoft Tech Conferences Relaunch Under Microsoft Ignite Banner
After several months of what could be best described as head-scratching confusion over the fate of the Microsoft TechEd conference Microsoft has finally announced that TechEd and a host of related conferences will be merged into a single technology conference under the Microsoft Ignite brand name. read more...

Hey, Windows 10, fix this!
In Windows 10 Microsoft are making improvements to the DOS window. You’ll be able to resize it now. And use Shift plus the arrow keys to select text. That’s great. Stunning in fact. Now here's some more things they might want to have a go at at the same time. read more...

A Werewolf DBA?
DBW reader Tom Dietsche alerted us to Shifting Shadows by Patricia Briggs, a collection of fantasy short stories, one of which is "Redemption" the story of an ill-tempered DBA who also happens to be a werewolf. And you thought being on call was a bad way to spend an evening. read more...

Configure SQL Server Database Mirroring
A walk through the database mirroring configuration process. read more...

Google Exposes POODLE Internet Security Hole
A bug discovered by Google could prove to be a boon for hackers worldwide, and a disaster for web security. The vulnerability, which lies within SSL 3.0, an older Web security protocol still used on some systems, could allow an attacker with network access to uncover encrypted data. read more...

What You Need to Know Before Migrating VMs to Microsoft Azure
Moving existing virtual machines (VMs) into Azure is a challenge that must overcome the opposing forces of bandwidth limitations, acceptable downtime, and migration project deadlines. read more...

Setting Your Page Verify Database Option to CHECKSUM
Often, older databases that were originally created in SQL Server 2000 or older get upgraded to SQL Server 2005 or newer, and the Page Verify Option is left at the older and less effective TORN_PAGE value. read more...

AN INTRODUCTION TO SQL SERVER DATA MINING ALGORITHMS
Data mining uses combination of the statistics, probability, artificial intelligence, machine learning and database technologies etc to analyze particular data sets. read more...

Tracking down CPU spikes using process explorer and DMVs
What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just shutting down the last applications when a call or a page comes in. Next minute you’re phoning home and dinner’s in the warmer. read more...

SSIS Pivot makes you stronger
Rayis Imayev on how he uses PIVOT in a middle data layer when one data set gets transformed (or in Excel terms, 'transposed') to another form and then moved further along the way. read more...

Microsoft Releases Virtual Machine Converter 3.0
The highlight of the release is that it supports the conversion of online physical computers running either Windows Server and later 2008 or Windows Vista and later into Hyper-V virtual machines. read more...

PowerShell Problem Solver: Copy Files with Alternate Credentials
At first glance, you might think this should be pretty easy. If you look at help for Copy-Item, you will see a credential parameter. However, if you look at help for this parameter, then you will come across a rather stunning pronouncement. read more...

Importing and Exporting Perfmon Counters
A utility to help people who need to import or export perfmon counters within a Visual Studio Load Test Results database. The zip file in this post contains a stand-alone executable and the necessary SQL code for performing the imports and exports. read more...

Everything you need to know about the POODLE SSL bug
POODLE – the Padding Oracle On Downgraded Legacy Encryption. In the modern era of fancy bug names, the guys who names this must have been ecstatic when they realised that the acronym actually made a whole heap of sense! But really, that’s exactly what it is – a protocol downgrade support that then exploits a legacy encryption implementation. read more...

Readable Secondaries on a Budget
People get very excited when they hear about Availability Groups. Then reality hits: the feature requires the Enterprise Edition of SQL Server. Enterprise Edition is expensive, especially if you have a lot of cores, and especially since the elimination of CAL-based licensing. Some customers can't justify the price. read more...

Transactional replication - how to initialize a subscription from a backup
How to initialize a subscription in transactional replication from backup; often the required technique is the database is quite big. read more...

Easier way to try SQL Server Availability Groups using Azure
How to set up a high availability environment in Azure, with a Windows Server 2012 R2 domain controller and a couple of SQL Server 2014 Enterprise member servers. read more...

AutoExist and Normalization
The autoexist feature used by MDX queries sent to an Analysis Services or Power Pivot data models can have different behaviors depending on the normalization level. This article describes these differences and provides best practices to avoid unwanted results. read more...

A Truly Random Post
Want to generate a truly random number? It's a little more tricky than it first seems. First off, TSQL has a RAND function. Simple huh? Not so fast. read more...