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

Latest Blog Posts

Professional SSRS 2016 Book Preview Posts

This page is a table of contents for for several new and forthcoming posts.  I’m posting a series of excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports.  Each of the posts is a condensed version of the material covered in a corresponding chapter…

Read more

3 comments, 45 reads

Posted in SQL Server BI Blog on 22 January 2017

Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)

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

This blog post is focused on a very important feature in the modern times of the real time operations – the online operations. The first online rebuild operation for indexes in the Microsoft Data Platform… Read more

0 comments, 50 reads

Posted in Niko's blog on 22 January 2017

How to Count the Total Number of Rows Across Multiple Tables

I have been working on SQL Server Consulting assignment,  a SQL Server 2014 migration for a new client over the past few weeks. When I’m undertaking such tasks I’m often asked additional questions that make my  day a little interesting. 

I got a question last week How to Count the…

Read more

0 comments, 66 reads

Posted in The SQL DBA in the UK on 22 January 2017

MVP 2016!!!

Dear All,

Very happy to share the news that I have been awarded Microsoft Most Valuable Professional award for my contributions to SQL Server Community in 2016!!!. This is an honor I have dreamt of for long needless to say that the award motivates me to contribute more for the…

Read more

0 comments, 58 reads

Posted in SQL and SQL Only on 22 January 2017

CREATE DATABASE – I’ve not seen that before.


It’s been a while

I thought that I’d make a quick blog post about an incident that I encountered today that I had not come across before.
I was working on my laptop when I tried doing a really basic task – creating a database.
So I keyed… Read more

0 comments, 66 reads

Posted in measure twice, cut once. on 22 January 2017

Implementing Fuzzy Sets in SQL Server, Part 7: The Significance of Fuzzy Stats

By Steve Bolton

…………In the world of fuzzy sets and imprecision modeling, the concept of cardinality takes on new shades of meaning that are not applicable to ordinary “crisp” sets, i.e. those without membership grades. In the last article in this series of amateur-self-tutorials, I mentioned one type of… Read more

0 comments, 81 reads

Posted in Multidimensional Mayhem on 20 January 2017

The most underrated show on Data Platform – SQL Unplugged

I would like to write a blog post about by far the most underrated online show about Data Platform – SQL Unplugged.

Leaded by Scott Klein (One of the best tech evangelist that Microsoft has), this show focuses on talking about the Microsoft Data Platform development future, while hosting… Read more

0 comments, 71 reads

Posted in Niko's blog on 20 January 2017

We’re hiring!

I’m proud and humbled to announce that my company, Heraflux Technologies, is hiring for a Data Platform Solutions Architect!

We are looking for a highly qualified technologist who is comfortable with database technologies, such as Microsoft SQL Server and other DBMS platforms, and infrastructure technologies, such as virtualization,… Read more

0 comments, 61 reads

Posted in Technobabble by Klee from @kleegeek on 20 January 2017

Installing dbatools on WS2012 R2

This is actually a simple, short post, but writing helps me remember things, and since I had to learn this, I decided to write something short.

I have a number of Windows Server 2012 R2 VMs. I need to get rid of these and upgrade to WS2016, since installing SQL… Read more

0 comments, 114 reads

Posted in The Voice of the DBA on 20 January 2017

Retrieve a List of Files from FTP using SSIS

The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school” way to transfer data, FTP is still relied upon in most every data movement architecture. Sadly, the functionality around FTP is very limited in SQL Server Integration Services. A… Read more

0 comments, 78 reads

Posted in Tim Mitchell on 20 January 2017

Friday Reading 2017-01-20

Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been reading…

Microsoft’s Cyber Defense Operations Center shares best practices
Microsoft shares details some of their best practices for how they respond to cyberthreats in real time

CPU Scheduling Basics –… Read more

0 comments, 239 reads

Posted in The DBA Who Came In From The Cold on 20 January 2017


I was having a conversation with Oracle professionals the other day and they started to discuss the Oracle ACE program and they asked me (being the one that works with Microsoft technology) what Microsoft’s equivalent was, to which I answered … Continue reading

Read more

1 comments, 257 reads

Posted in All About SQL on 20 January 2017

What is a Database Master Key?

The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran across a few people struggling to understand, so I decided to cover the concepts in a series of posts. This one looks at the Database Master Key (DMK).

Not the…

Read more

0 comments, 131 reads

Posted in The Voice of the DBA on 19 January 2017

Webinar: Introducing Minion CheckDB!

Minion CheckDB will be available for download on February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on Wednesday, February 1 at 12:00 PM, and, another Minion CheckDB webinar on Friday, February 3 at 12:00 PM. And, we will be giving away 3 licenses of Minion Enterprise to… Read more

0 comments, 296 reads

Posted in SQL Awesomesauce on 19 January 2017

Help me raise money for cancer research #tourneeminerale

In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be sponsored for not drinking alcohol for the whole month of February 2017. This sponsor money is donated to the national cancer research center. The name of the campaign – Tournée… Read more

0 comments, 95 reads

Posted in Koen Verbeeck on 19 January 2017

SQL Server - Monitoring Table Size

There are many situations when we want to know the size of our database tables or just need a list of largest tables. The simplest way to get these details is use SQL Server Standard Report. Please refer the below screen shots to generate Standard report.This Report provides the fair…

Read more

0 comments, 320 reads

Posted in Help on MSBI on 19 January 2017

Speaking at PowerShell Virtual Group of PASS

This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session we will introduce you to OS concepts like managing files and file systems, installation packages, using PowerShell on Linux,… Read more

0 comments, 71 reads

Posted in Anthony Nocentino's Blog on 19 January 2017

SQL Server 2016 Bug in R Integration?


I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using sp_execute_external_script. So here is the re-play of the bug;

If I run the following code, I will get an error.


-- this will return an error


Read more

1 comments, 111 reads

Posted in DBA Philosophy on 19 January 2017

Attending VTUG at Gillette Stadium Tomorrow

If you’re in the Boston area tomorrow, I urge you to go to this year’s Virtualization Technology Users Group (VTUG) Winter Warmer event tomorrow at Gillette Stadium. It’s better than a regional VMUG, and not just VMware specific. It’s covering all things infrastructure, virtualization, and cloud, and it’s held… Read more

0 comments, 70 reads

Posted in Technobabble by Klee from @kleegeek on 18 January 2017

Why Use Red Gate’s SQL Multi Script?

Someone once told me at the shop that we have plenty of software utilities laying around that could be very useful that no one is utilizing. I got to thinking about that from a DBA standpoint; we are fortunate enough to have the Tool Belt from Red Gate and with… Read more

0 comments, 96 reads

Posted in The SQL Professor on 18 January 2017

Older posts