Today on 24HOP: Writing PowerShell with VS Code
For those of you still using PowerShell ISE, I know the news about Microsoft no longer actively developing the ISE was sad. The good news is that it’s been replaced …
stuck on older versions of sql server? check out our trace commands.
If you’re still using super old versions of SQL Server and don’t have access to awesome XEvents, we’ve got some commands to help simplify trace management. Before I begin Just …
PowerShell Precon at PASS Summit 2018
Congrats to our teammate Rob Sewell! Rob was invited by PASS to present about PowerShell at PASS Summit 2018 on Tuesday, November 6 2018. In his day-long session, Rob will …
decreasing module import times
SQL Server Operations Studio by Microsoft is like SSMS for ops, all open source and published on GitHub! They recently updated their wiki’s Performance page, addressing why SQL Operations Studio …
three ways to track logins using dbatools
Years ago, I wrote Watch-DbaDbLogin which keeps an inventory of accounts, hosts and programs that log into a SQL Server. It was pretty crude, but helped immensely during my migration, …
Minimal-downtime migrations using Invoke-DbaLogShipping
Last week I performed a server migration from SQL Server 2014 to SQL Server 2016 using dbatools. A lot of work is done up front to prepare and plan for …
Rob Sewell talks about dbatools on RunAs Radio
Back around the time we did SQL Bits, Rob Sewell spoke to Richard Campbell at RunAs Radio. The show, Managing SQL Server using dbatools with Rob Sewell, is a fun …
happy belated world backup day
Happy Belated World Backup Day! I wish it was Backup and Restore Day, Test Your Backups Day, or World Recoverability Day, but alas. I’m currently working on my portion of …
a new command to find all of your sql instances
Nearly every time I inherit a SQL Server environment, I’m only given a partial list of SQL Servers that exist on the network. It’s my usual routine to get permission …
migrating application databases with dbatools
I’ve been working on a project this year to upgrade SQL Server versions for around 80 application databases, with most of the upgrades requiring both SQL Server and Windows Server …