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...

Force installation of 64-bit ACE OLE DB provider

Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...

PowerShell – Get an UNC of a remote folder

To Read/Write/Rename/Copy/Delete a file configured across ‘N’ of servers in the same path, this script is going to be very...

SQL – Table data – HTML Format & Email Sending using T-SQL

1) Configure DBMail  - In this case the ‘TEST’ profile being created for the demo
2) Create Table – TLOG_Metrics

3) Insert the dumnmy...

Does TDE really work on MDF files?

Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data:
-- create a...

Last Weeks Top “Reading” Links #29

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...