Blog January 30, 2024 In the SQL Server database management, gathering fragmentation statistics can be kind of a black box: it’s time-consuming, and you have no idea how far along it is. Enter Live Insight, a game-changer within Minion Reindex that provides real-time visibility into the process. Live Insight... Minion Reindex Live Insight: How’s my SQL index maintenance going? June 15, 2023 Them: "Dude, we can't do anything." Me: "Yeah, I know. I told you this would happen. You can't skip database maintenance." How special is your server? January 3, 2023 From my many years in the field, many interviews conducted, many tragedies experienced and averted, many hours spent in extra-vocational activities, I can absolutely distill everything I want you to know down to one simple thing: Test your knowledge. The best way to be a brilliant DBA? Test your knowledge! October 17, 2022 I’ve often seen a company stuck with an old product version 10 or 20 years because the upgrade would be too onerous. Here are some basic tips to make the process easier. I’m going to concentrate on SQL Server upgrades, but many of these apply... The Technology Upgrade Chase: 7 Essential Strategies June 2, 2022 We spend a lot of time thinking about the problems and solutions for shops with dozens or 100s of SQL instances. So, here's a "choose your own data adventure" for you, large-SQL-shop-person! SQL Servers by the dozens… April 13, 2022 Today we're going to hit my top 5 - well, top 6 - boots-on-the-ground security tips for SQL server: schemas, db_owner, dynamic SQL, DENY, crossover groups, and secondary servers. SQL Server Security on the Ground Load More
January 30, 2024 In the SQL Server database management, gathering fragmentation statistics can be kind of a black box: it’s time-consuming, and you have no idea how far along it is. Enter Live Insight, a game-changer within Minion Reindex that provides real-time visibility into the process. Live Insight... Minion Reindex Live Insight: How’s my SQL index maintenance going?
June 15, 2023 Them: "Dude, we can't do anything." Me: "Yeah, I know. I told you this would happen. You can't skip database maintenance." How special is your server?
January 3, 2023 From my many years in the field, many interviews conducted, many tragedies experienced and averted, many hours spent in extra-vocational activities, I can absolutely distill everything I want you to know down to one simple thing: Test your knowledge. The best way to be a brilliant DBA? Test your knowledge!
October 17, 2022 I’ve often seen a company stuck with an old product version 10 or 20 years because the upgrade would be too onerous. Here are some basic tips to make the process easier. I’m going to concentrate on SQL Server upgrades, but many of these apply... The Technology Upgrade Chase: 7 Essential Strategies
June 2, 2022 We spend a lot of time thinking about the problems and solutions for shops with dozens or 100s of SQL instances. So, here's a "choose your own data adventure" for you, large-SQL-shop-person! SQL Servers by the dozens…
April 13, 2022 Today we're going to hit my top 5 - well, top 6 - boots-on-the-ground security tips for SQL server: schemas, db_owner, dynamic SQL, DENY, crossover groups, and secondary servers. SQL Server Security on the Ground