SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!


Azure chaos STUDIO


Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors


I am proud to announce the launch of a new book, centered around the...

Identify the (Top 20) most expensive queries across your SQL Server using Query Store


Script to identify the most expensive queries on your database server using the Query...

Read the latest Blogs


Help with BCP in SQL 2022

By tommiwan

We have a stored procedure that calls xp_cmdshell in order to use the BCP...

PREEMPTIVE_COM_GETDATA when using DISTINCT in remote query.

By toolman21

Replacing an old server with a newer one.  A job that runs fine on...

Job schedules

By bobrooney.81

Hi All, Assume that I have SQL Server Agent Job name:"TestJob". I am on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers