How to Slipstream SQL Server Install

If you cannot install SQL Server 2008 because of the known issue in the Setup program, you will have to use the slipstream method to successfully complete an installation of SQL Server. This method involves downloading the service pack package that you want for your architecture and combining that with the original SQL Server 2008 install media.

Continue reading How to Slipstream SQL Server Install

Creating SSAS Hierarchies with Multiple Dimension Tables

Recently, I was tasked with building a hierarchy using multiple dimensions. I was advised to use a named query or materialized view to accomplish this because SSAS doesn’t have the capabilities to read the columns/attributes from multiple dimensions. Since I have done this before, I decided to take the AdventureWorks database and give a step-by-step tutorial of how to accomplish this request. Let’s get started!

Continue reading Creating SSAS Hierarchies with Multiple Dimension Tables

SQL Server: CMDEXEC Subsystem Failed to Load

During your life as a DBA, you will probably have to restore the master database and all the user databases on a new operating system to bring an already existing SQL Server instance online. One of my clients recently had an issue with hardware failure. Our only option was to install SQL Server on a new OS and use the backup files to restore all the databases from the old SQL Server instance. Once the new system was completely built and we restored msdb, we noticed that some of the SQL Server Agent jobs began to fail. Below is the error output from the job history. It states that the CMDEXEC subsystem failed to load.

Continue reading SQL Server: CMDEXEC Subsystem Failed to Load

Avoid Visible Attribute Hierarchies for Attributes Used as Levels in User-Defined Hierarchies

Have you ever built a dimension in SSAS and received a blue informational warning advising you to:

Continue reading Avoid Visible Attribute Hierarchies for Attributes Used as Levels in User-Defined Hierarchies

SQL Server Performance Tuning- Eliminating Key Lookups

Recently, I had reports from one of my clients that many of their users were experiencing slowness. While investigating, I found the root cause to be a key lookup on a single function execution, completely unrelated to the activities being performed by the users. A key lookup can be a costly operation that requires additional I/O and ultimately negatively impacts performance. As we all know, the disk subsystem is the slowest part of our environments, so eliminating key lookups when you can and decreasing the amount of I/O will have a positive impact on performance.

Continue reading SQL Server Performance Tuning- Eliminating Key Lookups

SQL Server – List Row Count for all Tables and Find Largest Table in a Database

As a database administrator, I have encountered many occurrences in which a business user has asked to provide the number of rows for tables within a database. If you haven’t been asked yet, I’m sure the time will come. When it does, I have a script that you can add to your toolbox that will allow you to fulfill the request!

Continue reading SQL Server – List Row Count for all Tables and Find Largest Table in a Database

How to Use Project-Level Parameters

SQL Server 2012 introduced a feature called project parameters. Of course, like many other developers, I was stuck on not fixing something that was not broken. Over time, I learned that project parameters are very beneficial features to use, especially when moving a package from DEV to QA and finally to PROD. Let’s take a quick look at how to set up package parameters and how to use them to manipulate connection strings at runtime.

Continue reading How to Use Project-Level Parameters

SQL Server – Cluster Network Name Resource ‘SQL Network Name’ Failed to Create Its Associated Computer Object in Domain

A frequent issue that I’ve encountered while performing an installation of a SQL Server failover cluster is “The cluster resource ‘SQL Server (MSSQLSERVER)’ could not be brought online due to an error bringing the dependency resource ‘SQL Network Name (SQL2012CLS)’ online.” Upon checking the cluster events in the Failover Cluster Manager, you will find the below error.

Continue reading SQL Server – Cluster Network Name Resource ‘SQL Network Name’ Failed to Create Its Associated Computer Object in Domain

SQL Server Business Intelligence Environment Planning

One of the most critical initiatives for any organization involves building a business intelligence infrastructure and solution. Before embarking on this endeavor, it is key to put the proper resources in place for a successful business intelligence implementation and evolution.

Continue reading SQL Server Business Intelligence Environment Planning