Recently, I ran into an issue after applying a few security updates and subsequent reboots: a number of the SQL services did not start successfully. After running the following script, I've had success with SQL services starting as expected after reboot. It's basically a built-in service start retry. You can read more …
Read MoreWhen performing file migrations, PowerShell's Copy-Item is not ideal. I've since forgotten the original reasons I concluded this with the rest of the Internet, but this quote from reddit covers it pretty well. The Copy-Item and Move-Item cmdlets are general purpose commands. They have the ability to handle many …
Read MoreToday's blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. This month’s T-SQL Tuesday, hosted by my buddy and YouTube star Bert Wagner (blog | bluesky), is all about the SQL Server …
Read MoreAlthough I've been using SSMS 2017 on my demo machine for a while, I kept SSMS 2016 on my primary workstation until today. I've been unsure of the new look of SSMS 2017, but now that I've fallen in love with the way it handles XEvents, I decided to make the switch. Whaatup! That's super handy. Unfortunately, you can't …
Read MoreToday's blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. This month’s T-SQL Tuesday, hosted by my buddy Jens Vestergaard (blog), is all about the SQL Server tools I use and love. …
Read MoreThis month Andy Leonard (b) wants to know why we do what we do. Matthew Broderick When I was a kid, I watched War Games and Ferris Bueller's Day Off, and immediately wanted to hack. I actually got in trouble for calling Sarah McLachlan's record label's BBS to try to hack. I had no idea it was a Canadian number! They …
Read MoreToday's blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. This month’s T-SQL Tuesday, hosted by Ewald Cress (blog), is all about people who have made a difference in our careers. I'm …
Read MoreSSPI handshake failed with error code 0x80090311, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. No authority could be contacted for authentication. Login failed. The login …
Read MoreRecently, PASS announced their first round of speakers for Summit 2017 speakers and I'm on the list! I'm particularly excited because Summit is the largest SQL Server event in the world and it's looking like PowerShell will be getting some great exposure this year. In addition to announcing that I'll be speaking, PASS …
Read MoreRecently, I was approached by supa-famous Joey Aiello of the PowerShell team at my favorite conference ever, PSConf.eu. So Joey comes up and says "Chrissy, Aaron Nelson has pretty much required me to talk to you. The SQL Community has the #1 PowerShell UserVoice request. We see that - we've heard you, The People …
Read More