SQL Server Reporting Services- Adding SSRS to SQL Server Clustered Instance

I recently was tasked with a project to consolidate several SQL 2005 database servers down to one existing SQL 2012 database cluster.  While working on this project, I found that one of the database servers needing to be consolidated was utilizing SQL Server Reporting Services (SSRS), but the existing cluster was not configured for Reporting Services.  SSRS is not cluster aware, so adding this feature to an existing clustered instance is not straightforward and will likely lead to a rule check failure on the “Existing clustered or cluster-prepared instance” rule.  Well today is your lucky day, as I’m going to show you exactly how to get beyond this error and on your way to making your SSRS cluster aware!

Continue reading SQL Server Reporting Services- Adding SSRS to SQL Server Clustered Instance

SQL Server Enterprise Features – Data Compression

In the world of big data, we are always trying to lighten our storage footprint.  Luckily for us, Microsoft has introduced data compression as an enterprise-level feature to aid in conserving storage.  Not only are you able to save on storage, you will also dramatically reduce the number of I/O requests.  Knowing that the disk subsystem is the slowest part of our environments, these fewer I/O requests needed for retrieving data will lead to an increase in performance. 

Continue reading SQL Server Enterprise Features – Data Compression

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

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

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