SYS.PARTITIONS: Better Than X-Ray Vision

Originally posted 2011-09-09 21:27:00. Republished by Blog Post Promoter

Over the past few months, I’ve been doing a lot of work...

SSAS– Resolving target machine actively refused

I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas....

Friday Followup for November 8th, 2013

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

"Failover Partner" keyword in connection string - Q&A

1. How to connect client to a Database Mirroring Session with failover aware
A: add FailoverPartner keyword in the connection string,...

Reblog: November 1 to November 7

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

What If Someone Tampered with the Process?

I’m a big fan of automation. Automation means I can do more. Automation means I eliminate the mundane stuff to...

My SQLrally Session about how to measure Index Impact Changes

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
During the...

MDX+SSRS #33 – Retrieve manager’s key and fully-qualified member name

A co-worker recently worked on a SSRS report and wanted to use a specific manager’s team for testing. The Manager...

What If Someone Tampered with the Process?

I’m a big fan of automation. Automation means I can do more. Automation means I eliminate the mundane stuff to...

Restore Script from Backup Directory – Modified

As a DBA your job is to protect the data, whether that be from corruption, attack, developers or any other...