A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

 As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...

Remotely Copy Files To Multiple Destinations Using PowerShell

Remotely Copy Files To Multiple Destinations Using PowerShell

Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...

Remotely Copy Files To Multiple Destinations Using PowerShell

Remotely Copy Files To Multiple Destinations Using PowerShell

Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...

A high level view of the most costly queries by CPU

A high level view of the most costly queries by CPU

I want to see at a high level i.e at batch or stored procedure level, not at the individual...

Wait a minute, CLUSTERED COLUMNSTORE indexes are not ordered?

Just to reiterate what's in the title of this post, what I mean is that the CLUSTERED COLUMNSTORE indexes are not ordered, while NONCLUSTERED COLUMNSTORE created indexes are on...

Tracking the Inaccurate Cardinality Estimates

Tracking the Inaccurate Cardinality Estimates

When it comes to query performance, lately the Cardinality Estimates seems to have been a hot topic with each new release  of SQL...

Reading and searching events inside the SQL Server default trace

Note: SQL Trace and SQL Server Profiler are deprecated and will be removed in a future version of Microsoft SQL Server. The replacement technology for them is Extended Events. To Learn More: https://learn.microsoft.com/en-us/sql/relational-databases/sql-trace/sql-trace?view=sql-server-ver16SQL Server...

A Barebone Script To Generate SQL Script to Create Synonyms

A Barebone Script To Generate SQL Script to Create Synonyms

This stored procedure can be used to generate a SQL script to create synonyms for all tables in...

Generate SQL Script to Allow or Disallow Access To All Data

I had a requirement to temporarily prevent access, read or write, to a particular database for all users except 2 users. There were hundreds of SQL Logins with access...

Query the fully qualified connection string for the AlwaysOn Connection

While we do maintain an exact inventory of sql servers and their configuration, its too numerous and I often find myself in a need to look up AG connection...