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

Latest Blog Posts

What is Polyglot Persistence?

Polyglot Persistence is a fancy term to mean that when storing data, it us best to use multiple data storage technologies, chosen based upon the way data is being used by individual applications or components of a single application.  Different kinds of data are best dealt with different data stores.… Read more

0 comments, 31 reads

Posted in James Serra's Blog on 1 July 2015

Speaking at PASS Summit 2015 & SQL Live360! - WaterOx Consulting

Reading Time: 2 minutes

Seattle, here we come! I am excited, and honored that it is...

The post Speaking at PASS Summit 2015 & SQL Live360! appeared first on WaterOx Consulting.

Read more

0 comments, 8 reads

Posted in WaterOx SQL on 1 July 2015

Updating Extended Properties on a Table

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post.

I wrote recently about adding an extended property to a table. As part of what I was testing, I also needed to update properties,… Read more

0 comments, 63 reads

Posted in The Voice of the DBA on 1 July 2015

DBTA – Russian Hackers Steal 1.2b Internet Credentials: Or, Why the Heck Does this Keep Happening?!

I’m decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I’ll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them… Read more

0 comments, 26 reads

Posted in Kevin E. Kline on 1 July 2015

SQL Saturday Field Notes

As you walk toward the entrance the door opens and there stands a volunteer smiling welcoming you in. You make your way into the building where you are ushered toward the sign in table; there is where you are greeted by more volunteers who help you get checked in and… Read more

0 comments, 33 reads

Posted in The SQL Professor on 1 July 2015

Blocking and deadlocking on purpose

Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling or prove a point and then you need to do the unusual.

Blocking and Deadlocking are based on lock requests and locking is handled differently depending on the TRANSACTION ISOLATION… Read more

0 comments, 6 reads

Posted in SQLStudies on 1 July 2015

Download SSMS, SSDT or SSDT-BI

It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing.

This is an example of some frustration:

Anyway, this is now sorted as there is a single page to download SSMS or SSDT:

Read more

0 comments, 136 reads

Posted in Ed Elliott's Sql Developer Blog on 30 June 2015

Leadership Training Possibility

I know a few people in the SQL Server community who have been involved in Scouting. A couple of them have taken or helped lead Scoutings leadership training program known as Wood Badge. It’s an amazing program. I won’t even attempt to tell you what Wood Badge has done… Read more

10 comments, 79 reads

Posted in The Scary DBA on 30 June 2015

Integrating Other Data Mining Tools with SQL Server, Part 2.1: The Minuscule Hassles of Minitab

By Steve Bolton

…………It may be called Minitab, but SQL Server users can derive maximum benefits from the Windows version of this professional data mining and statistics tool – provided that they use it for tasks that SQL Server doesn’t do natively. This was one the caveats I also… Read more

0 comments, 57 reads

Posted in Multidimensional Mayhem on 30 June 2015

Download SSMS 2015 as a standalone download.... finally!

I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview.

Two of the points made on the website look very promising:

New SSMS Installer - SSMS can now be installed with a light weight stand-alone web installer.

SSMS Updates -…

Read more

0 comments, 103 reads

Posted in SQL Barbarian on 30 June 2015

I’m Speaking at PASS Summit 2015

It’s this time of the year again, when PASS announces the speakers in the biggest SQL Server event in the world – PASS Summit. Like many others, I submitted my abstracts a few months ago and waited with anticipation for the results.

And I’m so proud and excited to say… Read more

0 comments, 97 reads

Posted in Guy Glantser on 29 June 2015

SQL Server Radio – Virtualization and Independent Consulting

I recently recorded a podcast with the SQL Server Radio group and discussed virtualization, high availability, and independent consulting topics. I had a lot of fun!

We talked about:

  • What’s important to know when virtualizing SQL Server
  • How to properly size your VM
  • What metrics to monitor when virtualizing
  • When…

Read more

0 comments, 118 reads

Posted in Technobabble by Klee from @kleegeek on 29 June 2015

Sneak Preview – Podcast 010 - WaterOx Consulting

Reading Time: 1 minutes

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

The post Sneak Preview – Podcast 010 appeared first on WaterOx Consulting.

Read more

1 comments, 105 reads

Posted in WaterOx SQL on 29 June 2015

SQL Server 2016 CTP 2.1 has been released

Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been added.
Now SQL Server appears to get the same treatment: SQL Server 2016 CTP 2.1 has just been released. There is nothing groundbreaking in this release… Read more

0 comments, 83 reads

Posted in Koen Verbeeck on 29 June 2015

I’m on WOxPod! Podcast

A few weeks ago, while at SQL Saturday Philadelphia, Chris Bell, SQL Server MVP and co-leader of PASS DC user group graciously sat me down and talked. We talked about me; who I’m, what I do, and what I like. You can listen to the podcast here.… Read more

0 comments, 64 reads

Posted in Sam Vanga on 29 June 2015

Zero to Speaker pt 2

A few months ago I wrote a post about the fact that I had actually submitted a session to PASS Summit. Well as I’m sure you are aware the selected sessions have been announced. They were officially announced Friday but I actually received my result email on Thursday evening.… Read more

3 comments, 64 reads

Posted in SQLStudies on 29 June 2015

My first SQL 2016 bug

A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent hours creating a VM because there were hundreds of Windows updates).
It seems I have already found a very small bug while creating a new database:

Apparently they forgot… Read more

0 comments, 80 reads

Posted in Koen Verbeeck on 29 June 2015

Understanding, Planning and Configuring Distributed Cache Service || Part 1

Hi All,

Major expectation raised by user for SharePoint other then Search ,is to have Good User Experience and Faster in it operation.

In Order to improve SharePoint User experience, Microsoft added a new feature called Distributed Cache service, it cache frequently requested information and made it available quickly to… Read more

0 comments, 79 reads

Posted in AshishSharePointBlog on 29 June 2015

Columnstore Indexes – part 57 (“Segment Alignment Maintenance”)

Continuation from the previous 56 parts, the whole series can be found at In this post I want to focus on a very important aspect of Columnstore Indexes maintenance – Segment Alignment. I have extensively blogged and presented on…

Read more

0 comments, 97 reads

Posted in Niko's blog on 28 June 2015

Speaking at PASS Summit 2015

I will reveal no big secret that on the night when email notifications of PASS Summit selection are sent, I can’t get a real sleep, no matter how hard I try. PASS Summit is the biggest and the most important…

Read more

0 comments, 106 reads

Posted in Niko's blog on 28 June 2015

Older posts