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

Latest Blog Posts

Gimme A Break! Taking Mental Health Days

Reading Time: 3 minutes

Do you feel like this when you get to work?


You have been stressing over the big project you have to get done.

You get in early Monday morning, pour yourself a mug of coffee and stumble to your desk.

You start up your system,… Read more

0 comments, 17 reads

Posted in WaterOx SQL on 26 February 2015

My Upcoming Speaking Engagements

March 4 – Charleston PASS, Charleston, SC

What Admins Absolutely Must Know About SQL Server Security

There are so many security tips out there for SQL Server. Almost all of them are rated as a best practice. What do you listen to? What do you focus on? In this… Read more

0 comments, 35 reads

Posted in Databases – Infrastructure – Security on 26 February 2015

Operational Data Store (ODS) Defined

I see a lot of confusion on what exactly is an Operational Data Store (ODS).  While it can mean different things to different people, I’ll explain what I see as the most common definition.  First let me mention that an ODS is not a data warehouse or data mart.  A… Read more

0 comments, 38 reads

Posted in James Serra's Blog on 26 February 2015

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What’dya want, a hand-written invitation?!?) I want to take a moment to point out a good one that I think anybody who writes SQL code… Read more

1 comments, 29 reads

Posted in Kevin E. Kline on 26 February 2015

Monitor Query Statistics

One of the most common tasks that DBAs are required to perform is monitoring. This is not just a task. Monitoring is a strategy, and a good DBA should have a well-defined plan for carrying out this strategy. But I’m not here to talk about monitoring as a whole. I… Read more

0 comments, 34 reads

Posted in Guy Glantser on 26 February 2015

Exam Prep 70-463: SSIS Expressions

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered:

Read more

0 comments, 45 reads

Posted in Cleveland DBA on 26 February 2015

How to do DevOps as a SQL Server DBA

You recognize that you need to provide a pipeline for database deployments, that you need to automate as much support for your development teams as you possibly can, that you have to have testing in place to ensure protection of the production environment, that you need to speed your processes.… Read more

2 comments, 46 reads

Posted in The Scary DBA on 26 February 2015

Dynamic Data Masking

Dynamic Data Masking
FEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users such as credit card numbers, telephone numbers or last names? This functionality is now possible in Azure SQL Database with Dynamic Data Masking. This month, Microsoft has continued…

Read more

0 comments, 76 reads

Posted in Pie in the Sky on 26 February 2015

Parsing SQL Saturday Data – Getting Titles from the XML document

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database. In this piece, I’m picking up from the last one where I had a loop to load all XML documents in a folder based on a pattern.

This time I… Read more

0 comments, 90 reads

Posted in The Voice of the DBA on 25 February 2015

The SQL Sentry forum for SQL Statement Tuning

The SQL Sentry forum for SQL Statement Tuning

Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries,

You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol’ SQL Server Management Studio to… Read more

0 comments, 77 reads

Posted in Kevin E. Kline on 25 February 2015

Using sp_DBPermissions and sp_SrvPermissions v6.0

It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting.


— V5.5
— 7/22/2014 – Changed strings to unicode
— V6.0
— 10/19/2014 – Add @UserLikeSearch and @IncludeMSShipped parameters.

— V5.5
— 7/15/2014 – Bunch of changes… Read more

0 comments, 62 reads

Posted in SQLStudies on 25 February 2015

Solving a slow running query issue with UNION

That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!

I recently encountered a curious issue with a query. The query itself wasn’t exactly rocket science: it read data from a few tables and calculated the start and the end dates of… Read more

2 comments, 75 reads

Posted in Koen Verbeeck on 25 February 2015

Presentation slides for “Building a Big Data Solution”

Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop, Cloud and MPP) for Pragmatic Works today.  The abstract for my session is below and the recording will be available here tomorrow.  I hope you enjoyed it!

Here is the… Read more

0 comments, 92 reads

Posted in James Serra's Blog on 24 February 2015

Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)

Want to learn more about SQL Server? Now’s a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively.

I hope you’ll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the… Read more

2 comments, 59 reads

Posted in Kevin E. Kline on 24 February 2015

Check Out Josh’s Blog on Creating Percentile in DAX

I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering topics on business intelligence and data. I have worked with Josh for years at a Magenic and now Pragmatic Works. I look forward to seeing what he will be writing… Read more

0 comments, 76 reads

Posted in DataOnWheels on 24 February 2015

T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases

There are many different ways to accomplish this tasks.

Download Link

The below examples uses undocumented sp’s to loop through all the user defined database to search the SP’s using given string

CREATE TABLE  #ProcSearch  (databaseName VARCHAR(100),ROUTINE_CATALOG varchar(50),ProcName VARCHAR(128),RoutineType varchar(100),CreateDate date)

DECLARE @command varchar(1000) 
SELECT @command = 'IF ''?''…

Read more

0 comments, 69 reads

Posted in PowerSQL By Prashanth Jayaram on 24 February 2015

DevOps, the DBA, and the word “No”

Check out this DevOps Reactions animated GIF and caption.

It’s funny on multiple levels, but it also makes me both mad and disappointed.

I get mad because it’s 2015. Surely by now most of us, especially those who have worked in the enterprise with development teams, know that the old… Read more

2 comments, 90 reads

Posted in The Scary DBA on 24 February 2015

SQL Cruise Caribbean 2015 Recap

I wish I could just re-post my article from last year about SQL Cruise and change the dates and pictures.The event is just that good.

I still believe this is one of the more premier training events offered for SQL Server. The amount of 1-on-1 time you get with the…

Read more

0 comments, 62 reads

Posted in Everyday SQL on 24 February 2015

Identifying Blocking via Extended Events

There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can run the undocumented sp_who2 stored procedure but that will only give you the session that is being blocked. You could download the excellent sp_whoisactive, written by Adam Machanic, which… Read more

0 comments, 96 reads

Posted in The DBA Who Came In From The Cold on 24 February 2015

Speaking at SQLBits and SQLRally

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun.


On Wednesday, March 4, at 4:45PM, I’ll deliver my session “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.

The session talks about a big… Read more

0 comments, 72 reads

Posted in Matan Yungman on 24 February 2015

Older posts