Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Edward Pochinski

SQLServerCentral.com profile

   Items 1 to 17 of 17   
 

Check if xp_cmdshell is turned on and flip the bit

The code works well for an automation process that needs to have xp_cmdhsell turned on.  Read more...
By Edward Pochinski 2017/02/22 | Source: SQLServerCentral.com | Category: xp_cmdshell
Rating: (not yet rated) |  Discuss |   Briefcase | 255 reads

TDE Decryption Timer Script

Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.  Read more...
By Edward Pochinski 2017/01/24 | Source: SQLServerCentral.com | Category: tde
Rating: |  Discuss |   Briefcase | 301 reads

Open Transaction Alarm to Log to the Event log

If you have job that opens a transaction and hangs too long causing a Prod issue this will be a big help to let you know.  Read more...
By Edward Pochinski 2016/04/22 | Source: SQLServerCentral.com | Category: transactions
Rating: |  Discuss |   Briefcase | 561 reads

Transaction Log VLF Alarm

This was used to alert on VLF counts to high due to replication log reader having issue reading the transaction log.  Read more...
By Edward Pochinski 2016/03/17 | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |   Briefcase | 760 reads

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.  Read more...
By Edward Pochinski 2016/02/23 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 926 reads

SQLPS Meets the DMV's

This is a great wrapper for your DMV's to automate a quick performance metric capture.  Read more...
By Edward Pochinski 2016/01/12 | Source: SQLServerCentral.com | Category: dmv
Rating: (not yet rated) |  Discuss |   Briefcase | 327 reads
   Items 1 to 17 of 17