Azure SQL

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 (6)

2019-11-04

4,894 reads

Configuring Azure SQL Databases Using Azure Resource Manager Templates

  • Article

Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you explore an example of this approach.

2019-04-09

Blogs

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

DBA Myths: The system sessions are the ones with a session_id 50 or less

By

Anecdotally any session_id that’s 50 or less is going to be a system session...

SQL Undercover TV – Encrypting SQL Backups

By

In this episode, David looks at how we can encrypt our SQL Server backup...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Is it possible get from Query Store historical ~ CPU % usage by each query ?

By ebooklub

Is it possible get from Query Store historical ~ CPU % usage by each...

missing storage space

By MVDBA (Mike Vessey)

Hi I have a particular drive on one of my sql servers, it's gotten...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers