Veterans Day 2013

Tonight I’ll be talking again with my children about Veteran’s Day, what it means to me, and what I hope...

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

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 #15 Implement Database Mirroring

This reviewer is part of lesson in Implementing High Availability in SQL Server 2012. This covers about 12% of the...

MDX+SSRS #34 – Query not returning results: there are good reasons

When we are learning MDX, we unavoidably have to deal with the tools we use. Adding confusions about the behaviors...

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

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

Building The Redneck Treadmill Desk

Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of...

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

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