Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Partition Switching #TSQL2SDAY #77


The ALTER TABLE..SWITCH command allows you to almost instantly move large amounts of data from one table to another. It does this by not physically moving the data but by updating the meta data that points to the data. I have found many uses for this statement in the… Read more

4 comments, 994 reads

Posted in The Database Avenger on 12 April 2016

T-SQL Tuesday #77–My Favorite Feature

This month is an interesting, but tough topic. The blog party is hosted by Jens Vestergaard, and his invitation is short and simple. Pick your favorite feature and write about it. This is good, because SQL Server has grown so much, I’m sure that many people will choose different things.… Read more

0 comments, 180 reads

Posted in The Voice of the DBA on 12 April 2016

Speaking at SQL Saturday #526 in Rochester on May 14, 2016

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded individuals, SQL Saturday is for you. It’s a day chock full of SQL Server related presentations given by other members of the community.

Here is a glimpse of my presentation… Read more

0 comments, 95 reads

Posted in on 12 April 2016

SQL Server 2016 features: Live query statistics

Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query to finish? Now you can.

Enable that and run a query, and you get an execution plan immediately, one with a few more details in it than we’re used to. Read more

0 comments, 67 reads

Posted in SQL In The Wild on 12 April 2016

A View Is Not A Table

Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel

In SQL Server, in the T-SQL you use to query it, a view looks just like a table (I’m using the AdventureWorks2014 database for all these examples):

FROM    Production.vProductAndDescription AS vpad;



Read more

8 comments, 2,242 reads

Posted in The Scary DBA on 12 April 2016

Insurance For Events

Posting here mostly because I’ll need this link again sooner or later! We’re hosting our more or less annual joint meeting of OPASS & MagicPass this  month and the facility we use requires an insurance certificate. We use It was $105 for the one day certificate. Takes five… Read more

2 comments, 133 reads

Posted in SQLAndy on 12 April 2016

SQL Server Service Broker – Sending and Receiving

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.

Previous posts:

Read more

1 comments, 1,077 reads

Posted in Cleveland DBA on 12 April 2016

The risks of Delayed Durability

It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about our favorite SQL Server feature. Great topic, but a really difficult choice. There are so many great features of SQL Server.
Some of my favorites include: Read more

0 comments, 793 reads

Posted in SQLStudies on 12 April 2016

Weekly Roundup–SQL Server and Related News

Happy Tuesday . Here's the latest technology based blogs and articles I have been reading this week. Mainly SQL Server themed but a couple of others in there for good measure.

SQL Server

Searching for a string in an Object definition in a database. That is find a reference to…

Read more

0 comments, 106 reads

Posted in The SQL DBA in the UK on 12 April 2016

End of Support - SQL Server 2005

It finally comes to this date, 12th April 2016, the end of support for SQL server 2005! SQL 2005 is with us for 10 years, its one of the major upgrade from SQL 2000 and is one of the major step that bring SQL to success. Everything has its ends…

Read more

0 comments, 126 reads

Posted in Dennis's SQL Blog on 12 April 2016

SQL Server 2005 is Now Out of Support (12 April 2016)

SQL Server 2005 is now out of support. I remember going to a SQL Server 2005 launch event at the premises of Microsoft partner is South Wales back in the day.

It feels like the end of an era.

If you still have SQL Server 2005 instances and databases you… Read more

0 comments, 120 reads

Posted in The SQL DBA in the UK on 11 April 2016

SQL DB Details Of Multiple Servers Using PowerShell


One of my blog reader requested me to get the DB details(Server,DBName,Size,SpaceAvailable,LogSize,PercentUsed Log Space,compatiblilty mode, recovery model etc:-) using PowerShell hence this post is written.

The power of PowerShell is to capture an output of DBCC commands and store it an variable for later processing of the desired result Read more

4 comments, 1,008 reads

Posted in PowerSQL By Prashanth Jayaram on 11 April 2016

Changing the sa Password with SSMS–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I wanted to make a quick note on changing the sa password, as this is a sensitive account, and the password should be changed if you ever… Read more

0 comments, 1,132 reads

Posted in The Voice of the DBA on 11 April 2016

VS Live 2016 – Las Vegas Follow Up

I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were available for attendees, the code was not distributed yet as an oversight on my part. In this post, I will do a quick summary of the sessions and… Read more

0 comments, 95 reads

Posted in DataOnWheels on 11 April 2016

MongoDB -Get Total datasize of all DB’s

var sum = 0; db.getMongo().getDBs()[“databases”].forEach(function(x) { sum += db.getMongo().getDB( }); print(sum );

db = db.getSiblingDB(“admin”);
dbs = db.runCommand({ “listDatabases”: 1 }).databases;
var sum1=0;dbs.forEach(function(database) { sum1+=db.getMongo().getDB( }); print(sum1);

Read more

0 comments, 89 reads

Posted in PowerSQL By Prashanth Jayaram on 11 April 2016

What is code coverage for?

Code coverage gives you an indication of how well tested a particular area is. It is not a measure of code quality and having a statement covered by a test does not mean that the code is accurate.

Using code coverage you can see how risky changes are to a…

Read more

0 comments, 172 reads

Posted in Ed Elliott's Sql Developer Blog on 11 April 2016

Unix Basic Commands

In similar context to my previous blog I'm providing a list of UNIX basic commands which you may find handy if your new to the UNIX world.

UNIX Help Command
  • man <command>
  • man man –gives details of the man command
UNIX File Operations Commands

Piping operators for I/O redirection
  • >file…

Read more

0 comments, 181 reads

Posted in Kruti's SQL Blog on 11 April 2016

Cloud backup - MS StorSimple Applicance

In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure, you can find the post here. I also mention that there might be some concerns to backup directly to cloud where the backup to URL statement doesn’t support keep…

Read more

2 comments, 1,459 reads

Posted in Dennis's SQL Blog on 11 April 2016

Starting with MS SQL Server

In one of my previous blog ( ) I gave a basic introduction about what is A Database and what is SQL.

Now let us start with basic of Microsoft SQL Server and how to work with it. I am a fan of MS SQL Server. It is easy… Read more

1 comments, 160 reads

Posted in SQLdose on 10 April 2016

XP_CmdShell isn’t Evil

Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have the power to turn on and use xp_cmdshell anyway.  Xp_cmdshell is not a security hole. This is a reprint of Sean McCown’s original post on DBARant. You know, reprinted…

Read more

20 comments, 1,306 reads

Posted in SQL Awesomesauce on 9 April 2016

Newer posts

Older posts