Update: This method is faster but some anti-virus software hate it. I've since reverted our method of import to an all-in-one ps1 👎 Considering dbatools now has over 500 commands, we are always eager to keep an eye on the speed of our import process. As outlined in the blog post decreasing module import times, we've …

Recently, I had a couple colleagues tell me that their PowerShell code sucks. One of them is a beginner who manages a large SharePoint farm and the other is more advanced and wrote a few commands that saves me hours of work each week. See the disconnect there? Their PowerShell code, which helps manage Enterprise …

Yesterday, I presented at PSPowerHour and during my intro, my iPad's volume turned up so I got distracted when talking about something that really meant a lot to me. And I'm a bit bummed that I wasn't able to properly convey how much it meant that I was awarded as a PowerShell Community Hero earlier this year. I was …

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 and YouTube star Bert Wagner (blog | bluesky), is all about the SQL Server …

I was first introduced to open-source on IRC back in 1996. I joined the #toriamos channel on undernet, which was managed by an eggdrop bot named [iCKy]. [iCKy] was an open-source TCL and C-based program that did cool stuff for us, like auto-ban users if they were flooding the channel. There was even a party line that …

Well, if it wasn't my very first, it is close enough. Back in 1997, I was taking a computer class at a non-progressive college in Northwest Louisiana. Most of the tech classes still teaching Fortran and the faculty pushed back hard when I asked if we could work with more modern technology. I was disappointed with my …

Although 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 …

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

This 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 …

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 …