Developers and independent software vendors who often run hundreds — or even thousands — of separate databases for their customers now have a new option to manage them while keeping costs predictable.
Microsoft has added a new Azure SQL option called Elastic Pools which automatically scales cloud databases up or down as conditions dictate. Azure SQL Database elastic pools were first announced ...
Elastic Database Jobs is a service that supports any combination of database targets, including all the databases on a server, in an elastic pool, singleton databases, and across multiple servers, ...
If you are an old hand at Microsoft SQL Server, you have probably used the SQL Server Agent (i.e., SQL Agent) service and MSDB database for the last 20 years. With a humble and largely unchanged ...
Microsoft has detailed a couple of improvements to the way Azure SQL Database handles failovers in case of an outage. It works with individual databases, elastic pools, or a combination of both. The ...
Paychex currently handles time tracking and payroll services for millions of hourly workers across two continents. And as Paychex has been migrating their on-premises environment to the cloud and it ...
Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in ...
If you're considering moving your on-premises SQL Server databases to the Microsoft Azure cloud, you need to decide which of the different cloud options works best for you. You might not realize it to ...
Microsoft's Azure SQL Database is getting an expanded range of performance tiers, upping the Standard tier maximum DTUs to 3000. Storage add-ons are also available for the different tiers.