SQL Injection: Deconstructing an Attack
June 29, 2024
This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. As
5 Key Backup Strategies for Unbeatable SQL Server Security
June 19, 2024
This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. There
SQL Server Security: Best Practices with CLR
June 18, 2024
This post is part of our SQL Server security blog series, 30 SQL Server Security Checks in 30 Days. We’re publishing a new security check every day in the month of June. Visit our sp_CheckSecurity page to learn about our free SQL Server tool you can download and run to check your own server. What
Building a Consultancy: More Principles
February 26, 2024
A couple of weeks ago, I started blogging about part of the journey of creating our SQL Server Consulting firm. I may someday work on more posts on the journey from full-time DBA to doing some side work to leaving with an “anchor client” to going off on my own (and my adventures with Linchpin
Building a SQL Server Consultancy
February 12, 2024
Principles and Values First In 2011, I set out to be an independent SQL Server consultant. At the time, if you told me I’d be looking back 13 years later as a “CEO” of a SQL Server Consulting practice with a team of 17+ FTEs serving 120+ Managed SQL Server DBA as a Service clients,
Maximizing SQL Server ROI in M&A
August 26, 2023
The Hidden Goldmine: SQL Server Due Diligence in Acquisitions Whenever I’m chatting with folks in the investment world, especially those eyeing product or “… as a service” companies that use Microsoft SQL Server, I’ve realized there’s a real need for clear, actionable insights on what to look for in a SQL Server environment. It’s not
Ask Us Anything Webinar (March 2023)
March 7, 2023
This month’s webinar is an opportunity to ask us anything related to SQL Server. Our team will hold a panel-style webinar to answer your questions (click here to submit a question before the webinar). Mar 22, 2023 01:00 PM in Eastern Time (US and Canada) Click here to register:
SQL Server Upgrade/Migration Webinar
December 9, 2022
This month’s webinar ws all about SQL Server upgrades and migration. We covered the following topics: This topic is part of our monthly SQL Server webinar series. Webinar registrants get access to the entire recording, which includes the office hours Q&A. Check out the videos from the webinar series: Introduction Why Upgrade? In-place SQL Server
Books and Covers…
December 5, 2022
Believe me, every heart has its secret sorrows, which the world knows not, and oftentimes we call a man cold, when he is only sad. Longfellow, Hyperion (1839) This post has been rattling around in my head for several years. Of late, though, the rattling has turned into a steady vibration. The day before I
SQL Server HA/DR Webinar
November 29, 2022
On Tuesday, 12/13/22, we presented a webinar about HA/DR (high availability and disaster recovery). Join Team Straight Path as we discuss what HA is, what DR is, and how they are different. We talked about the ways to achieve HA and DR. We’ll talk about the things we’ve learned about HA and DR along the