Category: DBA

SQL Server Reporting Services: The permissions granted to user ‘mydomain\myAccount’ are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

TweetThe issue was reported by one of the Application Support team stating that they have problems with accessing reports in Reporting Services from Team Foundation Server (TFS) side. By default certain users are part of local domain group having LOCAL…

SQL Server data platform upgrade – Why upgrade and how best you can reduce pre & post upgrade problems?

TweetSQL Server upgrade, let it be  database(s) or instance(s) or both the process and procedures must follow best practices in order to reduce any problems that may occur even after the platform is upgraded. The success of any project relies upon…

Microsoft SQL Server 2008 R2 Administration Cookbook

TweetIts one year on my first book released, keeping aside the financial gains from this book I’m more happy to achieve one of the important goals from my career.  This is something big in my life to announce, it gives…

Microsoft Assessment and Planning Toolkit 6.5 Now Available for Download

TweetMicrosoft Assessment and Planning (MAP) toolkit helps the migration of your IT environment, in specific I use this product whenever a database and instance upgrade projct is planned. The MAP 6.5 adds the cloud migration planning too, that confirms journey…