Analysis Services Server Activity Monitor 2014 0.0.0.1 Alpha Released

This morning I am happy to announce the release of an alpha version of the SSAS Activity Viewer for SQL Server 2014 CTP2. The name has had a slight...

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

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

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