Script, store and transfer data using XML, XQuery and clipboard

When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...

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

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

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

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

SSIS Lessons Learned, Or Not, And Mistakes Beginners Make

It’s been a while since I’ve used SSIS for anything of substantial complexity, and a lot longer than that since...