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

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

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

SQL Server – How to check if you are running 32-bit or 64-bit version

There are two different command you can use to check if you are running 32-bit or 64-bit version of SQL...

SQL Server : Part 10: Importance of Key Column Position While Creating Index

Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...

SQL Server Training in the Summer Time

Its been a long winter so far this weekend has seen the first signs of spring here in South Wales,...

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

Staggering SQLIO Sessions Across Multiple Volumes

In a previous post, I discussed running SQLIO against multiple files.  The purpose in using multiple files is being able...

Who writes your documentation?

I’ve been thinking recently about who writes the best documentation. Not including a professional technical writer (although they actually do...

In which we compare CISPA to Rick Astley

Wherever you click, either CISPA or Rick Astley is there…
I’m studying up on CISPA for a segment on our webshow....