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

Parallel Data Warehouse (PDW) Tip: Useful Appliance Queries

This post contains the following queries that support development and operational tasks within a Microsoft Parallel Data Warehousing (PDW) Appliance...

SQL Saturday 207 Yaounde Cameroon

SQL Saturday 207 Yaoundé Cameroon, is holding its first SQL Saturday on June 8th. Due to the remoteness from the...