While we can schedule SQL Server Agent jobs and SSRS report subscriptions, the actual time that we want to run them is dependent on when certain processing in our SSIS packages is completed. We also have certain business rules surrounding launching these jobs that we need to enforce which the built-in scheduling capabilities cannot accommodate. For example, we execute a SQL Server Reporting Services (SSRS) report subscription every Monday at 8:00AM but we want to skip it if the current week coincides with our month end processing which will also execute a report subscription for the same report. Can you provide a solution that we can use to accomplish this?

Creating a Azure Cosmos DB Account

by Deepak Prasad Sahu

SQLServerCentral

Azure Cosmos DB

Learn how to get started with a CosmosDB account.

The Challenge of Chat

by Steve Jones

SQLServerCentral

Communication

Today Steve talks about the distractions of chat applications at work.

Six reasons to version control your database

by Additional Articles

Redgate

For most application developers, it’s unthinkable to work without version control. So why is the database any different? This blog lays out 6 clear benefits to applying version control best practice to your database alongside your application.

Bad Managers

by Kathi Kellenberger

SQLServerCentral

Database Weekly

I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]

Bones of SQL - Practical Calendar Queries

by Bob Hovious

SQLServerCentral.com

T-SQL

After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.

Forum FAQ

by Steve Jones

SQLServerCentral

SQL Server Central

With the implementation of the BBPress forums at SQLServerCentral, a few community members have asked how the forums work and how to best use them. This document will address a few of the items that have been asked by users. A list of questions is followed by the answers below. If you have additional questions […]

Taking Quarantine Holiday

by Steve Jones

SQLServerCentral

Career Growth

What will you do about vacation during the pandemic? Steve gives his thoughts.

How SQL Clone and SQL Change Automation enable seamless Database Branch Switching

by Additional Articles

Redgate

Learn how to use SQL Clone together with Git hooks and SQL Change Automation to branch your database in Git as quickly and simply as your code.

Why Ordering Isn’t Guaranteed Without an ORDER BY

by Additional Articles

Brent Ozar Blog

If your query doesn’t have an ORDER BY clause, you can’t reliably predict the order of your results over time. Sure, it’s going to look predictable at first, but down the road, as things change – the indexes, the table, the server’s configuration, the size of your data – you can end up with some ugly surprises.

Run SQL Server Agent Job from SSIS

Creating a Azure Cosmos DB Account

The Challenge of Chat

Six reasons to version control your database

Bad Managers

Bones of SQL - Practical Calendar Queries

Forum FAQ

Taking Quarantine Holiday

How SQL Clone and SQL Change Automation enable seamless Database Branch Switching

Why Ordering Isn’t Guaranteed Without an ORDER BY

Blogs

Keeping Redshift System Table History Past 7 Days with S3 Tables

Updating the Data API Builder

T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget

Forums

Practical Ways to Approach SQL Server Problems and Case Studies

Measuring Productivity

Importing Excel files into SQL Server using DuckDB and Python

Question of the Day

Tracking All the Queries