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. sp_help_revlogin is now old enough to drive a car By now in your career, you may have needed to migrate a few databases and …

I always forget how to do this, and Aleksandar Nikolić posted a really beautiful answer on Powershell.com For a file: 1-split (Get-Content .\test.txt | Out-String) | 2Where-Object { $_ -eq "test" } | Measure-Object | 3Select-Object -exp count For a string: 1$html.content -split …

Earlier this week, I was trying to determine people's feelings about Microsoft Connect by looking through Twitter. A few scrolls down, and I came upon this @Ms_Alaina My problem is I sometimes stumble upon a Connect item I filed in 2008, and have no idea when it was closed as fixed. — Aaron Bertrand (@AaronBertrand) …

The other week, I was introduced to Trello for the first time by this tweet and I fell in love. In case you missed it, here’s my Trello of upcoming “How Stack Overflow does X” blog posts, please vote or suggest! https://t.co/6E8JRb4RSu — Nick Craver (@Nick_Craver) February 1, 2016 Basically, Nick uses Trello to gauge …

Recently, I wrote about Joining Ubuntu to an Active Directory Domain. That was for an actual Ubuntu box and the plan was that the next post would be about adding Apache to the mix. But then I got distracted by Apache on Bash on Ubuntu on Windows (check out my gists for sneak peaks). I should be practicing for my …

Back in 2009, I did a whole lot of messing around with Linux and Active Directory integration, primarily for Apache. Now that Linux is coming to Windows, I figured I'd brush up on my Linux and Windows Integrated Authentication skills to work with Ubuntu, too. Clients and Servers Since 2009, it seems that a couple …

In my previous blog post "Can We Get These 3 SQLPS Issues Fixed before SQL Server 2016 RTMs?", Aaron Nelson and I asked the SQL and PowerShell community to help upvote 3 SQL Connect items. The items addressed three problems with SQL Server's PowerShell module, SQLPS. It took 3-5 seconds to load It changed the …

In tonight's PowerScripting Podcast, I shared a few things about SQL Server on Linux, and talked a bit about SQLPS. All after a lengthy intro about my tech life and Cajun culture ;) You can watch the whole thing, skip to 28 minutes to the podcast intro, or skip to around 59 minutes for the SQL/Linux/SQLPS portion. Or …

Back in 2013, I wrote about "Using Windows Authentication to Connect to SQL Server from Linux". Considering how convoluted using Linux can get, doing so was surprisingly straightforward then and it's even easier now. Want to see a webcast about this topic? Aaron Nelson and I recorded a session for the SQL …

YES WE CAN! Microsoft responded and fixed these 3 major issues in SQL Server Management Studio March 2016 Refresh. Read more at "WE DID IT! Microsoft Fixed Those 3 SQLPS Issues in SQL Server 2016". I'll be honest, I don't use the SQLPS module even though I'm the perfect candidate. I've been a SQL Server DBA …