Today'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 | twitter), is all about the SQL Server tools I use and …

This month Andy Leonard (b/t) 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 …

I've been seeing quite a bit of posts about speaking mentorships and I wanted to share a few speaking tips I recently gave to my buddy Garry Bargsley who will be speaking about dbatools at SQL Saturday Phoenix 2018. The first time I ever spoke in front of a live audience was in Antwerp, Belgium for SQL Server Days …

NOTE: If you're not yet using Windows 10 Fall Creators Update, please follow this article instead. The recent OS X High Sierra iamroot vulnerability reminded me just how many people don't secure their remote desktop connections. While Windows Remote Desktop is more secure than VNC, neither RDP, ADP nor VNC should be …

NOTE: If you're using Windows 10 Fall Creators Update, please follow this article instead. The recent OS X High Sierra iamroot vulnerability reminded me just how many people don't secure their remote desktop connections. While Windows Remote Desktop is more secure than VNC, neither RDP, ADP nor VNC should be directly …

Today'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 | twitter), is all about people who have made a difference in our …

SSPI 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 is …

Recently, 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 …

Recently, 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 …

If you've used Out-File, Set-Content or Add-Content to create a SQL file, you may notice that SQL Server Management Studio complains about normalizing the line breaks. If you see this, simply using -Encoding UTF8 for your output instead of ASCII, the default, will solve the problem.