Microsoft SQL Server

Technical Article

5 (6)

2022-02-22 (first published: )

6,079 reads

SQLServerCentral Article

Running SQL Server on Oracle and Google Cloud

  • Article

In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.

4.2 (5)

2022-02-18

5,670 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,127 reads

Technical Article

Generic trigger for maintaining the Audit Log

  • Script

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

2.33 (3)

2019-10-15 (first published: )

1,916 reads

Blogs

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Typing with Your Tongue Part 2: Voice Access

By

A few months ago, I wrote a post on how I use voice technology...

Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up

By

William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...

Read the latest Blogs

Forums

creating a copy of database with an ndf file

By mjohnson 71479

I need to send a copy of this to our customer but do not...

Checkpoint issues in SQL Server 2022

By Al_22

Hello All Recently we upgraded our production MSSQL Server from 2019 to 2022 and...

SQL Managed Instance - Changing (Upgrading) the Hardware

By DanielP

Hello, Has anyone changed their Hardware generation?  We are looking at going from 'Standard-series'...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers