Common Table Expressions in SQL

In SQL Server 2005, Microsoft introduced the Common Table Expression (CTE).  CTEs share similarities with VIEWS and derived tables, but...

CISSP and Enterprise Architecture

CISSP and Enterprise Architecture
One topic that professionals pursing Enterprise Architecture roles should focus on is security.  Enterprise Architects are responsible...

The T-SQL ROW_NUMBER() Function

If you learn one new T-SQL (i.e., Microsoft SQL Server) concept today it should be ROW_NUMBER().  Introduced in SQL 2005,...

Disheartening Apples

Question:  How many Oracle DBAs can you fit in Madison Square Garden?
Answer:  None, their egos won’t fit through the door.
No,...

Friday Followup For March 21, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Index Scripting with Powershell

I’ve been actively seeking out opportunities to do more stuff with Powershell of late.
I had wanted to script out only...

More On Alas Snapshot

Hopefully you had a chance to answer the Alas Poor Snapshot, I Knew Him Well question of the day than...

PASS DBA Virtual Chapter Talk

I almost forgot to tell you about the Database Administration Virtual Chapter meeting next week, March 26th, 2014. I’ll be...

Reblog: March 14 to March 20

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!

While...