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

Latest Blog Posts

Examining OLEDB waits

On our adventure through the various types of wait statistics we end up at another popular wait type: OLEDB.
In this article we will take a closer look at OLEDB waits to help you understand where they come from.


OLEDB or, Object Linking and Embedding DataBase, is a Microsoft…

Read more

0 comments, 110 reads

Posted in DotNine SQL Server and more on 11 July 2014

Friday Followup For July 11, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Which One’s Better?
  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log Recovery Tool?
  • Cheating…

Read more

0 comments, 82 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 11 July 2014

Creating a Matrix Infographic in SSRS

With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to display forecasts of World cup matches. An example:

I was wondering if something similar could be built using SSRS. And yes, it is possible and it isn’t… Read more

0 comments, 111 reads

Posted in Koen Verbeeck on 11 July 2014

db_ddladmin and the SSMS table designer

If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you have a several options. For example:

  • You can grant all of the CREATE permissions either to the database itself or to all of the schemas.
  • You can add the user…

Read more

0 comments, 116 reads

Posted in SQLStudies on 10 July 2014

Azure HDInsight – Hadoop in the Cloud

Azure HDInsight Overview

HDInsight is a cloud based implementation hosted in the Microsoft Azure cloud. It enables you to quickly create, expand and delete a Hadoop cluster installation as your project dictates. For organizations just beginning to see how Big Data could be leveraged to solve business problems. A HDInsight… Read more

0 comments, 121 reads

Posted in Business Intelligence and Enterprise Architecture on 10 July 2014

SQL Saturday Baton Rouge 2014

Since I have been involved with and eventually head of the Baton Rouge SQL Saturday planning committee each year since 2009, my July's annually have been pretty hectic. Putting together orders for shirts and supplies, drinks, coordinating speaker communication, wrangling volunteers, working with sponsors, etc. But each year I am…

Read more

0 comments, 75 reads

Posted in SQL Tact on 10 July 2014

"What You Need To Know About Being a DBA and What You Need To Know That You Don’t Know Yet"

Last night was a big success for the first annual Baton Rouge User Groups Networking Night, an all-user-groups invited event that saw members of the Baton Rouge SQL Server, .NET, Java, IT Pro, SharePoint, Women in IT user groups, plus members of user groups in Hammond, Lafayette and New Orleans…

Read more

0 comments, 109 reads

Posted in SQL Tact on 10 July 2014

Will you be attending Mile High Tech Con?

Technical conferences have always been a great venue for networking and increasing my knowledge base. Mile High Tech Con will be no different. I would like to invite you to be part of the inaugural Mile High Tech Con which will be held July 24 -26 in Denver, Colorado. Mile… Read more

0 comments, 86 reads

Posted in Marc Beacom on 9 July 2014

Time for a change in career

A few months back I made the decision to leave the relative comfort and security of my permanent role and head into the world of contracting & consulting. Whilst a big decision and change for me, it is something that I’ve long wanted to do at some point during my… Read more

0 comments, 129 reads

Posted in SQL Server Rocks! on 9 July 2014

SSIS Column Export-Question of the Day

An SSIS question! How’s that for a change of pace? SSIS Column Export is, as you might well surmise, about the export column transform. I used it recently to export a kazillion or so images and thought it would be a nice, middle of the road question. Give it a… Read more

0 comments, 113 reads

Posted in SQLAndy on 9 July 2014

A Few More Thoughts on Summit Session Selection & Growing Speakers

Last week ended up better than expected when PASS decided to release feedback to speakers (selected or not) who requested it. I imagine many did and the feedback on the feedback was surprisingly good – and that is good. That’s a good step and I hope it will be become… Read more

0 comments, 174 reads

Posted in SQLAndy on 9 July 2014

T-SQL Tuesday #56: Assumptions

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. This month, Dev Nambi (blog | twitter) is hosting the party, and he has decided that the topic is to be on Assumptions. Specifically, he wants us to write about:


Read more

0 comments, 112 reads

Posted in A Discussion of SQL Server-Related Topics on 8 July 2014

Is your Team Willing to Take Control?

The calendar tells us that once again we have reached the second tuesday of the month.  In the SQL Community, this means a little party as many of you may already know.  This is the TSQL Tuesday Party.

This month represents the 56th installment of this party.  This institution was… Read more

0 comments, 92 reads

Posted in SQL RNNR on 8 July 2014

Worst Day of a DBAs Life

Red Gate Software is running a campaign around coping with the worst day of a DBAs life. We’ve been posting some really fun stories with, I hope, a kernel of useful information inside each. Chances are, if your DBA career has been like mine, your worst days don’t involve explosions… Read more

4 comments, 133 reads

Posted in The Scary DBA on 8 July 2014

Which One’s Better?

During a recent webcast, someone asked if, in an EXISTS query, it is better to use “SELECT *”, “SELECT ‘1’”, or some other variation. I promised a followup blog post to explore this and try to come up with a definitive answer. This is that post.

All of the examples… Read more

6 comments, 116 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 8 July 2014

T-SQL Tuesday #56: Assumptions

I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can be certain that Dev Nambi(b/t) has decided to make Assumptions the topic of the 56th T-SQL Tuesday.

I generally like to start with definitions when discussing… Read more

6 comments, 105 reads

Posted in SQLStudies on 8 July 2014

Columnstore Table Analyzer

As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part of a Columstore index. While there are fewer restrictions in SQL Server 2014, they still exist. I find myself constantly looking back at Books Online trying to make sure…

Read more

0 comments, 104 reads

Posted in Everyday SQL on 8 July 2014

How to Generate a Fiddler SAZ File

Fiddler is a free program that will log HTTP and HTTPS requests on Windows.  These instructions demonstrate how to use Fiddler to create an archive file (.SAZ) of these requests for troubleshooting purposes using the full version of Fiddler.  As an alternative, there is a simplified version of Fiddler available… Read more

0 comments, 99 reads

Posted in New York City .NET on 8 July 2014

Upcoming Free PASS VC Webcasts

Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded to view later.


Database Administration VC

Date: July 9

Noon Mountain

Topic: How to be a great DBA– sponsored by Dell Software

Registration: You must register…

Read more

0 comments, 114 reads

Posted in The Smiling DBA on 8 July 2014

Newer posts

Older posts