My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More

July 24th marked the General Availability release of major updates to Power BI Service and Power BI Desktop, Microsoft's cloud-based analytics and data visualization platform. Today's updates replace the previous "Power BI for Office 365" version and Power BI service that required either a subscription to Office 365 or Sharepoint Online for access.
Power BI Desktop...More

Are you looking for online training opportunities for next week for you or your staff?
We have two sessions next week - both qualify for our Special Mid-Summer Training Sale providing high-quality training to you for only $99!...More

Making Your First Public Presentation
Have you ever found yourself sitting at a conference like the SQL PASS Summit or your local SQL Saturday listening to a dynamic speaker making a complex topic seem simple and found yourself thinking that you wish you could do that? If you are like me, you have....More

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More

This article is the second part in a two-part series about system-versioned temporal tables—a new feature introduced in Microsoft SQL Server 2016. Part 1 covered what system-versioned temporal tables are, how to create them and how to modify data in them. This article focuses on querying data and optimization considerations....More

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....More

IdeaXchange

IdeaXchange is timely, provocative, tech-savvy content for SQL Server Pro readers. Check out our experts and what they have to say!

Join the Conversation

From the Blogs

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....More