News & Information
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

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
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

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!

What’s your favorite SQL Server feature?

AlwaysOn
30% (162 votes)
In-Memory OLTP
18% (95 votes)
Reporting Services
15% (80 votes)
Database Mirroring
7% (39 votes)
Columnstore Index
7% (38 votes)
Replication
7% (38 votes)
Transparent Data Encryption
5% (27 votes)
Backup Encryption
4% (19 votes)
Azure Integration
3% (17 votes)
Resource Governor
3% (17 votes)
Total voters: 532

Join the Conversation

From the Blogs
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

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
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

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
Jun 10, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 26: Using Master Servers for Job Administration

When I initially decided to write about AlwaysOn Availability Groups and SQL Server Jobs, I knew I’d have a bunch of different posts on a variety of different topics. To that end, I initially planned on this series of posts being comprised of 3 main parts:...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Community Sponsors

Readers Contribute

If you would like to submit an article, please ensure you are logged in and then click Contribute.

If you are not a registered user on SQL Server Pro, click Register.

SQL Server Pro Guest Blogs
Online Conference

Deploying Affordable, High Performance Hybrid Storage for Clustered SQL Server

On Demand
Watch this webcast to learn about some essential best practices in storage, and how you can ensure that your SQL Server instances are performing at their best. Gain insight on:

--Storage challenges.
--Using SANs with SQL Server.
--Best practices with Tempdb.
--Using flash technology with SQL Server.
 

Register Now

Sponsored Introduction Continue on to (or wait seconds) ×