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

Native SSMS a second class citizen no longer…

Intellisense can be a boon to adding quick development. Quick hints on scope specific variables, syntax suggestions, function descriptions and...

SQLSaturday Philadelphia, Cocoa Beach, Orlando, and Charleston

I’ll be attending and presenting at SQLSaturday #200 in Philadelphia in June, then I’ll be attending the first ever SQLSaturday...

Resolving data redundancy up front

 
Introduction
As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.
This is where...