Notes From SQLSaturday South Florida

Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...

Reflections On Fathers Day

Fathers Day coincided with the family vacation this year and maybe more than some years I had the time to...

What I Love About SQL Server

Well, there are many things I love about SQL Server. Otherwise, I wouldn’t spend my whole career around it, would...

Book Review: Why You Should Read Expert Cube Development With SSAS 2012 Cover to Cover

Expert Cube Development with SSAS 2012 Multidimensional Models was published earlier this year by Packt Publishing. It’s the second edition...

How to remove CardinalityEstimate in query plan on computed columns…

Hello,
I have come across a really good tip if you’re using computed columns that involve a concatenation of columns and...

PASS SQLSaturday Events: July 2014

 
DateEventJuly 12 SQLSaturday #312 – Sacramento 2014July 26 SQLSaturday #302 – Albany 2014July 26 SQLSaturday #322 – Guatemala 2014The post PASS SQLSaturday Events:...

Differences In Native Compiled Procedures Execution Plans

All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...

Friday Followup For June 13, 2014

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

Query backup history

As a quick script tip for today I'll show you a script I use regularly for reporting purposes.
It shows you the...

Query backup history

As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.

It shows you the...