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!
IT professionals can attest – the world in which we operate changes rapidly. For database administrators, it can be a blessing and a curse all at once. With technology continually advancing, database vendors are forced to implement new features and functionalities in order to stay competitive. Each release contains dozens of advancements and new additions that can potentially be leveraged to improve the database environments they manage. Part of what makes being a DBA so rewarding is the ability to evaluate and understand these inherent features, choosing to implement those that pose the greatest benefit to each application.
I use the title "Data Administrator" loosely to describe the functions these IT specialists provide. I use it for clarity only in this article because I think it oversimplifies the important role they play. Data Administrators are more aptly titled "Protectors of the Organization's Critical Data Assets." From establishing proper naming conventions to implementing corporate-wide data management policies, the services they provide range the spectrum.
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.
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.
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.