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

Latest Blog Posts

Speaking on Streamlining SQL Server Implementations Across Organization – Silicon Valley!!

In this session Prakash will walk through the process implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 56 reads

Posted in SQLFeatures on 3 March 2015

Presenting for Omaha SQL Server Users Group Wednesday

I am pleased to be presenting a highly interactive session tomorrow evening that is a full end-to-end setup and management demonstration on SQL Server AlwaysOn Availability Groups for the Omaha SQL Server Users Group.

During our November meeting, we took a quick non-scientific poll of some of the topics… Read more

0 comments, 35 reads

Posted in Technobabble by Klee from @kleegeek on 3 March 2015

How to Fix Latch Problems when Working with Ascending Keys in SQL Server

Traditionally, we want our Clustered Index to have the following attributes:

  • Narrow: So that our clustered index and the non-clustered indexes that point to it will be as slim as possible
  • Static: So that we don’t generate fragmentation in the clustered index and we don’t have to update the non-clustered…

Read more

0 comments, 48 reads

Posted in Matan Yungman on 3 March 2015

50 Shades of Brown – The Series

That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to tell you about something that is critically important to every business. But why Shades of Brown if it is critical? Everybody knows that it’s red alerts that signify things are… Read more

0 comments, 47 reads

Posted in Richard Douglas on 3 March 2015

Simple-Talk Article

In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated into one. I really wanted to talk about the database design issues I see with a development department. Please give some time to reading the article and comment. First, I… Read more

0 comments, 50 reads

Posted in The Smiling DBA on 3 March 2015

SQL Server, Error message 1785, and cascading deletes: How it kills kittens

I've been gone for a bit, forgive the long delay. Who would have thought the hatred for a cascading delete would cause an update? Strange isn't it? So where to begin?

It was a dark and stormy night... Wait, wrong movie. 

I just finished a design on a project for…

Read more

0 comments, 58 reads

Posted in DBA On The Go on 3 March 2015

Should I check tempdb for corruption?

You all know that checking our databases for corruption regularly is a must. But what about tempdb? Do you need to check it as well?

The maintenance plans that come with SQL Server do not run DBCC CHECKDB on tempdb, which is a strong indicator that it’s a special database… Read more

0 comments, 124 reads

Posted in SpaghettiDBA on 2 March 2015

ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance

Don’t miss these great articles on from the industry’s top experts:


Erin Stellato (b | t) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of running DBCC CHECKCONSTRAINTS, including explaining why some check methods… Read more

2 comments, 61 reads

Posted in Kevin E. Kline on 2 March 2015

SQLBits XIV – Welcome to the UK

A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was something just for people from the UK has been transforming into something much larger, more multicultural and more engaging as the community grows. Now we find that quite a large… Read more

0 comments, 61 reads

Posted in Richard Douglas on 2 March 2015

No Such Thing as a DevOps DBA

Sjor Takes (b|t) has just barely started blogging, but he’s got a great post about a discussion he had with a colleague. It’s worth a read. When you get done, I’ll provide my answer to the question posed at the start and conclusion of his post.

I had… Read more

3 comments, 90 reads

Posted in The Scary DBA on 2 March 2015

SQL Judo’s Monthly Challenge – March 2014 – Powershell something

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For… Read more

0 comments, 66 reads

Posted in SQLStudies on 2 March 2015

NJ SQL UG Event: 13 Advanced SSAS Tips - Kevin S. Goff

Greetings!  If you are local, or in the NY/Central NJ area, mark you calendars for WED. MARCH 11, 2015 @ 6:00PM, in Iselin, NJ's Microsoft Office, hosted by the Central New Jersey SQL Server User's Group (CNJSSUG), where Kevin S. Goff, goes well beyond the basics of… Read more

0 comments, 147 reads

Posted in Pearl Knows on 2 March 2015

Clustered Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”)

Continuation from the previous 48 parts, starting from Having blogged a couple of times on the matters of Segment Elimination (“Data Loading for Better Segment Elimination”, “Deleted Segments Elimination” ), I decided to go 1 step deeper in this…

Read more

2 comments, 118 reads

Posted in Niko's blog on 28 February 2015

Secure your password with HashBytes TIP #89

Dear Friends,

In my last article (TIP 87) I wrote about PWDENCRYPT.  I forgot to write few details but thanks to all my talented friends & blog readers who guided me by providing there feedback on post.

I respect their inputs and always interested to get more inputs. Thanks… Read more

0 comments, 73 reads

Posted in Rajat Jaiswal-337252 on 28 February 2015

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, 113 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, 91 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, 81 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, 642 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, 103 reads

Posted in Databases – Infrastructure – Security on 26 February 2015

Older posts