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

Latest Blog Posts

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, 114 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, 135 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, 124 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

10 comments, 3,312 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,454 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, 957 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, 156 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, 1,000 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,335 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,325 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,393 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, 135 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, 99 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, 201 reads

Posted in Niko's blog on 16 April 2016

SQL Saturday #492 Follow Up – A Window into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any questions about the session post… Read more

0 comments, 117 reads

Posted in DataOnWheels on 16 April 2016

Sarpedon Quality Lab presenting SQL Server 2016 In-Memory and Security Features in Arabia at SQL Gulf 3


(“MARR-hah-bah”, Arabic: Hello)

This year takes me to yet another part of the world:

I have been invited to speak at THE SQL Server Conference in the Middle East: at SQL Gulf 3 taking place in Riyadh, Saudi Arabia on April 23rd.

I feel very…

Read more


0 comments, 193 reads

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

Goodness-of-Fit Testing with SQL Server Part 7.2: The Lilliefors Test

By Steve Bolton

…………Since I’m teaching myself as I go in this series of self-tutorials, I often have only a vague idea of the challenges that will arise when trying to implement the next goodness-of-fit test with SQL Server. In retrospect, had I known that the Lilliefors Test was… Read more

4 comments, 1,012 reads

Posted in Multidimensional Mayhem on 15 April 2016

MongoDB – How to Copy Database

Using copydb

Run the copydb under admin database with from,to, host parameters

>use admin
switched to db admin
> db.runCommand({ copydb: 1, fromdb: “test”, todb: “new_test”, fromhost: “localhost” })

Using copyDatabase method

The db.copyDatabase() method is used to copy a database.



Read more

0 comments, 242 reads

Posted in PowerSQL By Prashanth Jayaram on 14 April 2016

Newer posts

Older posts