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

Latest Blog Posts

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, 117 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, 160 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, 966 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, 173 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, 379 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

12 comments, 1,271 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, 164 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, 124 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, 123 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, 360 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, 203 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, 243 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, 157 reads

Posted in SQLStudies on 23 November 2016

Restoring a SQL Server backup on Linux

Last Wednesday I got very excited by Microsoft’s announcements about the addition of features to standard edition and the public preview of SQL Server on Linux. I bored everyone in the office with the features we could now use in standard edition and the possibilities that running SQL Server on… Read more

0 comments, 188 reads

Posted in The Database Avenger on 23 November 2016

SQL Server & Containers – Part Two

This post follows on from SQL Server & Containers – Part 1 and will go through how to build custom container images.

Since Part 1 came out Microsoft has released SQL Server vNext which is available in the Docker repository. I used the SQL 2016 Express image in Part 1… Read more

3 comments, 174 reads

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

Getting Team City working with BitBucket

As a part of building a CI/CD home lab, I set up TeamCity in the past. I plan on using this for multiple projects, and in fact, I’d built a basic Hello, World C# application as my first build.

Now it is time to work on something more complex. As… Read more

0 comments, 183 reads

Posted in The Voice of the DBA on 22 November 2016

SQL Server on Linux: Boring

As a concept, SQL Server on Linux is thrilling. Due to this, the OS doesn’t stand in the way of taking advantage of everything that SQL Server offers. Because we have Linux, we have opportunity for all sorts of new fun.

I first saw SQL Server running on Linux about… Read more

17 comments, 216 reads

Posted in The Scary DBA on 22 November 2016

Comparing and synchronizing Oracle databases

Applies to: xSQL Oracle Data Compare v1.0 - 2.0

As you may have noticed, most of the articles in this blog focus around scenarios and solutions for databases in Microsoft's SQL Server. However, most of the experienced DBA's in the field of information technology and data sciences have probably…

Read more

0 comments, 150 reads

Posted in xSQL blog on 22 November 2016

SQL Server 2016 service pack 1 is here!

SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why, you ask, is it so important? Because a lot of Enterprise Edition database engine features are now available in the other editions as well. In other words, you… Read more

0 comments, 1,596 reads

Posted in Koen Verbeeck on 22 November 2016

Power BI Custom Visuals Class (Module 26 – Timeline)

In this module you will learn how to use the Timeline Power BI Custom Visual.  The Timeline is a great tool for filtering date values on a report.

Module 26 – Timeline


Read more

3 comments, 1,140 reads

Posted in Devin Knight on 22 November 2016

Newer posts

Older posts