Outlining (Day 22)

SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...

The world of Automatic Tuning – SQL Server 2017

Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...

Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...

Count_Big() function

Learned new function for count while going through the channel 9 video for salva. where for a very big table...

SQL in the City is coming Feb 28

The next edition of the SQL in the City broadcast is coming Feb 28, and I’m planning travel now to...

WIT: A Quick Thought

I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time....

What’s dbo?

Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems...

Learn Different Options for Importing Data Into SQL Server

Most of the time users need to import their data into SQL Server for its proper management. Select from the...

Perfecting my presentations

After a considerable amount of “umming and ahhing” last year I decided to start presenting full hour long sessions. Well,...

What is VMware vSAN?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...