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.
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.
Enterprise IT has long been an industry that plays it safe. This statement applies directly to database management systems more so than any other technology, as these essential tools act as the repository for the most prized possession an organization can have: corporate data.
Nowadays, the cloud is leveraged by almost every organization in the world in some way or another, whether it’s using Amazon Web Services Relational Database Service or something for end users such as Salesforce.com. It’s nigh-on impossible to avoid cloud computing, and these platforms have become so popular that many organizations have turned to multiple cloud-based solutions.
Whether to host applications or increase storage, migrating workloads to cloud environments is a consistent trend. However, many database support services are discovering that businesses unfamiliar with the technology often don’t know where to begin.
To further reduce storage costs, organizations are storing their information in public cloud databases.
Cloud technology is changing the way database administration services approach database design. Software produced by Microsoft and Oracle is allowing these professionals to construct scalable, protected servers for their clients.
In response to the burgeoning cloud market, Oracle has rolled out a number of applications designed to help companies streamline migration. A number of businesses interested in capitalizing on the benefits associated with the cloud are turning to database administration services to assist them. Yet, there are a few preliminary steps these enterprises should take before submitting to cloud fever.
Enterprises choosing to remain with legacy data centers won’t be able to take advantage of the Internet of Things. Database administration professionals would agree that the large amount of information being generated by Web-connected devices, ranging from smartphones to automobiles, cannot be contained or properly analyzed in a traditional system.