Backups are a very important part of a DBA's job. Understanding when they have happened and when they have not happened is even more important. Quantifying things quickly can mean the difference between good and bad decisions when you are in a bind. Note: If you are looking to do something similar with Oracle, please … Continue reading SQL Server: Visualize Your Backups For Insights – By Month Day, Time etc.
Today, a need came-up where a bunch of stored procedures had to be altered based on certain criteria. Easy way: Obviously, the easiest way would be to script out the stored procedures to a file/editor and do Find/Replace with the UI dialog. However, this does not work if there are lots of stored procedures and … Continue reading PowerShell: Find & Replace SQL Server Stored Procedure Code En Masse Based On Custom Criteria
Be sure to read the related blog post first before proceeding! PowerShell: Lookup Active Directory Accounts Flexibly/Exhaustively For A List Of First/Middle/Last Names If you are an AD admin, you are very likely a pro at managing AD group membership but for mere mortals, this can be a tedious task. Please read on to find out … Continue reading PowerShell: Add, Remove, Copy And Move Users To Another AD Group Conditionally
What are Schemas for? All of you are familiar with the default and built-in schema "dbo". When you create an object without a schema, "dbo" becomes the schema for the object. Generally, it is NOT considered a good practice from a manageability or security perspective to have everything owned by "dbo". The alternative is to … Continue reading SQL Server: Time To Switch Schema Of All Objects Away From “dbo”
Cloning is perhaps not the right term to use here but let us pretend that it is and keep going. Let us say that you want to install SQL Server on another host say NewHost but you want it to have the same settings as another host/instance on say ModelHost. In fact, let us say … Continue reading Clone A SQL Server Software Installation