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

Latest Blog Posts

I’m Speaking! Omaha SQL Server/BI User Group

Well, it has finally happened. In the 7+ years that I helped to run the Omaha SQL/BI User Group, I never once gave a presentation of my own.  Of course I spoke, but it was usually about house keeping items for the group or helping to facilitate a “Bring Us… Read more

0 comments, 26 reads

Posted in John Morehouse | on 2 July 2015

SQLVacation Slides and Scripts

First came the in-person roadtrip.

That Kline family won’t be nearly as good at this as us Griswolds!

Two weeks riding the highways from Nashville, TN to Chicago, IL to St. Louis, MO and back.

One thousand four hundred miles in a minivan with my wife and four daughters.

Eight… Read more

0 comments, 30 reads

Posted in Kevin E. Kline on 2 July 2015

Defining Foreign Keys at Table Create Time

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

How many of you can define a foreign key when you create the table? Probably a few of you, but I bet most of you are like me… Read more

0 comments, 58 reads

Posted in The Voice of the DBA on 2 July 2015

Professional Development – The Stradivarius of Teams

Originally appearing at

A world-class violinist was on campus for an artist-in-residence program. While at lunch he was discussing what he perceived to be the similarities between management and great music. Said the violinist, “I have glorious music, a splendid instrument, and an exquisite bow. All I need… Read more

0 comments, 48 reads

Posted in Kevin E. Kline on 2 July 2015

Moving SQLAndy to Project Nami

I’ve been hosting this blog on Azure for a while, running WordPress on top of MySQL. Works fine, gives me a reason to use Azure here and there to gain experience. No good reason to change. Still, why not?

Last night I loaded Project Nami, a port of WordPress… Read more

0 comments, 47 reads

Posted in SQLAndy on 2 July 2015

Doing a Full Outer Join in Power Query

A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of  the Microsoft BI platform is demonstrated alongside client testimonials. I gave a session called “Drilling across Analysis Services cubes using Power Query”, which talked about how you can use… Read more

0 comments, 36 reads

Posted in Koen Verbeeck on 2 July 2015

Microsoft MVP–A dream came true


Dear All,

Microsoft  Most Valuable Professional “ – MVP  is one of the prestigious tag. It is one of the dreams which came true today.

Today , I got the E-mail that I am an MVP in SQL SERVER. 

I am speechless but would like to… Read more

0 comments, 34 reads

Posted in Rajat Jaiswal-337252 on 2 July 2015

SQL Server Infernals – Circle 3: Shaky Typers

Choosing the right data type for your columns is first of all a design decision that has tremendous impact on the correctness of the database schema. It is not just about performance or space usage: the data type is the first constraint on your data and it decides what can… Read more

1 comments, 41 reads

Posted in SpaghettiDBA on 2 July 2015

Power BI Hands-On Workshop at PASS Global Summit

Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring your laptop and let’s build a real business intelligence (BI) solution using Power BI! In this deep-dive session, we build a complete solution.  You will need the Power BI Designer…

Read more

2 comments, 63 reads

Posted in SQL Server BI Blog on 2 July 2015

Database Drops in SQL 2012

In the previous article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who dropped the database and when they dropped it.  In that article, I demonstrated how the information (at least some of it)… Read more

0 comments, 74 reads

Posted in SQL RNNR on 1 July 2015

Microsoft SQL Server MVP

Today I received an email notifying me that I have been awarded the Microsoft “MVP” award for my second year. An excerpt from Microsoft’s website states

“The Microsoft Most Valuable Professional (MVP) Award is our way of saying thank you to exceptional, independent community leaders who share their passion, technical… Read more

0 comments, 61 reads

Posted in Tim Radney - Database Professional on 1 July 2015

How to Grant limited permissions to create views in another schema?

How to Grant limited permissions to create views in another schema?

In SQL Server 2005 and 2008R2 you can grant permissions at the schema level and, in fact, this is what you’ll need to do to give them the ability to create the views. 

This script below creates an example… Read more

0 comments, 56 reads

Posted in SQLSERVERS’dba on 1 July 2015

Reporting Services Subscriptions in “Pending” Status

Ran into this issue today. A subscription that had been working failed. Looking at it in the RS portal it had a status of “pending” Not helpful! I tested the report, looked at the datasources, and the subscription, it all looked good. It was only when I stepped through the… Read more

0 comments, 34 reads

Posted in SQLAndy on 1 July 2015

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, 64 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, 64 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, 96 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, 55 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, 55 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, 52 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, 148 reads

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

Older posts