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.…
Most important task when you join a new organization or when you start working for a new client is to gain access to all required…
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…