Learn how to analysis products that might be sold together using R and SQL Server.

Run SQL Server Agent Job from SSIS

by Additional Articles

MSSQLTips.com

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

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 […]