ICYMI- RDX Insights Webinar- Cloud’s Hidden Impact on IT Support Organizations

Check out RDX’s latest webinar, Cloud’s Hidden Impact on IT Support Organizations. We discuss the differences between cloud and on-premises systems, identify the key challenges associated with switching to cloud DBMS environments and provide proven best practices for making your transition to the cloud successful. You can view and listen to a recording of the presentation below:

The SlideShare version of the presentation can also be viewed here.

Stay tuned for information about our next RDX Insights Series webinar shortly!

Is Microsoft Azure Cosmos DB the NoSQL Competition Killer?

Most database pros are aware that the era of the one-size-fits-all database has been over for some time. We realized that not all of the data our shops are required to store, process and present to our end user communities neatly fits into relational rows and columns.

The need to store unstructured data in conjunction with the ability to provide almost absurdly high degrees of scalability, data distribution and availability were the business drivers behind the genesis of NoSQL offerings. Many of the NoSQL products were specifically designed to leverage low cost hardware to provide the ability to store semi and non-structured data and provide extremely high horizontal scalability and data redundancy at an affordable price point.

Continue reading Is Microsoft Azure Cosmos DB the NoSQL Competition Killer?

Azure Automation- Scheduling Stored Procedures

As database administrators, we are always looking for ways to automate our daily processes.  SQL Server Agent has always been a great tool for doing this, whether it be for scheduling regular maintenance or administrative jobs.  For those of you making the leap to the PaaS offering of Azure SQL databases, you will quickly discover that SQL Server Agent is no longer a feature.  For those of you who might start to panic thinking you will now be required to wake up at 2:00 AM to manually run your weekly maintenance or nightly administrative job- don’t worry! This is where Azure Automation comes to save the day!  Azure Automation brings a PowerShell workflow execution service to the Azure platform that allows one to automate those maintenance and administrative tasks all within the Azure portal and take the role of the SQL Server Agent.  To demonstrate how you can leverage Azure Automation, I will take a common request that I have encountered with many clients who have the need to schedule a stored procedure execution.

Continue reading Azure Automation- Scheduling Stored Procedures

ICYMI- RDX Insights Webinar- The Rising Interest in Open Source Relational Databases

Check out the latest RDX Insights webinar, The Rising Interest in Open Source Relational Databases. We discuss the factors driving their increase in popularity, learn how the cloud is accelerating that growth, review commercial DBMS replacement strategies and evaluate the various open source offerings on the market.

View the live recording below:

You can also view the presentation on SlideShare here.

Next month, the RDX Insights series goes back to the cloud with Cloud’s Hidden Impact on IT Support Organizations. If you’re interested in receiving an invite to July’s webinar, please email info@rdx.com.

ICYMI- RDX Insights Webinar- Microsoft Business Intelligence Overview & Power BI Demo

If you missed May’s RDX Insights webinar, Microsoft Business Intelligence Overview & Power BI Demo, you can view the recording below. RDX’s VP of Delivery Strategies and Technologies, Chris Foot, and BI Product Team Manager, Jeremy Frye, teamed up to discuss the advantages of Microsoft’s business intelligence product suite and what the future of Microsoft BI looks like. The presentation also features a Power BI demo and a discussion about how it integrates with SSIS/SSAS/SSRS. Check it out:

You can also view a version of the demo only:

Our next RDX Insights presentation will focus on the rising popularity of open source database offerings. If you’re interested in being added to our webinar invite list, please email info@rdx.com.

ICYMI- RDX Insights Webinar- Evaluating and Selecting a Cloud DBMS Architecture

If you couldn’t attend April’s RDX Insights webinar, Evaluating and Selecting a Cloud DBMS Architecture, you can check out the recording below!

We hope you can join us next month for a Business Intelligence Overview. If you’re interested in being added to our webinar invite list, please email info@rdx.com.

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

Confessions of a PostgreSQL DBA

Circa 1988.  I entered the technology space, writing SAS/JCL on an IBM 3270 for the Federal Government.  There was something missing though. Countless merges, duplicate data filtering and large data sets all seemed like a horrible waste of resources and, more importantly, time. Not only that, SAS user guides filled my entire cubicle, making it nearly impossible to evolve the skill set quickly.

Continue reading Confessions of a PostgreSQL DBA

Automation’s Impact on IT Knowledge Workers

Process automation, because of its wide range of application, takes many forms. Manufacturing companies have been using industrial robots to replace activities traditionally performed by humans for some time. Business process automation shares the same goal: to replace business functions performed by humans with software applications. Work activities that are repetitive in nature and require little intelligent analysis and decision making to complete are prime candidates for process automation.

Continue reading Automation’s Impact on IT Knowledge Workers