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,650 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: )

7,268 reads

Blogs

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

KDA: Echoes of Deception - Onboarding

By

I’ll walk through the KDA UI and tackle the first challenge before diving into...

Kusto Detective Agency - Intro

By

While I mostly write about SQL Server, I have a soft spot for Kusto....

Read the latest Blogs

Forums

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

officialsprinklezshop.com/Buy Sprinklez Cotton Candy Vanilla Swirl Strain

By favouritechemist

Website: https://officialsprinklezshop.com/ Buy Best quality Sprinklez Strain from Officail Sprinklez Shop Sprinklez Cotton Candy...

https://officialsprinklezshop.com/ Sprinklez Super Sweet Sugar Sparks Strain

By favouritechemist

Website: ttps://officialsprinklezshop.com/ Buy Top Notch quality product from Official Sprinklez Shop. 100% Trusted -...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers