SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2018

Classifying Data with SSMS 17.5

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data. With the GDPR coming for many of us, this is a welcome addition.

This is a quick look at this feature.

Classify a Database

If I select a database and… Read more

0 comments, 51 reads

Posted in The Voice of the DBA on 20 February 2018

Killing A Service Broker SPID

Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations where a SPID that is spawned by the Service Broker stays alive even after the queue is stuck in limbo.

No matter how many times you kill the SPID,… Read more

0 comments, 78 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 20 February 2018

Capture SQL Server Reported Errors using Extended Events

In my introduction to Extended Events blog, I mentioned that the xEvent is my favorite toy for performance troubleshooting. This blog may make you to start playing with it. In this tip, I will be discussing how you can find what caused SQL Server to write error in the… Read more

0 comments, 93 reads

Posted in SQL Geek on 20 February 2018

Getting started with the SQLUndercover Inspector

Here is a quick guide to getting started with the SQLUndercover Inspector.


  • SQL 2012 or higher
  • SQL Server Agent
  • A database to store the the data collected by the agent jobs (this can be one you use for your other DBA needs it doesn’t have to be a dedicated…

Read more

0 comments, 87 reads

Posted in SQL Undercover on 19 February 2018

SQL Saturday Chicago: I’m speaking

If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?

You can check out the full event schedule here: http://www.sqlsaturday.com/719/Sessions/Schedule.aspx

There are a lot of great speakers and topics. Did I mention the Brent Ozar will be there? If that’s… Read more

0 comments, 72 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

STORPORT: Reading an ETL trace

One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it so much; but, I just do. When it comes to storage in Windows one of the best things you can do is capture an ETL trace for the STORPORT driver. Read more

0 comments, 68 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

Using a gMSA with SQL Server

As you already know, SQL Server runs as a service. And services require a service account to run under. While this service account is likely to be a domain service account, it could be an account on the local machine. To follow good security practices you would need to specify… Read more

0 comments, 91 reads

Posted in A Discussion of SQL Server-Related Topics on 19 February 2018

The default filegroup, and why you should care.

You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index & heaps) and another for the indexes (non-clustered indexes). Or maybe you want to separate your data tables from the system tables. There are any number of reasons why you… Read more

1 comments, 88 reads

Posted in SQLStudies on 19 February 2018

Dealing with stress

Anyone who knows me will know that I’m something of a stress head. I tend to worry about things and have, in the past, let it get the better of me.

But I feel that over the last few years I’ve managed to get a handle of dealing with stress.… Read more

0 comments, 139 reads

Posted in The DBA Who Came In From The Cold on 19 February 2018

How to create System-versioned temporal tables? – New database feature of SQL Server 2016

Creating a System-Versioned Temporal Table – There are three ways to create a system-versioned temporal table with regards to how the history table is specified:

1) Creating a temporal table with an anonymous history table

Creating a temporal table with an anonymous name. This is easiest way to create it… Read more

0 comments, 119 reads

Posted in MSSQLFUN on 19 February 2018

Distributing SSH User Keys via PowerShell

Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take a minute to look at what it takes to use PowerShell to distribute SSH user keys to remote systems.

In the OpenSSH package there’s a command ssh-copy-id which is a… Read more

0 comments, 129 reads

Posted in Anthony Nocentino's Blog on 18 February 2018

New Pluralsight Course – LFCE: Linux Service Management – Advanced HTTP Services

My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right in check it out here! This course offers practical tips from…

Read more

0 comments, 134 reads

Posted in Anthony Nocentino's Blog on 17 February 2018

SQL Server Error 3013: Restore Database is Terminating Abnormally

Overview of SQL Server Error 3013

One of the most frustrating situations that a user experiences while working with SQL Server is when errors are encountered. These errors disrupt the normal functioning of SQL Server and in worst case scenario may even lead to data loss. Sometimes, SQL Server Backup… Read more

0 comments, 113 reads

Posted in SQL Server Overview on 17 February 2018

CROSS JOIN for fun

My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts houses over a game of chess* with his brother: “ONE MILLION POINTS TO GRYFFINPUFF!” So I said, “Hey guys, I’m going to do a nerdy thing with my database… Read more

2 comments, 150 reads

Posted in SQL Awesomesauce on 17 February 2018

dbatools and Orphaned Users

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

One of the common issues that I would… Read more

0 comments, 253 reads

Posted in The Voice of the DBA on 16 February 2018

Black Panther is Going to Change Superhero Movies

Hello Dear Reader!  Sorry it has been so long, I've been blogging over on the MSDN site about technology.  I'll have a Twitter Sentiment update for Black Panther later today with an update on Tuesday for the holiday weekend.

Since the early 2000's a trend of Superhero movies began, comic…

Read more

4 comments, 174 reads

Posted in SQLBalls on 16 February 2018

Backup & Restore Script with a Move

Ok, I’ll admit it. I like scripts that are handy and do things.  Especially if the scripts make my life easier.

Now, not every environment is the same.  Instances get configured differently or things change just due to the nature of the business.  In a previous life I would routinely… Read more

0 comments, 138 reads

Posted in John Morehouse | Sqlrus.com on 16 February 2018

TDE and backup compression – still not working?

Until SQL 2016 if you used TDE (Transparent Data Encryption) you couldn’t use backup compression.

In 2016 Microsoft changed this, but it has been a rocky road. Backups work okay but in some circumstances people have found that they are corrupt when they come to restore them.

We thought that… Read more

1 comments, 533 reads

Posted in Matthew McGiffen DBA on 16 February 2018

A Guide for Decrypting SQL Server Database Objects


The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from unauthorized access or hacker’s attacks. To make the data accessible, it needs to be decrypted with the use of key or password. It is necessary to encrypt critical SQL Server… Read more

0 comments, 652 reads

Posted in SQL Server Overview on 16 February 2018

Older posts