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

Latest Blog Posts

Reblog: November 21 to November 27

Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more

0 comments, 22 reads

Posted in StrateSQL on 28 November 2014

DBTA – For #SQLFamily, It’s the Most Wonderful Time of the Year!

It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications for the SQL Server world. Here’s a bit of context: I’m writing this… Read more

0 comments, 32 reads

Posted in Kevin E. Kline on 28 November 2014

Friday Followup For November 28, 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

  • Using Encryption To Protect Your Data From Alien Abduction
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed…

Read more

0 comments, 32 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 28 November 2014

Beware the defaults! (in windowing functions) – The Movie!

I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their SQL Server classes, they are doing a free series called SQL Server Solutions from the Web where they show different SQL Server solutions found in blog posts around… Read more

0 comments, 54 reads

Posted in Koen Verbeeck on 27 November 2014

Parameterization Part 6: Simple vs. Forced Parameterization

This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan caching works in SQL Server, what parameter sniffing is, when it’s good and when it’s bad, and also some common mistakes related to parameterization and how to avoid them.

In… Read more

0 comments, 56 reads

Posted in Guy Glantser on 27 November 2014

Audit Database File Size Changes

Recently I shared an article on how to track the growths and shrinks that occur within database files.  I shared that article here, you should read it before proceeding with today’s article.

Near the end of that article I declared that it was a really good method to track… Read more

0 comments, 62 reads

Posted in SQL RNNR on 26 November 2014

When the Problem is Not Them. It’s You.

Hello Dear Reader!  I’ve been the Data Platform Management Lead at Pragmatic Works for almost two years now.  It’s been an interesting journey that I’m enjoying.  I’m the tier 3 support in a lot of cases, play the role of manager, mentor, and fellow fighter in the trenches when required. …

Read more

0 comments, 64 reads

Posted in SQLBalls on 26 November 2014

What is Azure Data Factory?

The Azure Data Factory is a service designed to allow developers to integrate disparate data sources.  It is a platform somewhat like SSIS in the cloud to manage the data you have both on-prem and in the cloud.

It provides access to on-premises data in SQL Server and cloud data… Read more

0 comments, 104 reads

Posted in James Serra's Blog on 26 November 2014

SQL Saturday Parma – English Slide decks available to download

My SQL Saturday Parma slide decks are available to download on SlideShare.

The main topic of those presentations is database lifecycle management (DLM) on SQL Server.
Concepts: ALM/DLM, team work, differences between code and databases.
We’ve demonstrated the usage of…

Read more

0 comments, 0 reads

Posted in Alessandro Alpi on 26 November 2014

How to burn down your house while frying a turkey

It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my browser.  No, I’m certainly not looking to burn down my house.  In fact, wait here while I clear my search history, just in case.

For the sake of argument, let’s… Read more

1 comments, 68 reads

Posted in Tim Mitchell on 26 November 2014

Who’s on call

Kenneth Fisher:

I really enjoyed writing this post last year and honestly still enjoy reading it myself. And since tomorrow is a holiday for a lot of people (I’m in America so I get to make that assumption) it seemed like a good time to bring it out again.…

Read more

0 comments, 100 reads

Posted in SQLStudies on 26 November 2014

PASS Summit 2014 ~ My GameTime Experience

“How did you like your convention?”

“How was your trip?”

“What did you learn?”

“Where did you go for a week?”

“Who did you meet?”

“Talk with the vendors?”

“What is PASS Summit?”

Those are the types of questions I received after arriving back from attending PASS Summit 2014.… Read more

0 comments, 76 reads

Posted in The SQL Professor on 25 November 2014

SQLSaturday Returns to NYC 2015!

November 25, 2014 - Good news in Gotham!  Well you asked for it! You wanted it! You waited for it! And now it's finally here! It gives me great pleasure to announce the return of SQL Saturday to New York City! Save the date, May 30, 2015! Just…

Read more

0 comments, 292 reads

Posted in Pearl Knows on 25 November 2014

Placeholders for Emergencies

A long time ago I worked in a large corporation where we managed lots of servers, each of which performed a variety of different functions. Some were Exchange, some SQL, some file servers, etc. and they would come and go at a frightening pace.

We had monitoring in place, but… Read more

0 comments, 146 reads

Posted in The Voice of the DBA on 24 November 2014

Capturing DB Usage stats – sp_spaceused simulation using DMV’s.


sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The objective of this stored proc is to measure the amount of space consumed by database… Read more

0 comments, 95 reads

Posted in PowerSQL By Prashanth Jayaram on 24 November 2014

Last Weeks Top “Reading” Links #110

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 106 reads

Posted in StrateSQL on 24 November 2014

Exam Prep 70-463: Just the facts, ma’am   Recently updated !

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:

Today we’re exploring fact tables… Read more

0 comments, 413 reads

Posted in Cleveland DBA on 24 November 2014

TempDB Configuration Best Practices

1. Do not change collation of TempDB from the SQL Server instance collation.

2. Do not change the TempDB database owner from sa.

3. Do not drop the TempDB database.

4. Do not drop or revoke the guest user from the database.

5. Do not change the recovery model from… Read more

0 comments, 202 reads

Posted in MSSQLFUN on 24 November 2014

Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !

The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 74 reads

Posted in MSSQLFUN on 24 November 2014

Cumulative Update – 3 for SQL Server 2012 Service Pack 2 Is Now Available !

The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can plan… Read more

0 comments, 80 reads

Posted in MSSQLFUN on 24 November 2014

Older posts