DMV-8 : Check Space consumed by Database……..sys.dm_db_file_space_usage

sys.dm_db_file_space_usage DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms174412.aspx
Returns space usage information for each file in the database.
It’s...

Thank you Triangle SQL Server User Group

Thank you TriPASS for a great SQL Server Users Group session tonight! Thank you all for attending, and your questions...

Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend

We are down to the last few days before first SQL Saturday in Fargo.  It’s been some work pulling it...

PowerSQL – Database Backup Report across all Servers – Centralized Approach

This topic provides and describes the quickest way to find when and what databases are being backed up recently.Backups are...

snippet designate a certain time of the day in getdate()

Snippet to designate a certain time of the day to evaluate in the current day. If you need to limit a...

Restoring Azure SQL Database to a Local Server

In last week’s post, I talked about the steps required to backup a Azure SQL Database.  That post leaves us...

Industry Expert Interview

I don’t know if I would consider myself an industry expert, but hey, it says it on the Internet, so...

Review of The Way

The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...

Speaking at the 2013 Carolina Code Camp

On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...

Service Application Architecture

Hello Friends,

As discussed in my previous blog the new architecture of Service Application in 2010. Today I am here with...