Pay Yourself First
The biggest problem I see is the huge number of DBAs who have let themselves fall behind. Live in interview mode, and pay yourself first, and you won’t fall behind!
Articles
Coding Naked
Let’s talk about CASE tools, and why coding for databases without one feels so….exposed.
Have you met Hiro?
Six things to know about Minion Enterprise: 1. You love T-SQL. 2. ME is an enterprise product. 3. No dropping objects on servers. 4. No event storming. 5. Log everything. 6. And it takes just five minutes.
Your Service Level Agreement is a Disaster
As a DBA, you’re in charge of getting systems up and running quickly in the event of an emergency. This is all right and proper, right up until you start defining SLAs. Let’s see what went wrong.
Databases need more than performance monitoring
There is more to databases than performance monitoring. So why are the most popular DBA tools, performance monitoring tools? They don’t even begin to cover the vast majority of DBA responsibilities. What we need is environment monitoring.
Distinguish backup file names or pay the price!
So far, no one has found exercise to be beneficial to servers. Purposeless repetitive motion may be good for human muscles, but your SQL Server instance experiences no gain for the pain. Here’s a good example: taking useless backups. Let me explain…
Technology: Shoot yourself in the foot faster!
Most of us love technology. And most of us have experienced how blindingly fast technology can provide some degree of cataclysmic failure. Especially when you start by saying, “I should go ahead and do that real quick…”
Five minutes to freedom: Installing Minion Enterprise
Get your repo server, your Minion Enterprise download, and your license key (trial or permanent). Install and config take just five minutes, and your entire enterprise is in order.
SQL maintenance is a lifecycle, not an event!
You’ve heard me talk about this many times, in so many different ways, but it’s worth repeating: SQL maintenance lifecycles are important.
People who disagree, disagree because they spend too much time firefighting and don’t have time to really think about it. Don’t know anything about SQL maintenance lifecycles? Let’s touch on a couple of points…today, we’ll cover SQL backup.
Integrity Checks are Useless*
Integrity checks have become more and more important over the years, as companies store more and more data. This data is absolutely critical, so when corruption happens, it can break a company. But in all but the smallest shops, running any kind of integrity check is all but completely useless. Unless you have Minion CheckDB.