Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

How to backup local SQL database and restore to Azure SQL database

Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure SQL database. I found that there is new option available to generate the scripts for Microsoft SQL Azure database using Generate Scripts option. Let me walkthrough step by step on…

Read more

0 comments, 299 reads

Posted in Kapil Blogs on 28 November 2016

A Better Way to Execute SSIS Packages with T-SQL

There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way of performing this task is to execute SSIS packages with T-SQL. There are a couple of challenges that come up when executing catalog-deployed packages using the default settings in T-SQL,… Read more

3 comments, 2,324 reads

Posted in Tim Mitchell on 28 November 2016

Monday Coffee 2016-11-28

MCSA SQL Server 2016

The new SQL 2016 MCSA exams are out and joy of joys, the DBA path no longer requires the Data Warehouse exam! I say this as a DBA who has had limited practical exposure to the topics covered by that exam so it’s always put me… Read more

0 comments, 119 reads

Posted in The DBA Who Came In From The Cold on 28 November 2016

Bree's first blog post... Amazing training deals

Gethyn will be getting me to update this every week, there are some awesome training deals available for £750 + VAT. Use the contact page to get in touch if you have any questions or if you would like to book a course.

Course 3821 Professional Services Professional: Business Executive  20th…

Read more

0 comments, 94 reads

Posted in The SQL DBA in the UK on 28 November 2016

A DBA’s Developer Experience and After-Thoughts

After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a database developer. I decided to do this mainly for two reasons:

1. I want to have a career travel to see whether the grass is greener on the other side. Read more

5 comments, 1,280 reads

Posted in DBA Philosophy on 28 November 2016

Columnstore Indexes – part 92 (“Lobs”)

Continuation from the previous 91 parts, the whole series can be found at

Since the very first version of the Columnstore Indexes in 2012, there has been no support for LOB (large objects binaries). The reason behind not focusing on implementing their support was that a good Data… Read more

0 comments, 122 reads

Posted in Niko's blog on 27 November 2016

Why Do People Think Dynamic Data Masking is a Good Idea? - SQL SERVER 2016 #5

Data security is always one of the important points which can not be ignored. Nowadays if you are working for any specific domain like Banking or Healthcare then there are a lot of compliance rules which you have to follow.
Data Masking is one of the best ways to help…

Read more

0 comments, 195 reads

Posted in Rajat Jaiswal-337252 on 27 November 2016

Data Channel - Launch

Dear All,

I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this channel is going to contain is Interviews with SQL Server and Data Platform experts like MVPs, MCM , Community Leads and Microsoft Professionals too. Interviews are generally 15 to…

Read more

0 comments, 113 reads

Posted in SQL and SQL Only on 26 November 2016

ETL #73–NULL or NOT NULL and SQL Interview Questions

Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short post today.

The first thing to be thankful is that Tomislav and I have completed the third edition of our MDX book, MDX with Microsoft SQL Server 2016 Analysis Services… Read more

0 comments, 159 reads

Posted in Sherry Li's BI Corner on 25 November 2016

Quick PoSh Kills with Stop-DbaProcess

I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but they also make some things easier. As a part of my practice, I’m documenting the various items I’ve played with. This post looks at Stop-DbaProcess.

Killing Spids

At first I… Read more

0 comments, 944 reads

Posted in The Voice of the DBA on 25 November 2016

Friday Reading 2016-11-25

Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-

Virtue in the Virtual
Tony Davies discusses containerisation and virtualisation technologies and how they could be used to benefit processes within RedGate

Query wait stats in SQL 2016 SP1 Execution Plans
What a cool feature!

Source… Read more

0 comments, 171 reads

Posted in The DBA Who Came In From The Cold on 25 November 2016


We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing SQL Server 2008R2 to SQL Server 2012 onwards? Let’s look at 2008R2, I navigate to the BINN folder i.e. Program Files\Microsoft … Continue reading

Read more

1 comments, 375 reads

Posted in All About SQL on 25 November 2016

Retrieving Query Store query performance data through sp_WhatsupQueryStore

This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes into more detail on how you can use sp_WhatsupQueryStore to easily and quickly retrieve query performance data from the Query Store.


The first thing you want to do… Read more

10 comments, 1,241 reads

Posted in DotNine SQL Server and more on 24 November 2016

Calculate a semi-additive average in DAX

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all… Read more

0 comments, 159 reads

Posted in Koen Verbeeck on 24 November 2016

Happy Thanksgiving

It’s Thanksgiving again here in the United States. Throughout the years, the IT community has been awesome. I have been blessed by you all. I can certainly point to milestones in my career and list the folks who have helped me get to each one. 

But outside of work and… Read more

0 comments, 121 reads

Posted in Databases – Infrastructure – Security on 24 November 2016

AlwaysON database not synchronizing mode SQL service account change

AlwaysON database not synchronizing mode SQL service account change

Suddenly, one of our alwaysON server databases are went not synchronizing mode.

Errors from the log

The availability group database “DB” is changing roles from “RESOLVING” to “PRIMARY” because the mirroring session or availability group failed over due to role synchronization.… Read more

0 comments, 121 reads

Posted in SQL Server Blog Forum on 24 November 2016

SQL Server Restore to LSN

For this post I want to show you how I recovered to a LSN where I did do this on a server where I wanted to go back to a time just before a delete occurred. This is my setup. … Continue reading

Read more

1 comments, 358 reads

Posted in All About SQL on 24 November 2016

Escaping a Dollar Sign in PoSh–#SQLNewBlogger

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

I’ve been working more with PowerShell lately and ran into a problem I thought would be easy, but it wasn’t. So I decided to blog what I… Read more

11 comments, 199 reads

Posted in The Voice of the DBA on 23 November 2016

PowerShell to Test a Query

So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not a problem. Here’s a very rough script that I use to do some recent testing.

This script to test a query is post #11 of the #enterylevel #iwanttohelp effort started… Read more

4 comments, 238 reads

Posted in The Scary DBA on 23 November 2016

It greatly pleases me to announce, HAL0003!

I while back as part of a T-SQL Tuesday post I created HAL0001, then later HAL0002 with a long-term goal of building up a database version of HAL9000. Well, at the rate I’m going I may have to pass this on to my kids (or even grandkids). But in… Read more

24 comments, 153 reads

Posted in SQLStudies on 23 November 2016

Newer posts

Older posts