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

Latest Blog Posts

New Add-on for SSMS: T-SQL Flex

Do you ever copy query results out of SQL Server Management Studio, paste them into your text editor, and then perform gold-medal find + replace gymnastics to create T-SQL scripts?

Do you ever need to copy a small amount of data from one SQL server to another, but don’t want… Read more

0 comments, 6,733 reads

Posted in New York City .NET on 8 September 2014


I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating. RECOVERY_PENDING is very different from RECOVERING. Definitions RECOVERING means that things are happening, and all may be well. “Database is being recovered. The recovering process is a transient state;…

Read more

1 comments, 262 reads

Posted in SQL Awesomesauce on 8 September 2014

I'm Speaking at SQL Saturday 300 - Kansas City and a Few Questions About SQL Saturdays!

This is just a short update. I will be speaking at SQL Saturday Kansas City! I really hope to see you all there. This will be my last SQL Saturday this year. If anyone has seen my presentation, how do you think I did?

I've wondered a few things about…

Read more

0 comments, 95 reads

Posted in DBA On The Go on 8 September 2014

SQLSaturday Orlando Marketing Plan-Part 41

Ah, an interesting week for registrations. We’ve jumped to 426 registered, making my goal of 500 doable. The jump is in part due to timing, in part due to only having mailed to the “already registered” list only last week (a goof on my part). This week we’ll have two… Read more

0 comments, 114 reads

Posted in SQLAndy on 8 September 2014

Better Presentations–Fonts

This is part of a series of tips for speakers to make your presentations better.

Please, please, please, learn how to set up your machine to look good on screen.

I saw Brent Ozar write a few notes on how to make your presentations better recently. This was primarily for… Read more

0 comments, 105 reads

Posted in The Voice of the DBA on 8 September 2014

Parameterization Part 4: Handling Non-Uniform Data Distribution

This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I mentioned that this method can be a good thing in some cases, but it can also be quite a bad thing in other cases.

One case in which parameter sniffing… Read more

2 comments, 5,029 reads

Posted in Guy Glantser on 8 September 2014

Silicon Valley is a different world

I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing their organizations with continuous delivery and design, and lean product development.

It does some of that, but it wasn’t what I expected. The attendees for the most part were people… Read more

4 comments, 153 reads

Posted in The Voice of the DBA on 5 September 2014

Reblog: August 29 to September 4

Photo credit – Travis

Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more

0 comments, 132 reads

Posted in StrateSQL on 5 September 2014

Speaker of the Month: September 2014

This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to meet a lot of new people and see presentations by people that just don’t hang around SQL Server specific events. It was great. I’m going to apply next year (depending… Read more

0 comments, 115 reads

Posted in The Scary DBA on 5 September 2014

Analysis Services Partitions

Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files. All measure groups by default have one partition but by splitting that partition you will gain improved query and processing performance.

Partitions can be split in any way you see… Read more

0 comments, 5,102 reads

Posted in Devin Knight on 5 September 2014

SSC Editorial-Titles Matter – Part 2

I wrote Titles Matter – Part 2 based on lessons learned the hard way not long ago. Titles matter because they help the rest of the team understand where you fit in. Titles are the ultimate elevator pitch – this is what I do. I was pleased to see one… Read more

0 comments, 140 reads

Posted in SQLAndy on 5 September 2014

Friday Followup For September 5, 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

  • Automated Source Control: A Librarian For Your Database Objects, Part 1
  • Automated Source Control: A Librarian For Your…

Read more

0 comments, 94 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 5 September 2014

Why You Should Go to SQL Saturday

SQL Sat Puerto Rico
Hello Dear Reader!  Soon SQL Saturday #318 in Orlando FL will be here.  The SQL Community does a lot of work at SQL Saturday’s, present at them, and help put them on.  When talking about them, one of the most frequent questions I get asked…

Read more

2 comments, 119 reads

Posted in SQLBalls on 4 September 2014

Dear IT Guy, Customer Service is part of your job

It may be true that you are one of a kind, a true techie with specialized skills that are hard to find and hire for. One thing that is more true is that customer service is still very much a big part of your job. Which equates to the fact…

Read more

0 comments, 146 reads

Posted in - Ayman El-Ghazali on 4 September 2014

Pausing an MSSQL Instance

I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop an instance, pause an instance. Start, stop, pause. Wait just a minute! Is this SQL Server or an mp3? (I just want to point out I started with a record,… Read more

9 comments, 1,174 reads

Posted in SQLStudies on 4 September 2014

How to Start SQL Server in Single User Mode ?

Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc.

Steps to start SQL Server in Single User Mode :-

1) Stop SQL Server Services

2) Add [-m] startup parameter in SQL Services from… Read more

8 comments, 4,580 reads

Posted in MSSQLFUN on 4 September 2014

Top ADO.Net Interview and General FAQs

 1.       What is ADO.Net?

ADO.Net is set of components (classes) that are used to access data based on disconnected dataset and XML.It is advancement of classical ADO that is (Active Data Objects).ADO was tightly coupled client server system which was connected architecture. Unlike ADO, ADO.NET was built with…

Read more

0 comments, 106 reads

Posted in Querying Microsoft SQL Server on 4 September 2014

Audit Webinar Tomorrow (4 September 2014)

I will be given a webinar on how to audit SQL Server through

Webinar Registration Link

The abstract:

Don’t become a statistic. With the numerous data breaches and internal data theft, securing your SQL Server environment can help keep your company out of the news. Unfortunately, a… Read more

0 comments, 118 reads

Posted in Databases – Infrastructure – Security on 3 September 2014

Off to Flowcon 2014

With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on, I thought it would be instructive to go see how the software developers build their product better. A few months ago I noticed that FlowCon 2014 was coming to San… Read more

0 comments, 111 reads

Posted in The Voice of the DBA on 3 September 2014

Left or Right?

No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a canard that still makes the rounds occasionally. Please, help me put this statement to sleep for once and all:

A function on the left side of the equals…

Read more

12 comments, 5,025 reads

Posted in The Scary DBA on 3 September 2014

Newer posts

Older posts