News & Information
Young man working at a computer
Oct 30, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 12: Issues with Enabling and Disabling Batch Jobs

An in-depth look at some of the concerns involved with Enabling/Disabling entire SQL Server jobs based upon whether they should be run, or not—and then look at options for addressing those concerns....More
Fort in the road
Oct 22, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 11: A Fork in the Road

A quick overview of the pros and cons of dynamic detection at job execution time or the option of dynamically enabling/disabling jobs....More
IdeaXchange

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

Is your organization looking at augmenting your on-premises database infrastructure in the cloud?

Join the Conversation

From the Blogs
Fort in the road
Oct 22, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 11: A Fork in the Road

A quick overview of the pros and cons of dynamic detection at job execution time or the option of dynamically enabling/disabling jobs....More
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....More
Upcoming Training

Jumping Into SSAS Multidimensional

Thursday, November 13th

Although there have been a lot of new releases to support analytics, SQL Server Analysis Services (SSAS) Multidimensional still has a place in your technical infrastructure, especially if the volume of data to be analyzed is large. Join Stacia Misner and Denny Lee for three technical sessions that will help you understand how best to work with multidimensional cubes, the structure that the SSAS Multidimensional server uses to support analytical queries.

Enroll Now and SAVE 15%!
View All Online Training

SQL Server Pro Forums

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

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) ×