Sqlundercover.com

UNDERCOVER TOOLBOX: Sp_RunningJobs – See all currently …

WebUpdate: 31/7/2017 – We have improved the Stored Procedure, the revised version now includes Days elapsed in addition to Hours, Minutes and Seconds. There are quite a few …

Actived: 2 days ago

URL: https://sqlundercover.com/2017/07/27/undercover-toolbox-sp_runningjobs-see-all-currently-running-sql-agent-jobs/

Creating a SQL Server Test Lab On Your Workstation – Part Three

WebWelcome along to the third part of our series 'Creating a SQL Server Test Lab On Your Workstation'. If you've followed along with the first two parts, you should …

Category: Health Go Health

Creating a SQL Server Test Lab On Your Workstation – Part One

WebOne of the most useful tools to the DBA when we need to test new features, recreate a fault that we've seen in production or just want to see 'what if?' is a test lab. …

Category: Health Go Health

7 ways to Query Always On Availability Groups using SQL

WebAG Dashboard, Always On, Database Administration, dmv, Estimated Data loss, Query Always on, Redo. UNDERCOVER TOOLBOX: …

Category: Health Go Health

T-SQL Tuesday #135 – The Tools That Make My Job …

WebAfter working in the motor trade for over 11 years Adrian decided to give it all up to persue a dream of working in I.T. Adrian has over 5 years of experience working …

Category: Health Go Health

7 more ways to Query Always on Availability groups

WebPost Updated: Replaced Query 3 with transactions/sec query.. When we first published 7 ways to Query Always On Availability Groups using SQL we had no idea it …

Category: Health Go Health

Introducing: The SQLUndercover Inspector – SQL Undercover

WebADHocDatabaseCreations – Checks for any databases that have been created in the last 7 days which include numerics in the database name or keywords …

Category: Health Go Health