SQL – List All Tables, Space Usage Info & Other Details

One of the OP requested in the forum to find all table details of any database. The details which includes Number...

SQL – List All Tables, Space Usage Info & Other Details

One of the OP requested in the forum to find all table details of any database. The details which includes Number...

Stupid T-SQL Tricks – Part 1: Logarithms

Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...

Summer SQL Server & Database Events In and Around NY

Summer SQL Server & Database Events In and Around NY-

Happy May everyone! 
Hope those April showers will bring us May flowers! ...

Understanding the Three A’s of Security for SQL Server

Do you know what the “Three A’s of Security” are and how they apply to Microsoft SQL Server? Let’s look...

A New Stressor

I tend to be amused when I run into something that causes me stress because I like to think – foolishly...

And I wonder, where that column is?

I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs...

Building the SQLSaturday Orlando Marketing Plan–Part 3

Not to short change fund raising, but the toughest goal to meet for this year is registration/attendance if we’re going...

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read...

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However...