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

Reblog: June 6 to June 12

Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...

SQL Saturday South Florida And Then Vacation

I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...