Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

What’s the Size of that Index?

I have previously written about finding what the big space consumers are within the database. I even shared scripts in those articles on how to find those big consumers (read all about it here).

That is grand when it comes to quickly finding which objects happen to be… Read more

0 comments, 47 reads

Posted in SQL RNNR on 27 July 2015

Culture Differences: US v UK

This is a bit of an off topic post from the technical stuff, but there’s a bit of a tie-in, so stick with me.

I had to get a tire fixed this morning. I actually owned a replacement tire, so I just needed someone to mount it on the existing… Read more

0 comments, 98 reads

Posted in The Voice of the DBA on 27 July 2015

SQLSaturday #423 Baton Rouge

This is I believe the 7th SQLSaturday in Baton Rouge. Please come out this Saturday at the LSU Business Center to enjoy free training, prizes and networking with over 500 IT professionals.


Here is the schedule.

Read more

0 comments, 35 reads

Posted in The Smiling DBA on 27 July 2015

Sneak Preview – Episode 014 - WaterOx Consulting

Reading Time: 1 minutes

Let’s Play A Game! So, just to tickle your fancy, here is...

The post Sneak Preview – Episode 014 appeared first on WaterOx Consulting.

Read more

0 comments, 93 reads

Posted in WaterOx SQL on 27 July 2015

Baltimore Crime Report Using Power BI

As part of my quest for using data to find answers to everyday questions using Power BI – after analyzing baby names and eating habits – I turned to crime data for the city of Baltimore.

Data is obtained from Open Baltimore and I used Power BI Desktop. Once you… Read more

0 comments, 62 reads

Posted in Sam Vanga on 27 July 2015

Permissions Posters

I’ve been doing a lot of research recently for my permissions session and for a project at work. During said research I came across three great sets of posters about permissions. I’m going to list them here and on my Study and Reference Materials

Permissions Hierarchy (Database Engine)

Database Engine… Read more

2 comments, 71 reads

Posted in SQLStudies on 27 July 2015

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:

He had a table of a few dozen million rows. The table had a few GUID columns that had to be indexed.

He had an ETL process that inserted a few thousand rows every few minutes. When the table had only a… Read more

0 comments, 116 reads

Posted in Matan Yungman on 27 July 2015

Single value filters and custom error messages in Power BI

"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief description of a recent use case for a power view report which had been later replicated in a Power BI slide as well.

Users were aware of PowerView / Power…

Read more

0 comments, 73 reads

Posted in Data Adventures on 27 July 2015

SQL Server 2016 Blogs

Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of …

Continue reading Read more

0 comments, 128 reads

Posted in Kapil Blogs on 26 July 2015

Community Reactions to Power BI General Availability

Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about products, downloads, and pricing, go to  This is how the community reacted to the release on Twitter.

An exciting news was announced a day prior to GA. The… Read more

0 comments, 87 reads

Posted in Sam Vanga on 26 July 2015

Transparent Data Encryption in Azure SQL Database

Transparent Data Encryption in Azure SQL Database
JULY 26, 2015

Transparent Data Encryption (TDE) is a security feature of SQL Server that has been around since SQL Server 2008. With TDE, the entire database is encrypted (also called "at-rest" encryption). With a non-TDE database, if someone were to steal…

Read more

0 comments, 134 reads

Posted in Pie in the Sky on 26 July 2015

A simple way for consistency TIP #106


Whenever we develop application of maintain application we define sets of rules or policies  like naming convention , data type, database & SQL SERVER properties (like which property should be unable or disable)  but the problem is to cross check or to enforce these properties is very tedious.

To… Read more

0 comments, 49 reads

Posted in Rajat Jaiswal-337252 on 26 July 2015

Change in sys.dm_exec_query_stats in SQL Server 2016

Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query …

Continue reading Read more

0 comments, 143 reads

Posted in Kapil Blogs on 25 July 2015

MDW Data Collector – Collection Set jobs not working


Error Message 1 :

Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS – Read Current Upload Data [1], Description: String too long. The adapter read a string that was 50331648 bytes long, and expected a string no longer than… Read more

0 comments, 101 reads

Posted in MSSQLFUN on 24 July 2015

Columnstore Indexes at PASS Performance Palooza: Recording and Materials

Yesterday I participated in PASS Performance Palooza.

I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.

The recording is already up:


The scripts and slide deck can be downloaded from here.

The post Columnstore Indexes at PASS Performance Palooza: Recording and Materials Read more

0 comments, 121 reads

Posted in Matan Yungman on 24 July 2015

Power BI Desktop: A Guide for Excel Users

Today Microsoft officially released the new development tool for Power BI called Power BI Desktop.  First of all let me share my excitement in what this release means for Power BI.  The team at Microsoft has done an incredible job and the results are something they can truly be proud… Read more

0 comments, 475 reads

Posted in Devin Knight on 24 July 2015

Get Away from the Heat and Learn some Database Version Control

I have enjoyed the trips I’ve made to New Orleans and Baton Rouge in the past. It’s a good getaway, stopping in the French Quarter for a few minutes before an easy drive up the road. However it’s warm, and I can’t ever get my wife or kids to come… Read more

2 comments, 37 reads

Posted in The Voice of the DBA on 24 July 2015

013 – The Start of Something Big! - WaterOx Consulting

Reading Time: 4 minutes

Together we can make a difference in the data world! In WOxPod!,...

The post 013 – The Start of Something Big! appeared first on WaterOx Consulting.

Read more

0 comments, 134 reads

Posted in WaterOx SQL on 24 July 2015

Boost your OLTP database performance with SQL Server 2014 in-memory tables

Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-Memory OLTP. In-Memory OLTP (project Hekaton) functionality was designed to expedite the processing of typical OLTP-operation in SQL Server. As you know, server load can be divided into… Read more

0 comments, 151 reads

Posted in Forrards Group Database Blog on 24 July 2015

Setting Up and Using Azure VM SQL Automated Backup (and Restore)

This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots. I have always used my Powershell scripts described here to create my test systems and with a new job taking up a lot of my time had missed the announcement… Read more

0 comments, 159 reads

Posted in SQL DBA With A Beard on 24 July 2015

Older posts