Twilight Timezone: Date and Time Architecture in your Applications aka Use DateTimeOffset, Your Future Self Thanks You
Thanks to everyone at a joint meeting of the Baton Rouge .NET and SQL Server User Groups who joined my...
2017-09-14
445 reads
Azure SQL Database Resumable Online Index Rebuild
If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...
2017-09-14
1,373 reads
Help! My query is too fast!
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...
2017-09-20 (first published: 2017-09-14)
3,255 reads
Microsoft Azure – How to check the available extensions for a virtual machine using Windows PowerShell
Hello friends, Please find the link of my new article – https://social.technet.microsoft.com/wiki/contents/articles/40102.microsoft-azure-how-to-check-the-available-extensions-for-a-virtual-machine-using-powershell.aspx
2017-09-14
604 reads
[PowerShell] From 20 minutes to 20 seconds - Change domain user password on multiple domains without login into each one
I’m working on a environment where I have to deal with multiple domains. The user’s password needs to be updated each 40/45 days (it depends on the domain).
Because I...
2017-09-14
16 reads
A trillion and one
Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in...
2017-09-13
453 reads
Data Governance Survey–Still Time
Just a reminder. Redgate is doing research into data governance, and we have a small survey we’d love to get...
2017-09-13
866 reads
Speaking at IT/DevConnections 2017
If you’re going to be in the San Francisco area in October, let’s get together and talk. I’ll be at...
2017-09-13
347 reads
What does this little check box do?
Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get...
2017-09-13
353 reads
Expensive Enterprise Backup Tools – A survival guide
If you’re working for a big company, chances are that your IT already has a strategy and tools for dealing...
2017-09-13
988 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers