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

Latest Blog Posts

Outlier Detection with SQL Server, part 3.6: Chauvenet’s Criterion

By Steve Bolton

…………This is the last of six articles I’ve segregated in this middle of my mistutorial series on identifying outlying values with SQL Server, because they turned out to be difficult to apply to the typical use cases DBAs encounter. After this detour we’ll get back on… Read more

0 comments, 129 reads

Posted in Multidimensional Mayhem on 28 February 2015

Impact Series – Part 2

It’s that time again to add another impact player to the roster; this time for the month of February.

This month the nod goes to none other than Jason Strate (Blog|Twitter). A few years back I sat in on one of Jason’s sessions at PASS Summit.… Read more

0 comments, 97 reads

Posted in The SQL Professor on 27 February 2015

Friday Followup For February 27, 2015

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

  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC To Fix Index Corruption
  • Do You Need…

Read more

0 comments, 86 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 27 February 2015

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, 677 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, 109 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

1 comments, 139 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, 126 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

1 comments, 106 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, 180 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, 115 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, 142 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, 131 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, 118 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, 98 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

3 comments, 132 reads

Posted in Koen Verbeeck on 25 February 2015

PWDCOMPARE–a hidden function of SQL SERVER TIP #88


I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to share how to check encrypted password ?

Means once you stored your encrypted password in database now next step is to compare that particular password with your input password… Read more

0 comments, 68 reads

Posted in Rajat Jaiswal-337252 on 25 February 2015

How to Encrypt password in SQL Server ? TIP #87

Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect.

The first approach toward security to have a strong username & password and the next step is to have password in encrypted form.

Now this article will help… Read more

0 comments, 65 reads

Posted in Rajat Jaiswal-337252 on 24 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, 176 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, 81 reads

Posted in Kevin E. Kline on 24 February 2015

Newer posts

Older posts