Category: Business Intelligence

SQL Server configration settings – MAXDOP, to be or not to be?

TweetAs a DBA parallelism or MAXDOP terms do not need any special introduction, but it is highlgy essential to keep up the necessary settings (default value is 0) on your data platform. In many cases MAXDOP helps to achieve optimization…

SQL Server Replication error – distribution agent failed to create temporary files, multiple error codes

TweetDistributor has an important place and piece of puzzle within the SQL Server replication. The key objective for distributor and distribution database to store metadata and historical data pertaining to all types of replication transactions.  By default we can configure…

SQL Server 2012 installation on Windows 7 – muted failure

TweetWhen I was trying to install SQL Server 2012 Developer Edition on a Windows 7 Ultimate edition machine, after clicking the ‘Setup’ it simply mutes out without any error. After a struggle of few minutes I was able to find…

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 2012 Feature pack, additional value to your core data platform

TweetSQL Server 2012 Feature Pack, as the name suggests the pack contains important collection of stand-alone packages that provides additional value and helping hand to your design, development, maintenance & support of your data platform. Microsoft development team consistently updates…

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…