2022-02-14
3,785 reads
PowerShell
Install SQL Server and Oracle using PowerShell and Windows Containers
In this article we look at how to install SQL Server and Oracle using PowerShell to create development environments using Windows Containers.
2022-01-28
Working with PowerShell strings
Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.
2021-12-20
Scripting with Flyway Teams and PowerShell
During the development cycle, the mechanics of reliable delivery must not be allowed to dominate the design work. With script callbacks in Flyway Teams, many of the development tasks required during a database migration can happen automatically, producing reports, build scripts, code reviews, or documentation.
2021-11-05
dbatools - new functions for Database Mail
Background The dbatools module is broadly used and is an ever-growing set of useful commands. While looking for some inspiration I checked the old issues logged on the GitHub repository. Finally, I found this one Remove-DbaDbMail Profile and Account · Issue #4990 · sqlcollaborative/dbatools (github.com). The issue was more than 2.5 years old (32 months). […]
2021-11-01
3,176 reads
Building an ETL with PowerShell
There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.
2021-10-11
Disable or Enable All SQL Server Agent Jobs
In this article we look at a PowerShell script that you can use to centrally enable and disable any SQL Server Agent Job on any instance of SQL Server.
2021-09-08
Peering into and Parsing Application Log Files
How to use PowerShell cmdlets, such as Select-String, to glance at the contents of the application logs, or use them in conjunction with Regular Expressions to sift through log files in detail looking for particular types of error.
2021-07-23
Managing SQL Snippet Collections using JSON and PowerShell
Maintain your favorite SQL snippets and queries centrally, using PowerShell to save and update each snippet collection, in JSON, and then converting them into SQL code snippets for SQL Prompt.
2021-06-16
Implement Azure SQL Elastic Jobs with PowerShell
In this article, I will work you through the process of creating elastic jobs in Azure using PowerShell. The elastic jobs are similar to regular agents jobs in SQL Server although they add extra functionality like for example dedicated target groups that can be used in the job step level. Currently, the elastic jobs are […]
2021-06-21 (first published: 2021-05-03)
1,484 reads
Blogs
Storytelling with Data – Enertia User Conference 2022
By DataOnWheels
Thank you to everyone who attended my session at the Enertia User Conference in...
Daily Coping 30 Sep 2022
By Steve Jones
Today’s coping tip is to find a new way to use one of your...
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP....
Forums
How Important is Software?
Comments posted to this topic are about the item How Important is Software?
How and where did you learn SQL from?
Could you give me advice on where I should learn SQL and Python to...
Save Query Results to Excel and Automatically run it
Hello, I have a very simple query Select * from Employees where company...
Ask SSC