Azure SQL

SQLServerCentral Article

Implement Azure SQL Elastic Jobs with PowerShell

  • Article

In this article, I will work you through the process of creating elastic jobs in Azure using PowerShell. The elastic jobs are similar to regular agents jobs in SQL Server although they add extra functionality like for example dedicated target groups that can be used in the job step level. Currently, the elastic jobs are […]

5 (2)

2021-06-21 (first published: )

1,629 reads

SQLServerCentral Article

How to filter non-existing records in SQL

  • Article

Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]

4.22 (9)

2021-11-26 (first published: )

13,125 reads

Blogs

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Calculate log space required on principle for maintenance activity

By ramana3327

Hi all, We have a database configured for asynchronous mirroring. We have some planned...

Get a Date Time Stamp of table when another columns value changes.

By lalitprg2017

I am having Below Table i want to get Result as shown in the...

how to write a query by using some filter patterns in SQL Server?

By maifs

what I want is to apply some filter patterns to search the data. For...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers