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

Latest Blog Posts

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, 62 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, 48 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

1 comments, 80 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, 149 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, 120 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, 100 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, 419 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, 319 reads

Posted in SQL Server Overview on 16 February 2018

"What's New in SQL 2017?" at the Baton Rouge SQL Server UG meeting

We had a great joint meeting tonight of the Baton Rouge SQL and .NET User Groups at the Louisiana Tech Park, and I gave the first version of a growing presentation on new features of SQL Server 2017 (with quite a few new SQL 2016 features in there for good…

Read more

0 comments, 132 reads

Posted in SQL Tact on 15 February 2018

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However, we always seem to find ourselves needing to allow someone to execute something that requires one or two higher-level permissions. Yet, in order to allow for just one extra… Read more

0 comments, 168 reads

Posted in SQL Quantum Leap on 15 February 2018

Enabling Guest in a Database–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

The guest account exists in all your databases. This is installed by default, and guest is used to map a login that doesn’t otherwise have access to a… Read more

0 comments, 501 reads

Posted in The Voice of the DBA on 15 February 2018

Azure Data Architecture Guide (ADAG)

The Azure Data Architecture Guide has just been released!  Check it out: http://aka.ms/ADAG

Think of it as a menu or syllabus for data professionals.  What service should you use, why, and when would you use it.  I had a small involvement in its creation, but there were a large number… Read more

0 comments, 538 reads

Posted in James Serra's Blog on 15 February 2018

Saving Costs in Azure

Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient in tracking usage patterns and its associated costs, in this case, potential cost savings.

You can find this information under Help + Support.

Then you will need to navigate to… Read more

0 comments, 109 reads

Posted in All About SQL on 15 February 2018

Synonyms, how and why.

Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even though it’s been around for >10 years (SQL 2005). In fact, I’d be willing to bet that a good chunk of the people reading this have never (or just… Read more

1 comments, 395 reads

Posted in SQLStudies on 15 February 2018

Execute Multiple Files Using SQLCMD/SQLClient – Which Is Faster?


I’ve been working on a PowerShell module that will migrate the schema of an Azure Data Warehouse from one database to another. The process has through quite a few iterations, and at one point I was heavily using sqlcmd utility to execute each “CREATE [OBJECT]” statement. Whilst this proved… Read more

0 comments, 422 reads

Posted in Richie Lee's SQL Stuff on 15 February 2018

Migrating or Recovering a TDE protected Database

When encrypting a database with Transparent Data Encryption(TDE), a vital consideration is to make sure we are prepared for the scenario when something goes wrong. For instance, if the server hosting our SQL instance goes belly-up, can we recover the data that we have encrypted with TDE?

In the ordinary… Read more

1 comments, 182 reads

Posted in Matthew McGiffen DBA on 14 February 2018

Join me for Masking, Privacy, Protection, and Clones at SQL in the City Feb 28

Registration is open for SQL in the City 2018. Our first event is Feb 28 and I’ll be heading back to the UK for the event. This time Grant and Kathi will be there and we’ll be joined by the amazing Ike Ellis. This is an event… Read more

0 comments, 165 reads

Posted in The Voice of the DBA on 14 February 2018

Why nested views are bad

Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you have a SELECT statement you tend to use all over the place (a very common practice when checking user permissions). There are five base tables in the join, but it’s… Read more

2 comments, 506 reads

Posted in Born SQL with Randolph West on 14 February 2018

Bloggers Should Have Reach

One of my goals for 2018 is to expand the reach of my blog.

As a blogger starting out I had my own site I posted to, but my blogs only reached those who followed me on Twitter, Facebook, Google + and LinkedIn. My blog automatically posts to these three… Read more

1 comments, 117 reads

Posted in SQLEspresso on 14 February 2018

T-SQL Tuesday #99 – What’s Behind Door #1

It’s hard to believe that we have reached T-SQL Tuesday #99 already. This month’s host is Aaron Bertrand (blog|@AaronBertrand), and he is giving us 2 choices to choose from for the theme of our posts. Door #1 is about #sqlibrium or what you are passionate about outside of SQL Server…

Read more

Older posts