![]() It’s a scheduling engine with (very) basic workflow capabilities. SQL Server Agent is a bolt-on service to the SQL Server database engine. The use – and misuse – of SQL Server Agent Global scalability, built-in high availability and a strong T-SQL language often make using it an obvious choice for developers. The service’s latest release, V12, now has almost all of the core database engine’s functionality and a few exclusive extras. There were tears from the community but more significantly, there were roadblocks stopping adoption. Wrapping that many capabilities into a fully managed API based service meant tough decisions. The reason SQL Server is popular is because of its scalability and broad range of features. The Azure SQL Database service has had a bumpy few years, as well as a few names. So now is as good a time as ever for database developers and administrators to transition to a world where their favourite agent is missing. ![]() Platform as a Service capabilities are, and should be, promoting platform wide approaches to scheduling. ![]() The reality is, it’s absent rather than missing. His role is to guide and lead organisations through data platform transformation and cloud adoption programmes.ĭespite Microsoft continuously adding functionality to it, the Azure SQL Database service has always been missing one key feature – SQL Server Agent. Gavin Payne is a principal architect for Coeo, a SQL Server and Azure professional services company, and a Microsoft Certified Architect and Microsoft Certified Master. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |