PowerShell: SQL Server Services Startup Mode Change

This is one of those extremely simple posts where everyone who does PowerShell knows how ridiculously simple it is to do and you will too today. You will look like a magician to the uninitiated. Today, I had about 5 hosts running 4 instances of SQL Server each and I had to Stop all SQL … Continue reading PowerShell: SQL Server Services Startup Mode Change

Advertisements

Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log and acting on them to fix the issue(s) when using Oracle on Windows. It should not be much different on Linux. This is a 100 level post. The call: Timeouts Another normal day … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

Oracle – Capture OS Command Output Using Oracle External Tables

Case for the OS side: Some things are best done on the OS side and there is no question about that. Case for the DB side: Some things are best done on the database side and there is no question about that either. What if? Some things need the output of one in the other … Continue reading Oracle – Capture OS Command Output Using Oracle External Tables

Compare AD group membership of two users

Our Windows security setup is completely (well, mostly 🙂 ) AD groups based. When new employees are hired, we ask for an existing employee after whom the new employees permissions should be mirrored. In other words, if we added the new employee to the same AD groups (that are related to SQL Server of course), … Continue reading Compare AD group membership of two users