Tag Archives: powershell

Using T-SQL over PoSh

Why would you use SSMS/T-SQL over PowerShell (PoSh)? When is T-SQL directly a better option than PoSh? That’s a question I ask myself regularly as I see articles and blogs that discuss how to accomplish a particular task using one … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Republish: The (Former) Complexity of PowerShell

I’m at SQL Bits today, teaching a pre-con with Grant, so I’m republishing The (Former) Complexity of PowerShell

Posted in Editorial | Tagged | Leave a comment

Getting a Day Difference in PowerShell–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. SSMS froze on me the other day. Actually, it lightly responded to some things, but the window wouldn’t redraw … Continue reading

Posted in Blog | Tagged , , | Comments Off on Getting a Day Difference in PowerShell–#SQLNewBlogger

A Little Current Date Arithmetic in Powershell–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a fun post on Twitter recently asking days until retirement. I wrote this code: DECLARE @YearsToRetire INT … Continue reading

Posted in Blog | Tagged , , | 1 Comment