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

Archives: 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

10 comments, 3,801 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, 368 reads

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

How to Change an Analysis Services Instance to Tabular Mode

One of my client accidentally set up an SQL Server Analysis Services in multi-dimensional mode instead of Tabular mode. In this post I will show a procedure to change Analysis tabular mode in SQL Server 2016. 

Analysis Services Modes 

Analysis Services can be installed in one of three server modes: Multidimensional…

Read more

0 comments, 989 reads

Posted in Ganapathi's MSSQLLover 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, 309 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

6 comments, 1,753 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 http://www.nikoport.com/columnstore/.

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

2 comments, 449 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, 562 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

1 comments, 346 reads

Posted in SQL and SQL Only on 26 November 2016

Change the Collation Setting for Clustered SQL Server 2014 Instance

One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are supposed to change the SQL Server collation setting. In this post I will show a procedure to change the collation settings of a clustered SQL Server instance. 
To change the default…

Read more

0 comments, 144 reads

Posted in Ganapathi's MSSQLLover 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, 460 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, 1,303 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, 405 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, 645 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, 2,245 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

1 comments, 1,205 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, 344 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, 774 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, 567 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

10 comments, 539 reads

Posted in The Voice of the DBA on 23 November 2016

Configuring Integration Services in a SQL Server 2016 Cluster

In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.
Clustering Integration Services is not recommended because the Integration Services service is not a clustered or cluster-aware service, and does not support failover from one cluster node to another. Therefore, in a clustered…

Read more

0 comments, 447 reads

Posted in Ganapathi's MSSQLLover on 23 November 2016

Newer posts

Older posts