The Merge Join Transformation and a SSIS Sorting Tip

My previous blog post was about the SSIS Lookup task and how it really works. Now that I have shown that the Lookup task shouldn’t be used for one-to-many or many-to-many joins, let’s take a look at the Merge Join transformation task. If you follow along with this blog, you will learn a little tip that will eliminate the requirement for you to add a SORT transformation task within your data flow task.

Continue reading The Merge Join Transformation and a SSIS Sorting Tip

Considering Cloud DBMS Systems? Choose Your Architecture Wisely!

Databases in the Cloud
Technology leaders are being inundated with a flood of new cloud architectures, strategies and products – all guaranteed by vendors and various industry pundits to solve all of our database challenges.  The seemingly endless array of public cloud based DBMS offerings can quickly become bewildering.  This article is intended to peel back the veil of cloud based DBMS offerings by providing readers with our experiences with cloud based database architectures.

Continue reading Considering Cloud DBMS Systems? Choose Your Architecture Wisely!

How RDX Remote DBAs Stay on Top of Evolving Technologies

As the modern database continues to grow, its inherent feature set expands alongside it. More solutions allow remote DBAs and internal teams alike to solve business problems tied to cutting costs and improving efficiencies. However, with these solutions comes increased complexity surrounding database administration, and it falls on the shoulders of DBAs to understand and leverage the industry’s evolving technologies.

Continue reading How RDX Remote DBAs Stay on Top of Evolving Technologies

How to Configure Read-Only Routing for an Availability Group

One of the main benefits of an AlwaysOn Availability Group is being able to read off of the secondary replicas. However, Read-Only Routing is not automatically configured when you first build your AlwaysOn Availability Group. To fully utilize an AlwaysOn Availability Group and take full advantage of having read-only connections connect to your secondary database, you will have to configure Read-Only Routing.

Continue reading How to Configure Read-Only Routing for an Availability Group

Experienced Remote DBAs: Retaining Talent at RDX

As the strategic role of databases continues to advance within organizations, the task of finding and retaining experienced DBAs has become increasingly difficult. DBAs are seen as the “Go-To” specialist for internal IT teams due to their knowledge across a wide spectrum of information technology and processes. In an increasingly complex environment, database administrators design, support, and safeguard a company’s critical data stores, ultimately allowing organizations to make better business decisions.

Continue reading Experienced Remote DBAs: Retaining Talent at RDX

T-SQL Query- Search for Column Details by Name

Oftentimes, I am presented with queries from a client with a myriad of joins that have no table aliases. In order to improve performance, I often will have to create temporary tables from pieces of the query, and sometimes they need to be created manually as opposed to performing a SELECT INTO.  Having to search through all of the tables through the GUI manually to determine the proper information on the columns can be quite a pain and a waste of time.  In an effort to better utilize my time, I created a simple query that will return where the column resides as well as everything you need to know about the column and more.

Continue reading T-SQL Query- Search for Column Details by Name

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

Subject Matter Experts: Specialized Database Support

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.

Continue reading Subject Matter Experts: Specialized Database Support

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

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