A common administrative task that you need to deal with when managing an Always On Availability Group solution is to recreate SQL Server logins on all replicas. That’s just a fact. Because at any given point in time, an automatic failover can happen and move the Availability group to a different replica. If you don’t […]
PostCheck the last backup date in SQL Server using Windows PowerShell
This article highlights how to use Windows PowerShell to retrieve database properties using SMO. Notice how easy it is to check the database properties using pretty common syntax One of the challenges I have when I was starting out as a SQL Server DBA was to check for the last backup date for a database. […]