Most database folks might know the tempdb database in SQL Server is used for temporary tables, but many folks don’t realize all the other things that use this critical system database. It’s also used by table variables, cursors, aggregations, joins, and sorts. And by memory spills when you don’t have enough memory. And by integrity … Read more
In this blog post, we will audit the dbatools command Invoke-DbaQuery. I will test, review, and evaluate the script based on a series of identical steps. Our goal is to provide insights, warnings, and recommendations to help you use this script effectively and safely. Invoke-DbaQuery is the Swiss army knife of all dbatools commands as … Read more
“Every time I think of you, I feel shot right through with a bolt of blue…” – If your SQL Servers (and especially your SQL Server Availability Groups and Failover Cluster instances) could speak – that’s what they’d say about the times your security and sysadmin teams deploy a new AV tool without talking to … Read more
Monday morning: you’re back at work, but your SQL Server estate had a weekend from hell. Some companies find that out the hard way—every single Monday.It’s almost like SQL Server is taunting you, “How does it feel to treat me like you do?” I See a Ship in the Harbor (Do you watch for SQL … Read more
Maybe I’ve forgotten the name and the address of every patient I’ve helped throughout my years in EMS back when I was still involved, but there’s one thing I know: quite a few would say hindsight is 20/20. The older I get, the more I see how often this pattern repeats. Whether it was the … Read more
Deborah Melkin is hosting the community T-SQL Tuesday #184 carnival of blog posts. Her topic is one that is near and dear to her – and also near and dear to us here at Straight Path – Mentoring and Sponsorships. I am really looking forward to reading all of the posts this topic generates. Deb … Read more
For full disclosure – this is the business we are in here at Straight Path IT Solutions. We know something about running a SQL Server Managed Services practice. While we’d love to talk to you and work with us, there are a lot of excellent firms out there like our friends at Dallas DBAs, Procure … Read more