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

7,316 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

Rowcount estimates when there are no Statistics

By

When you don't have statistics, what does SQL use to calculate the estimated number...

Synapse Analytics and .NET for Apache Spark Example 4 - JOINS

By

This is a bit of a longer one, a look at how to do...

Recovering Data from a Backup with SQL Data Compare

By

I had a customer recently ask about how to recover data from a backup...

Read the latest Blogs

Forums

Koop paspoorten, rijbewijs (whatsapp: +14153201177) 100% niet-detecteerbare euro

By jamesblaq

GRADE A ++ VERVALINGSGELD TE KOOP EN WIJ PRODUCEREN HOGE KWALITEIT VAN ECHTE EN...

Which is your favorite Pokémon and why?

By Tonyfirst

Yes, my personal favorite is naturally Pikachu. I can hardly resist its cuteness. The...

Accessing a RESTORING database for test refresh

By Pete Bishop

I have a requirement whereby testers on ServerA need a copy of the production...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers