The Perks of RDX’s Service Delivery Model from the Eyes of a DBA

Recently, I’ve been asked by a couple of prospective clients how RDX’s service delivery model is the correct choice for their company and their specific environment.  It hasn’t been a question that I’ve honestly pondered before until lately; all I really thought about prior to getting asked this question is that we aim to strive to do the best for all of the clients that we work for and with, and that we do a great job at it. 

Continue reading The Perks of RDX’s Service Delivery Model from the Eyes of a DBA

Naming Azure SQL Servers

As technology advances and organizations grow, cloud computing and hosting are becoming  a part of our organizations more and more.  One of the new offerings by Microsoft is their Azure platform with one of the services being the Azure SQL database.  While working with the Microsoft Azure platform during a recent project, I discovered the ability to name your own Azure SQL server in the Azure Preview Portal, a feature that isn’t available in the Azure Management Portal. I’d like to share this feature with you. 

Continue reading Naming Azure SQL Servers

Part 1: MDX Code Development for Beginners

As business intelligence continues to make a big splash into businesses, SSAS and cubes are becoming a requirement. One of the limitations that DBAs face every day is converting from reading and writing T-SQL statements to being able to read and write MDX with ease. In order help others who may have been thrown into the role, I am going to start a series on MDX code writing.  This blog post will be geared towards translating a simple T-SQL SELECT statement into an MDX SELECT statement.

Continue reading Part 1: MDX Code Development for Beginners

SQL Server- Use Database Snapshots for Code Deploys to Recover a Single Table or Entire Database

I have found that database snapshots are under-utilized and wanted to show an example of how efficient it is to use them prior to a code deploy for the purpose of recovering a single table or reverting an entire database from a snapshot in the event of unexpected functionality within an application.

Continue reading SQL Server- Use Database Snapshots for Code Deploys to Recover a Single Table or Entire Database

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