Encrypt and Decrypt Passwords in SQL Server with PowerShell
In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.
2021-03-17
In this article we look at how to securely store data in text files that could be used for SQL Server authentication or wherever you need to keep data secure.
2021-03-17
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.
2021-03-03
Phil Factor explains how to get started with Flyway, as simply as possible, using PowerShell. This article provides a practice set of database automation scripts that will build a SQL Server database, and then update it, running a series of migrations scripts that make some schema alterations, and load the database with test data.
2021-02-12
SQL Compare and SQL Data Compare can be used together, from the command line, to provide a complete build process, or to script out changes to both the database and its development data. For doing this routinely, I find it easiest to script the operation using PowerShell.
2021-01-15
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]
2020-12-31
4,077 reads
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-16
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-10
Learn how to manage Power BI datasets with PowerShell with examples to give Developers and DBAs the flexibility have real time data stored in the Power BI service for reporting.
2020-11-30
In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment.
2020-11-26
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
By Steve Jones
Recently I was trying to use a connection string to connect in SSMS. There...
Greetings all. It's been a very long time, but I'm back. Does anyone have...
Has anybody had any experience with Nagios as a SQLServer monitoring tool. What were...
I have an Azure Data Studio question (or maybe it's a GitHub question, I'm...
How do I disable all the indexes on the dbo.Logger table?
See possible answers