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

Latest Blog Posts

Using Solutions in SSMS

There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions, my script for finding where backups are taken, Paul Brewer’s sp_RestoreGene to name a few. It gets tiresome at best to constantly be looking… Read more

3 comments, 224 reads

Posted in SQLStudies on 11 March 2015

Audit Schema Change Report

In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion.  You can read about that here.  I recommend reading that article first because it helps to lay some of the groundwork for this article.

Within Management Studio, from a… Read more

4 comments, 4,811 reads

Posted in SQL RNNR on 11 March 2015

SQLRally Nordic 2015

Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a mini PASS Summit, if you like. The event last week was 3 days long, and it was the biggest ever – close to 600 people.


I had a great… Read more

0 comments, 211 reads

Posted in Guy Glantser on 10 March 2015

Can an EKM Save The World of Data?

Reading Time: 4 minutes

Quis custodiet ipsos custodes?

Who will guard the guards themselves? – Latin

Let’s talk a little about how data is most commonly leaked from a database.

The user.

Now to be really frank and honest, there is not much we can really do about loss of… Read more

1 comments, 5,593 reads

Posted in WaterOx SQL on 10 March 2015

Azure Data Factory

What is the Azure Data Factory?

The Azure Data Factory is a managed service for data storage and processing.  It allows you to build cloud based solutions to move and store your data in a centralized managed environment.  Source data can be pulled from on premise or cloud environments consisting… Read more

0 comments, 110 reads

Posted in Business Intelligence and Enterprise Architecture on 10 March 2015

Making Sense of PCIe SSD Use with SQL Server

When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to achieve 100,000 IOPS, the IT world went wild.  While Fusion IO certainly is a pioneer in the PCIe SSD space, this technology has come a long way in its short… Read more

0 comments, 3,842 reads

Posted in Adam Kreul | Blog on 10 March 2015

SQL Nexus Might Just Save Your Bacon

The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it has been available since approximately 2008. SQL Nexus is a tool that that is designed to collect and analyze data to help you troubleshoot SQL Server performance issues. There are…

Read more

0 comments, 173 reads

Posted in Everyday SQL on 10 March 2015

A Comprehensive Manual to Manage SQL Server Database

SQL Server is a uniquely designed Relational Database Management System developed by Microsoft. Its basic functionalities include storing, manipulating and retrieving data requested by multiple software applications running on a single computer or on any other machine across a network.

Details of SQL Server Database:

For storing SQL Server…

Read more

0 comments, 147 reads

Posted in Rajat Jaiswal-337252 on 9 March 2015

ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo – SQL Server Performance

Aaron Bertrand (b | t) is on a roll this month’s SQL Server performance highlights with more great articles from


Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes

Aaron Bertrand (b | t) hit some obstacles recently when configuring an Availability… Read more

2 comments, 110 reads

Posted in Kevin E. Kline on 9 March 2015

Upcoming Events Where We Can Chat

I get around quite a bit.

Next week I’ll be visiting three cities in Germany talking to user groups in Frankfurt, Cologne and Munich on the 17th, 18th, and 19th of March, respectively. Here’s the one link I can find for information. EDIT: Here’s Cologne and here’s Munich.

Next,… Read more

0 comments, 99 reads

Posted in The Scary DBA on 9 March 2015

Exam Prep 70-463: Logging in SSIS 2012

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, 2,486 reads

Posted in Cleveland DBA on 9 March 2015

Who’s using that database?

A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else is in the database and you need to find them and kick them out before you can proceed. Historically I would use sp_who and scroll down the list looking for… Read more

0 comments, 5,875 reads

Posted in SQLStudies on 9 March 2015

Keep VM snapshot growth from wrecking your day

VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill the datastore the VM resides on? You know what happens… even the best VM admins out there seem to get burned once when they… Read more

0 comments, 4,226 reads

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

Why You Shouldn’t Skip the Infrastructure/Security Architecture Review

It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of developers. There are no server or network folks, much less any DBAs or security personnel. When I’ve brought this up to some of my developer friends, they wonder what the… Read more

0 comments, 4,602 reads

Posted in Databases – Infrastructure – Security on 9 March 2015

SQL Saturday Oklahoma City, OK: 422 August 29th, 2015!

We're proud to bring back the OKC SQL Saturday for the 5th year in a row! We have 3 precons setup and ready to cover almost any interest! You can find more information about them here.

We're hoping to see new speakers this year! 

We will still have our…

Read more

0 comments, 88 reads

Posted in DBA On The Go on 9 March 2015

Data Compression– a unique feature of SQL Server TIP #91

A part from performance many times we faced challenges related to space  of our database. Sometimes our database is actually taking huge space and sometimes it our mistake due to which it took space.

It is worst condition when you are on a dedicated hosting or cloud hosting with limited… Read more

0 comments, 137 reads

Posted in Rajat Jaiswal-337252 on 8 March 2015

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, 121 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 happen to’ve seen our precon or one of our sessions, please submit feedback! If you’re anywhere near Cardiff, Wales on Monday 9th, or Exeter, England on Tuesday 10th, then you should hit the user…

Read more

1 comments, 166 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, 166 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, 5,344 reads

Posted in Cleveland DBA on 5 March 2015

Newer posts

Older posts