70-457 Reviewer #14 Database and Application Roles

This lesson is part two of lesson Reviewer #13 Managing SQL Server Logins. There is so much to cover about...

70-457 Reviewer #13 Managing SQL Server Logins

This lesson covers managing security principals at the instance level. Security principals at this level allows access to the instance...

log shipping restore job failed on secondary server

Several Situation will cause the log shipping restore job failed on secondary server

1. Restore job is not able to access the...

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