Articles

External Article

Run SQL Server Agent Job from SSIS

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?

2020-05-19

SQLServerCentral Article

Forum FAQ

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-05-15

260 reads

External Article

Why Ordering Isn’t Guaranteed Without an ORDER BY

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.

2020-05-15

External Article

A Hybrid Approach to Database DevOps

A flexible approach to Database DevOps where the team maintain the current state of the database in version control, during development, and then at key stages generate and test the migrations script that will deploy the changes to the target database, safely.

2020-05-14

External Article

How to ACTUALLY save money in the cloud with SQL Server

We have all heard migrating to the cloud can save you money and there are several ways moving your SQL Server workloads to the cloud can save your organization money. But, there are also missteps that can eat away at the savings, performance and even your availability creating instead an expensive, ineffective, difficult to manage cloud infrastructure.

2020-05-14

Blogs

Fabric Mirroring doesn’t start copying Rows

By

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

By

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

By

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Read the latest Blogs

Forums

PostgreSQL String Functions Part 1

By Shivayan Mukherjee

Comments posted to this topic are about the item PostgreSQL String Functions Part 1

Working Better Under Pressure

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Working Better Under Pressure

Identities and Sequences V

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identities and Sequences V

Visit the forum

Question of the Day

Identities and Sequences V

When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?

See possible answers