I’ve been on a bit of a hiatus with the move to California and figuring out my new life here. I needed some inline TSQL…
Expeditions in Computer Automation - PowerShell, SQL Server, and more.
SQL Notes Posts
Today Thomas Rayner’s post on Get-History reminded me of a one liner I use to calculate time spent on the last command.
|
1 |
(Get-History)[-1].EndExecutionTime - (Get-History)[-1].StartExecutionTime |
|
1 2 3 4 5 6 7 8 9 10 11 |
Days : 0 Hours : 0 Minutes : 0 Seconds : 0 Milliseconds : 87 Ticks : 870022 TotalDays : 1.00696990740741E-06 TotalHours : 2.41672777777778E-05 TotalMinutes : 0.00145003666666667 TotalSeconds : 0.0870022 TotalMilliseconds : 87.0022 |
You…
I wanted to bring you a quote from #SQLSaturday channel in the SQL Community Slack that I found amazing: “They [the PASS board] are already signaling they don’t…
@brianszadek says: I am looking to automate the scripting of objects with PowerShell for easier source control integration. I thought this would be a little…
One of the features of both Visual Studio Code and the PowerShell Integrated Scripting Environment is allowing you to run a line of code with…
Table Of Contents Initial Idea Clarifying Our Requirements The Code Special Thanks Initial Idea Let”s generate a table of contents for a Github flavored…
As a part of the T-SQL Tuesday run by Rob Sewell this month, I wanted to throw in a little post about using Test-DbaLastBackup which I…
Had some fun talking to the fine people at the PDAVP and wanted to post some links. The video: Introduction to dbatools Their awesome virtual…
I was going to dive into a little less meaty topics to start my PowerShell series but I have had a couple requests for debugging…
I am going to kick off a series of blog posts that I hope will help you understand the usefulness and power of PowerShell (or…