SQL Powershell

Technical Article

Post SQL Server Installation steps with PowerShell

  • Script

I bet, each DBA would change some settings after the SQL Server installation as per their company standard . I wrote this PowerShell script for one of my client who has below standards: Port should be 1433, static Disable SQL telemetry* & SQLWriter services Change recovery model to FUll for all databases except tempdb and […]

5 (2)

You rated this post out of 5. Change rating

2020-07-02 (first published: )

2,290 reads

Technical Article

Output multiple datasets from one INVOKE-SQLCMD command

  • Script

A common question that I've seen online is how do I return multiple sql datasets from a single query using INVOKE-SQLCMD. Most of the answers out there say it is not possible, but it is in fact possible by using the OutputAs dataset parameter. This parameter outputs a dataset that has all of the information […]

You rated this post out of 5. Change rating

2020-04-24 (first published: )

4,789 reads

Blogs

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks

By

I’ve been using Azure SQL Database for quite some while and have set up...

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

Read the latest Blogs

Forums

Build a Better WordPress Archives Page Using MySQL

By Site Owners

Comments posted to this topic are about the item Build a Better WordPress Archives...

Max Managed Instance CPUs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Max Managed Instance CPUs

Analyze Data with a Serverless SQL pool in Azure Synapse Analytics

By arindamxs

Comments posted to this topic are about the item Analyze Data with a Serverless...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers