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
PowerShell
PowerShell editors and environments: Part 1
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.
2021-03-03
Getting Started with Flyway and SQL Server
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
Using SQL Compare and SQL Data Compare within a PowerShell Cmdlet
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
Import Excel Data into SQL Server with PowerShell
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
PowerShell Day By Day: The Pipeline
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 […]
2025-12-26 (first published: 2020-12-31)
6,544 reads
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-16
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-10
Manage Power BI Dataset with PowerShell
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
Monitoring SQL Server Instance Version and Builds with PowerShell
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
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers