Today, I received a request to find the manager for a whole bunch of users. This was a list of names (not UserId's) in a Excel worksheet. It is not actually that complex to do it Locate the AD user based on the name Check the Manager property Lookup AD again for Manager to get … Continue reading PowerShell & Active Directory: Quickly Find The Manager For A Bunch Of Users
SQL Server: Move Database Files To Another Drive/Folder Like A Pro!
Last week, I wrote a post on how to relocate Oracle data files from one drive to another. Today, let us see how simple it is to do the same in SQL Server. I recently had to move 125 databases on an instance to a new and expanded volume mountpoint to allow for growth, which … Continue reading SQL Server: Move Database Files To Another Drive/Folder Like A Pro!
Oracle – Compare Text Files With 10 Million Lines In 10 Minutes Using 10 Lines Of Code – EXTERNAL Tables
The goal of this post is to compare two text files that may have millions of lines and compare them to quickly find out which lines differ using Oracle EXTERNAL tables. As an Oracle professional, “external tables” are something you may already be familiar with or maybe you have heard about them but not used … Continue reading Oracle – Compare Text Files With 10 Million Lines In 10 Minutes Using 10 Lines Of Code – EXTERNAL Tables
Merging CSV Files Fast Using DOS COPY Command (or any type of file)
Why not PowerShell? PowerShell might be the new and recommended way to do everything in the Windows command-line (and I am a hard-core PowerShell fan) but this is so easy and handy that it will probably even work in Windows 3.11 (Windows for workgroups)! Besides, I doubt that any current method in PowerShell is as … Continue reading Merging CSV Files Fast Using DOS COPY Command (or any type of file)