DECLARE @agname SYSNAME, @listnername VARCHAR(128), @primaryserver VARCHAR(128), @agserverlist VARCHAR(MAX), @agdblist VARCHAR(MAX); INNER JOIN master.sys.availability_replicas Replicas ON ...
Most development is maintaining and enhancing existing systems. Often times these systems do not have a way to recreate the database structure, but we need these structures to setup local development, ...
Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...
This post was authored by Ayo Olubeko, Program Manager, Data Developer Group. The July update for SSMS includes the first substantial improvement in SQL PowerShell in many years. We owe a lot of ...
Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...
In an effort to provide an extra level of convenience, we are releasing two features that will simplify the effort to ensure the health of your SQL Virtual Machine and your data. These features, ...
In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...
Book Abstract: If you work with SQL Server, dbatools is a lifesaver. This book will show you how to use this free and open source PowerShell module to automate just about every SQL server task you can ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback