It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details
2018-04-11 (first published: 2018-03-29)
769 reads
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,492 reads
It will help to development team to find their developed & DB server status check.
2018-03-28 (first published: 2018-03-22)
2,635 reads
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,320 reads
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
223 reads
2018-03-19 (first published: 2018-03-15)
466 reads
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
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,166 reads
2018-02-28 (first published: 2018-01-10)
3,119 reads
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)
587 reads
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Comments posted to this topic are about the item SQL Server Automated Backup &...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers