DB Blocking Automated E-mail Alerting with Blocker SP ID & query's
It will Help DBA to monitor the instant blocking and can take the action immediately on blocker query and users.
2018-04-05 (first published: 2018-03-22)
1,491 reads
Scripts
Grant Sp_who2, & who3 proc execution without granting sysadmin access
It will help to development team to find their developed & DB server status check.
2018-03-28 (first published: 2018-03-22)
2,634 reads
Change the server name of the SQL Server Instance
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,320 reads
Statistics Outdated
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
222 reads
2018-03-19 (first published: 2018-03-15)
466 reads
SQL Battleship
It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!
2018-03-12 (first published: 2014-04-25)
8,498 reads
Unused Indexes in your databases
This Script allows you to determine the list of unused indexes in your databases.
For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude
2018-03-06 (first published: 2011-02-10)
6,165 reads
2018-02-28 (first published: 2018-01-10)
3,119 reads
Custom Replication Status Record Latency Monitor
Monitors replicated tables for any publisher/subscriber for latency in record counts, alerts via email if latency exists beyond a specified threshold
2018-02-27 (first published: 2015-01-23)
586 reads
2018-02-23 (first published: 2018-02-19)
192 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I