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

Latest Blog Posts

Deletes Ignore Check Constraints

I know it sounds a bit odd but DELETE statements really do ignore table constraints. Running the code below in a test database will setup a test to prove this.

CREATE TABLE ProductConstraintTest
  ProductID	INT IDENTITY(1,1),
  ProductCode	VARCHAR(50),
  ProductName	VARCHAR(100),
  Cost		DECIMAL(19,4),
  Price		DECIMAL(19,4)

CREATE FUNCTION chkProductCount()…

Read more

4 comments, 54 reads

Posted in The Database Avenger on 30 May 2016

Upcoming Webinars and Events

This coming week is packed full of fun events! On Wednesday, June 1st at 2pm Eastern, I’m participating in a webinar with ActualTech Media called ‘Modern Storage Strategies for SQL Server‘ where we will talk about key concepts from the recent e-book that we released together.

Session… Read more

0 comments, 77 reads

Posted in Technobabble by Klee from @kleegeek on 29 May 2016

Columnstore Indexes – part 83 (“Columnstore Replication in SQL Server 2016”)

Continuation from the previous 82 parts, the whole series can be found at A lot of things were changed in SQL Server 2012, which was quite a ground-breaking release if you look at it with a lot of attention…

Read more

0 comments, 111 reads

Posted in Niko's blog on 29 May 2016

Why use a Date Dimension Table in a Data Warehouse

In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time dimension. Since then, the Time dimension has actually been separate from the…

Read more

0 comments, 82 reads

Posted in The Smiling DBA on 29 May 2016

Restore a SQL Server Database with Different Methods

Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a common scenario that takes place every now and then lead to the loss of an enormous amount of data. In order to sustain the same, administrative ensure backup plans as… Read more

0 comments, 1,161 reads

Posted in PowerSQL By Prashanth Jayaram on 28 May 2016

Where are SQL Server 2016 Client Tools?

So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools and all the components you needed.  You look for SSMS and, what the heck?  it’s not there.  OMG, what have they done?! SSMS is Gone! Seriously, SQL Server Management Studio…

Read more

2 comments, 134 reads

Posted in SQL Server BI Blog on 27 May 2016

My 24 Hours of PASS Session Files

I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of PASS: Evolution of the Data Platform event. My presentation was called New Paradigm for Performance Tuning in SQL Server 2016 and covers two new tools for performance tuning: Query Store…

Read more

Why I’m not attending PASS Summit 2016

I know there has been a lot of drama in the community recently, much of it centered around what people are or are not going to do in conjunction to this year’s SQL PASS Summit. Well this isn’t one of those posts. I promise you that this post is drama…

Read more

Just a week to SQL Saturday in Pensacola

Next week is  SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s free SQL Server training, and a great place to vacation. There are a couple pre-conference sessions available as well if you are looking for some training.

Filed under: Blog Tagged:…

Read more

0 comments, 160 reads

Posted in The Voice of the DBA on 26 May 2016

CPU Scheduling Basics – Windows and SQL Server

In this post we’re going to introduce the basics of CPU scheduling.

In a computer system, only one thing can happen at a time. More specifically, only one task can be on a processor at a point in time. This can expand to several tasks if the system has multiple… Read more

0 comments, 196 reads

Posted in Anthony Nocentino's Blog on 26 May 2016

SQL Server – Rollback transaction completely in case of error

Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback …

Continue reading Read more

0 comments, 208 reads

Posted in Kapil Blogs on 26 May 2016

The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query.

There can be a few reasons for this error:

  1. The remote computer is blocked by the firewall.
    Solution: Open the Group Policy Object Editor snap-in (gpedit.msc) to edit the Group Policy…

Read more

0 comments, 153 reads

Posted in PowerSQL By Prashanth Jayaram on 25 May 2016

Azure Storage pricing

Azure storage is a great, inexpensive solution for storing your data in the cloud.  There are many types of Azure storage options, but I wanted to list here the pricing of the most common type: block blob.

The pricing below is based on the East US region (most other… Read more

0 comments, 149 reads

Posted in James Serra's Blog on 25 May 2016

A Basic Recursive CTE and a Money Lesson

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

When I was a six or seven year old, my Mom asked me a question. She asked if I’d rather have $1,000,000 at the end of the… Read more

4 comments, 166 reads

Posted in The Voice of the DBA on 25 May 2016

Connecting to Azure SQL Database

Recently I created my first Azure SQL Database. But now I need to connect to it.

You can connect using any number of tools. We can actually see several options by going back to our Azure Portal. Select the SQL Databases list, a specific SQL Database, and then… Read more

1 comments, 111 reads

Posted in SQLStudies on 25 May 2016

A Moment For Reflection…

While this is a personal blog, I try to keep it focused on either technical topics or personal development and leadership related to technical topics. This post is a complete deviation from all of the above. Please, read it anyway.

I went to Auschwitz and Birkenau.

Words are failing me… Read more

4 comments, 133 reads

Posted in The Scary DBA on 25 May 2016

Changing Your PASS Credentials

I got an email today from PASS, noting that credentials were changing from username to email. That’s fine. I don’t really care, but I know I got multiple emails to different accounts, so which account is associated with which email?

I clicked the “login details” link in the email and… Read more

2 comments, 151 reads

Posted in The Voice of the DBA on 24 May 2016

Some Pester Tests for SQL Defaults

When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the slides and code here) I found out about Irwin Strachans Active Directory Operations Test which got me thinking.

I decided to do the same for my usual SQL… Read more

0 comments, 111 reads

Posted in SQL DBA With A Beard on 24 May 2016

XML-> JSON document Example

Convert the XML document to JSON document example

    <city>New York</city>
    <phone type="home">212-555-1234</phone>
    <phone type="mobile">646-555-1234</phone>


“name” : “John”,
“age” : 25,
“address” : { “city” : “New York”, “postalCode” : “10021” },
“phones” :
{“phone”:”212-555-1234″, “type” : “home”},
{“phone”:”646-555-1234″,… Read more

0 comments, 111 reads

Posted in PowerSQL By Prashanth Jayaram on 24 May 2016

On the Buckeye Blitz!

In just a few weeks I’ll be doing the Buckeye Blitz. That is, a tour of user groups in Ohio (aka, the Buckeye state, after a tree, not a sports team), one per day across a week. Here’s how it breaks down:

Cleveland: 6/13
Toledo: 6/14
Columbus: 6/15
Cincinnati:… Read more

2 comments, 130 reads

Posted in The Scary DBA on 24 May 2016

Older posts