Arun Yadav

16+ years of experience in managing, Infrastructure technology operations, Cloud operations, IT service delivery, IT Infrastructure management, Oracle engineered systems, MSSQL Server.
  • Interests: MSSQL Server, Oracle, Sybase, Azure, Oracle Cloud, Google Cloud, T-SQL, AWS, Ansible, Automation, Exadata, EBS
  • Skills: MSSQL Server, Oracle, Sybase, Azure, Oracle Cloud, Google Cloud, T-SQL, Ansible, Exadata, EBS, Jenkins

All authors

Technical Article

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,853 reads

SQLServerCentral Article

Running SQL Server on Oracle and Google Cloud

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2022-02-18

7,253 reads

All authors

Blogs

Automatic Index Compaction

By

Index maintenance has always meant nightly jobs and a window you have to defend....

The Goldilocks problem – Materialized Views

By

I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...

Monday Monitor Tips: Virtual Machine Usage and Cost

By

One of the things I’ve been requesting for a number of years is cost...

Read the latest Blogs

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

By Terry Jago

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

Alamat Kontak Resmi BCA KCP Kertajaya ??/Wa 08218154393

By layanan 24jam BCA

WA:08218154393 Jl. Kertajaya No.35, Airlangga, Kec. Gubeng, Surabaya, Jawa Timur 60281

How We Handled a Vendor Retry That Loaded Twice in Snowflake

By Chandan Shukla

Comments posted to this topic are about the item How We Handled a Vendor...

Visit the forum

Question of the Day

Getting the Average

I have this data in the dbo.Commission table in a SQL Server 2022 database. 

salesperson commission
Brian       12
Brian       16
Andy        7
Andy        14
Andy        21
Steve       20
Steve       NULL
All the data is a varchar, and I decide to run this query to get the totals for each salesperson. 
SELECT SalesPerson
     , AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
 FROM commission
 GROUP BY SalesPerson
GO
What average commission is calculated for Steve?

See possible answers