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!
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.
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.
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 email@example.com.
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 firstname.lastname@example.org.
We are happy to announce that our blog made Feedspot’s list of top blogs and websites for DBAs! Check out the full list via the link below, and check back often for more DBA tips and best practices on the RDX blog.
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.
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.
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.