Microsoft SQL Server

Technical Article

5 (6)

2022-02-22 (first published: )

5,555 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

4,906 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.13 (8)

2021-11-26 (first published: )

12,866 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,527 reads

Blogs

Restore HEADERONLY and FILELISTONLY

By

Good day reader.  This post is coming to you from a busy week in...

DevOps From Redgate

By

In a few weeks at the PASS Data Community Summit, I’ll be joining several...

Daily Coping 4 Oct

By

Today’s coping tip is to free up time by canceling any unnecessary plans. I....

Read the latest Blogs

Forums

Bệnh thủy đậu: Nguyên nhân, triệu chứng, biến chứng và cách điều trị

By laciannette

Bệnh thủy đậu là bệnh lành tính, không có triệu chứng nặng nề ngoài...

Where to Buy Sugilite Gemstone for Spiritual healing powers

By bslmgold

Sugilite Gemstone Bertoua Savanna Local Miners (BSLMgold), Sugilite is one of the major love...

How to buy diseased free Ox/Cow Cattle Gallstone

By bslmgold

Bertoua Savanna Local Miners (BSLMgold) After extracting the gallstones from the cattle's intestines they...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers