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

6,153 reads

Blogs

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

By

I recently started full time learning of Amazon Web Services (AWS). I found that...

Read the latest Blogs

Forums

insert duplicate records with new timestamp

By Tara-1044200

how can i insert records from a transaction table into a transaction table with...

Performance benchmarking tools for SQL Server

By MichaelT

Are there any performance test tools that can check the performance of a SQL...

Backing up and Restoring a 3 terabyte database takes over 5 hours

By ericwenger1

I have a 3 terabyte database that is taking over 5 hours to backup...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers