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

Latest Blog Posts

Sort – Is it Really a Blocking Iterator?

SQL Server has two types of execution plan iterators: Blocking and Non-Blocking.

A non-blocking iterator gets rows in and sends rows out at the same time. For instance, the Nested Loops iterator gets rows from its outer input and sends the matching rows on to the next iterator without having… Read more

0 comments, 25 reads

Posted in Matan Yungman on 30 October 2014

Quick Schema Auditing

I was working on a demo recently and needed to show that a little monitoring can help you catch schema changes. At first I looked at SQL Audit and DDL Triggers, but then I ran across a short custom metric on the SQL Monitor Metrics site that my company, Red… Read more

0 comments, 78 reads

Posted in The Voice of the DBA on 29 October 2014

SQLSaturday Tampa Announced For February 28, 2015

SQLSaturday Tampa is the first SQLSaturday in Florida for 2015, scheduled for February 28th, 2015. The event is held at the USF College of Business Bldg, 12212 USF Maple Drive, Tampa, FL 33620. Easy to find, free parking, lots of hotel options near by. The weather at the end of… Read more

0 comments, 61 reads

Posted in SQLAndy on 29 October 2014

Headed to the PASS Summit 2014

I can hardly believe how fast this year has flown by. My favorite SQL Server conference of the year, the PASS Summit, is just next week! I can hardly wait! This conference is one of the largest SQL Server and BI conferences of the year, planned and coordinated by… Read more

0 comments, 39 reads

Posted in Technobabble by Klee from @kleegeek on 29 October 2014

PASS Summit 2014

Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we go back to Seattle where Microsoft mostly lives and hope we can get lots of their employees to visit and talk shop.

One of my main goals is to Network… Read more

0 comments, 37 reads

Posted in The Smiling DBA on 29 October 2014

Managing Geeks – A journey of leading by doing

I am proud to share that my good friend Andy Leonard has just released a new book. This is also the second book published by LinchpinPress.

Over the years Andy has blogged about his experiences with managing technical teams. Andy wrote over 50 post on the subject and has… Read more

1 comments, 41 reads

Posted in Tim Radney - Database Professional on 29 October 2014

SQL Server 2014 Backup and Recovery

In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my first two books, however Joes2Pros is focusing its time and energy into video content. When SQL 2014 was released and new features were added for backups, there was a… Read more

1 comments, 45 reads

Posted in Tim Radney - Database Professional on 29 October 2014

Playing with the log – Before the first full backup

The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the effect of VLF size on shrinking the log. So the other day I was asking about VLFs and got sent to this great video of a recorded session from… Read more

0 comments, 55 reads

Posted in SQLStudies on 29 October 2014

Maximum number of rows per data page and minimal record size (SQL Server storage internals)

Maximale Anzahl Zeilen je Datenseite und minimale Datensatzgröße

In einer meiner letzten Master-Classes tauchte die nicht ganz ernste aber dennoch interessante Fragestellung auf:

Wie viele Zeilen passen eigentlich maximal auf eine Datenseite? – wenn die Datensätze/Records so klein wie möglich sind.

Zunächst, Part 1, was ist der kleinstmögliche…

Read more

0 comments, 123 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 29 October 2014

Add Database File on Database invloved in DB Mirroring

Originally posted on MSSQLFUN:

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.

Steps to Add Database File on Database involved in DB Mirroring…

Read more

0 comments, 68 reads

Posted in MSSQLFUN on 29 October 2014

Introduction To SQL Server Joins with Example

In SQL Server database, if records of two or more tables have to be combined, then the Join clause is used. It is a means that combine same fields of the tables can be combined using their common values. There are five types of join clause available for ANSI standard…

Read more

0 comments, 66 reads

Posted in Zora's SQL Tips on 29 October 2014

SQL Server – Failed to bring availability group ‘[availability group name]‘ online

I have been noticing one very common error that occurs while trying to failover an Availability Group in SQL Server 2012 AlwaysON setup. The Availability Group fails to come online during a fail over process. Here is the snippet of the error message. Failed to bring availability group ‘availability_group‘ online.…

Read more

0 comments, 90 reads

Posted in - SQL in simple style on 28 October 2014

Ghosts – an eXtrasensory Experience

This is the last article in a mini-series diving into the existence of ghosts and how to find them within your database.

So far this has been a fun and rewarding dive into Elysium to see and chat with these entities.  We have unearthed some means to be able to… Read more

1 comments, 58 reads

Posted in SQL RNNR on 28 October 2014

Session: Introduction to Powershell Cmdlets for DBAs

I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged about it! Download the session recording here Download the code file here Abstract: You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell.…

Read more

0 comments, 134 reads

Posted in SQL Awesomesauce on 28 October 2014

Im At Summit Now What?

Pass Summit 2011 – Photo Provided by Pat Wright

We are a week out from PASS Summit 2014 and there will be many there attending for the first time. You are in the same boat I was in back in 2011. To be quite honest, I’ve never seen or attended… Read more

0 comments, 70 reads

Posted in The SQL Professor on 28 October 2014

Getting back to basics

I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last year. That didn’t happen. At the start of this year, I made that same commitment again. Neither did that happen. At that time, I told myself there’s still a lot… Read more

2 comments, 73 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 28 October 2014

Outlier Detection with SQL Server, part 2.1: Z-Scores

By Steve Bolton

…………Using SQL Server to ferret out those aberrant data points we call outliers may call for some complex T-SQL, Multidimensional Expressions (MDX) or Common Language Runtime (CLR) code. Yet thankfully, the logic and math that underpin the standard means of outlier detection I’ll delve into in… Read more

0 comments, 84 reads

Posted in Multidimensional Mayhem on 28 October 2014

Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve some problems very well, in a way that’s much easier than has been available in T-SQL.

However there are some things you need to understand. One of these things is… Read more

0 comments, 132 reads

Posted in The Voice of the DBA on 27 October 2014

Minion Reindex is here

We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on, and people have responded so incredibly positively. We’re quite literally thrilled. Webinar Today! Before I get to anything else: set up an alert for our Minion Reindex Intro Webinar TODAY (Monday, October 27, 2014)…

Read more

0 comments, 151 reads

Posted in SQL Awesomesauce on 27 October 2014

Older posts