(Kenneth Fisher) Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s go over how you actually rename the database. It’s pretty simple.

(Ed Elliott) This is part of a series on how to take the Adventureworks database and bring it inline with modern standards. How do we put a legacy SQL Server database into source control? What issues do we face and how hard is it? Then how do we build a continuous integration pipeline and possibly m

(K. Brian Kelley) I have been tasked with setting up Transparent Data Encryption (TDE) on a SQL Server database with sensitive information. In the examples I’ve seen, I know I need a database master key in the master database and then a certificate that’s encrypted with that master key.

(Tony Davis) Recently, I’ve been getting more and more engrossed in SQL Server Execution plans for various reasons, including editing the forthcoming third edition of Grant Fritchey’s book.

(Tim Radney) MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup and restore history, SQL Agent job history, log shipping monitor history, SSIS packages, Database Engine Tuning Advisor data, and Service Broker queue data. Just like user databases, msdb needs r

(Pinal Dave) Earlier last week I wrote a blog around, SQL SERVER – FIX – Msg 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use. The premise of that blog was driven by some of the demo’s I show at conferences.

(Denzil Ribeiro) This article describes the index rebuild process as well as index maintenance for clustered Columnstore indexes and is directed towards SQL 2014. In SQL 2016, there have been several index maintenance enhancements that will be covered in a separate post.

(Marcin Policht) In our recently published article, we presented a script that provisions a new Azure Infrastructure-as-a-Service (IaaS) virtual machine running Windows Server 2012 R2 and prestages a SQL Server 2014 default instance.

(Dallas Snider) How can I create a “Greenbar” style report in SQL Server Reporting Services like the one shown below?

(Chris Webb) Recently, I was working with a customer that wanted to be able to draw lines between two points in Power Map. At the time I thought the only way that it might be possible was by using Power Query to generate a table of data containing a series of points that were so close together that