#powershell

FOLLOW ME:

RECENT POSTS:

Forgot my SA password, and I don't have sysadmin rights...

Page Splits, should I worry?

Capture Query Information with Extended Events

DBCC CheckDB on a large Database

New TempDB TraceFlag

WHO AM I ?

My name is Aamir Syed and I run SQLEvo. I optimize the speed, efficiency, and stability of SQL Server. When not working I like to lift weights, play music, and travel with my wife.

Use DBATools Powershell module for Migrations

Happy Thanksgiving! If you're not familiar with DBAtools.io I suggest you head over to the site and see what you're missing. The amount...

Powershell: Create Azure SQL Database

While Azure's web portal is quite sophisticated and streamlined, nothing beats the efficiency of powershell. Building off of my...

Powershell: Stop SQL Server Cluster Resource

We could use this sign when we have approved downtime for upgrades. So this isn't exactly just for SQL, this cmdlet can be used stop and...

Powershell: Failover a SQL Service in a Failover Cluster

Is this where clusters go when they die? A great way to test failover or to simply move disable a clustered SQL Service is to utilize...

Cloud Series: Intro to Azure SQL

If only I could upload my brain to the cloud. BaaS anyone? What is Database as a Service (DaaS)? Azure SQL Database is Microsoft's...