My client had several domains, datacenters and networks. Opening ports across all networks and domains would be a security risk and until these days, every…
This is an advanced version of the script shared last month. Here we could provide a where clause for the parent table to cascade to…
Below script will be handy when you migrate databases via detach-attach methord. The script has to be run at the source instance to generate attach…
There was a requirement to delete data from a lot of tables connected with foreign keys without disabling the constrain or using CASCADE feature. Hence…
I have built a Domain controller (SHERBAZ.COM) on Windows 2012 Datacenter edition evaluation version with DNS role enabled. Also I use a trial version Starwind…
A lot of DBAs including me used sp_depends several times to analyse stored procedures. I felt helpless when I understood, sp_depends is not always dependable.…
If we perform update or delete operation on huge number of rows in a large table at once, there are chances that the SQL Server…
Service monitoring sometimes become inevitable for any server admin. Here is a script to keep watching a windows service for any change in status. The…
Its quite common that when there is some upgrade, change or release in application, there are chances that our database objects get modified. It may…
Being a DBA, it is good to have some kind of automated health check report that gets delivered to inbox with quick glance of DB health.…