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

Latest Blog Posts

Loading Data into Clustered Columnstore Index with SSIS

I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is between 8 and 9 million rows and I was wondering how I could load data efficiently in this CCI using SSIS.

I stumbled upon this MSDN blog post: SQL Server… Read more

0 comments, 109 reads

Posted in Koen Verbeeck on 21 April 2016

Speaking at 24 Hours of PASS – The Evolution of Data Platform

As announced a couple of hours ago, a new edition of the famous online webinars 24 Hours of PASS will take place on 25th & 26th of May. This time its main topic is the evolution of Data Platform, with…

Read more

0 comments, 138 reads

Posted in Niko's blog on 21 April 2016

JSON in SQL Server 2016 – The Good, The Bad, and The Ugly

Microsoft introduced support for JSON data in SQL Server 2016 and in Azure SQL Database. I was excited to see this functionality coming. As an early user of XML when it was introduced, my expectations were high. Microsoft has done some really good work with JSON support, but I find… Read more

0 comments, 199 reads

Posted in DataOnWheels on 20 April 2016

A Speaking Sabbatical

Lately I’ve been thinking about taking a break from doing presentations. Not sure what triggered it – maybe just a sense of wanting some more time for other things.

I’ve been doing presentations on a regular basis since 2006. Before that it was once a year at PASS and maybe… Read more

0 comments, 172 reads

Posted in SQLAndy on 20 April 2016

Payment and the Board

If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and payments related to SQLSaturday precons. The question is simple, for a PASS branded event, should a member of the PASS board receive payment?

There are a couple of relevant… Read more

22 comments, 109 reads

Posted in The Scary DBA on 20 April 2016

MongoDB – Insert,Update,Upsert and Delete Examples – CRUD

In MongoDB we have to use either insert() or save() method to add the document to a collection

Insert Single document

> db.employee.insert( 
    "dob"new Date(1983,2,3,5

Read more

0 comments, 106 reads

Posted in PowerSQL By Prashanth Jayaram on 20 April 2016

Notes From the April 19, 2016 Pinellas SQL Meeting

I drove to Clearwater (and back) yesterday to attend and present to the Pinellas SQL group. Misc notes from the trip:

  • Started my trip at 2pm because Tampa traffic is very heavy after 4. Crossing the bridge (it’s a long bridge) there was an accident on the other side, traffic…

Read more

0 comments, 130 reads

Posted in SQLAndy on 20 April 2016

Why my primary test environment is case sensitive.

Me: I think I’m going create a new playground instance.
Myself: Make sure you use a case sensitive (CS) collation when you install it!
I: You mean a collation that forces us to pay attention to the case of the variable names (for example)? So that something like this returns… Read more

0 comments, 120 reads

Posted in SQLStudies on 20 April 2016

SQL Server 2016: What’s the best new feature?

With SQL 2016 around the corner, and my blog without a post this year, I thought I would write about some of the new features.  However, I’m not sure which feature I like the most to talk about! So I’m going to summarize a few of the new features I…

Read more

7 comments, 3,035 reads

Posted in - Ayman El-Ghazali on 19 April 2016

SQL 2016 features: Stretch Database

Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows for parts (or all) of a table, presumably older, less used parts, to be stored in Azure instead of on local servers. This could be very valuable for companies that… Read more

4 comments, 1,205 reads

Posted in SQL In The Wild on 19 April 2016

SQL Server Service Broker – Error Handling  

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.

Previous posts:

Read more

0 comments, 813 reads

Posted in Cleveland DBA on 19 April 2016

Overview of Published Articles – 2016Q1

Here is an overview of the articles I published in the first quarter of 2016.

R Services series:

SSIS & AlwaysEncrypted:

Read more

0 comments, 152 reads

Posted in Koen Verbeeck on 19 April 2016

Automating SSMS 2016 Updates & Install

Figured I'd share a way to automate the SSMS 2016 updates until it gets it's own fancy self updater. I love staying up to date, but with Power BI, SSMS, and others updating monthly or more and not having any automation for keeping up to date, this is something I… Read more

0 comments, 946 reads

Posted in SQL Barbarian on 19 April 2016

What Does REPAIR_ALLOW_DATA_LOSS in SQL Server Signify?

REPAIR_ALLOW_DATA_LOSS is the repair level, which is recommended by DBCC CHECKDB when the database is found in a corrupted state.SQL users and even administrators at times get confused about the real functioning of this command. It is to be noted that it contains the term Repair, which signifies that the… Read more

0 comments, 1,290 reads

Posted in Zora's SQL Tips on 19 April 2016


As I write more code, especially database code, and I collaborate with others (or myself), I find that I have the need to merge code more and more. It’s inevitable, and since I work across a couple machines, I even find that I need to merge my own code at… Read more

1 comments, 1,106 reads

Posted in The Voice of the DBA on 18 April 2016

Easy SQL mistakes: Accidental Correlated Subquery

Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup (you knew it had to be Minion related, didn’t you?) and I just got the oddest error. Here’s how it went. First, I got a list of backups…

Read more

2 comments, 2,312 reads

Posted in SQL Awesomesauce on 18 April 2016

My First PASS Board Meeting

Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as I do not speak on behalf of PASS. I have been on the PASS Board of Directors for about 4 months now and we had our first in person board… Read more

0 comments, 166 reads

Posted in Ryan Adams on 18 April 2016

How do I rename a column?

Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to rename it.

EXEC sp_rename 'OldName','NewName'

This works for tables, stored procedures, views etc, but there are a few things to be careful about. It doesn’t change the code behind code… Read more

2 comments, 130 reads

Posted in SQLStudies on 18 April 2016

Can’t RDP to Azure VM?

I ran into an interesting problem early this month. I was spinning up an Azure VM with SQL Server 2016 RC0 on it. For testing purposes. Looking at Stretch databases a new feature in SQL Server 2016

I run through the usual wizard to spin up a VM but I…

Read more

0 comments, 94 reads

Posted in The SQL DBA in the UK on 18 April 2016

Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Continuation from the previous 81 parts, the whole series can be found at Previously, I have blogged about about the Extended Events in SQL Server 2014 3 times: Columnstore Indexes – part 44 (“Monitoring with Extended Events”) served as…

Read more

0 comments, 200 reads

Posted in Niko's blog on 16 April 2016

Newer posts

Older posts