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

6,069 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

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using Docker Volumes for SQL Server in Linux

By

No, not that kind of volume! Over the past couple of blog posts, I...

Read the latest Blogs

Forums

Pintable into cache

By mtz676

Pintable into cache to avoid fragmentation I have a table(OLTP database) which gets fragmented...

stored procedure to delete user and login

By SZ

I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers