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

Latest Blog Posts

Friday Followup For March 6, 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

  • Cheating DBCC To Fix Index Corruption
  • Do You Need A Log Recovery Tool?
  • Building (for FREE) a Virtual…

Read more

0 comments, 18 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 6 March 2015

Fun-fun-fun in the London sun (and Cardiff, and Exeter!)

We’re in London right now for SQLBits, which has been ABSOLUTELY LOVELY so far. If you’re anywhere near Cardiff, Wales on Monday 9th, or Exeter, England on Tuesday 10th, then you should hit the user group meeting, as we’ll be speaking at each!

Read more

0 comments, 19 reads

Posted in SQL Awesomesauce on 6 March 2015

SQLRally and SQLBits Slides and Demos

It’s been a great a busy week.

On Wednesday, I presented my session, “Query Progress Tracking in SQL Server” at SQLRally in Copenhagen.

On Thursday, I presented my session, “The Data Loading Performance Presentation”, at SQLBits in London.

Thanks to everyone who attended my sessions. I had a lot of… Read more

0 comments, 36 reads

Posted in Matan Yungman on 6 March 2015

Exam Prep 70-463: SSIS Transactions and Checkpoints  

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, 94 reads

Posted in Cleveland DBA on 5 March 2015

Presenting with Tegile at Lincoln SQL Server Users Group Thursday

This Thursday I will be joining an open discussion with Tegile Systems and the Lincoln SQL Server Users Group on the challenges for the DBA when it comes to handling large amounts of data. Everything from storage to CPUs and virtualization will be discussed, and both OLTP and BI systems… Read more

0 comments, 66 reads

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

SQL Code Guard v2.7 and SQL Server 2008R2: bad news and good news

Hi all!
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I know about this issue, already fixed it in my development environment and will release fix in nearest possible future.
Bad news (again) : integration will not work with…

Read more

0 comments, 120 reads

Posted in SQL Code Guard on 4 March 2015

I want to blog but …

I don’t know how to get started.

Pretty simple. There are a number of free blogging sites out there. Personally I use WordPress. All you need to do is go to and sign up for a free space.

I have a blog but setting it up seems like a…

Read more

0 comments, 93 reads

Posted in SQLStudies on 4 March 2015

Small presenter tip: changing display mode automatically after presenter view

This morning Adam Machanic (blog | twitter) asked the following question on Twitter:

A very interesting question, as I… Read more

0 comments, 113 reads

Posted in Koen Verbeeck on 4 March 2015

Kill–use this weapon carefully in SQL SERVER . TIP #90

When we heard “Kill” then first impression of this word is very bad. We always scare with this word.

In real world we never want this action  from anyone but in SQL Server case it is very helpful and help us many times.

This feature we can use but very… Read more

0 comments, 68 reads

Posted in Rajat Jaiswal-337252 on 3 March 2015

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, 119 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, 67 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, 109 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, 76 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, 81 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, 81 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, 162 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, 83 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, 83 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

6 comments, 120 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, 94 reads

Posted in SQLStudies on 2 March 2015

Older posts