If you’ve worked with SQL Server for very long, you’re probably familiar with the concept of indexes. Indexes can help speed up queries by allowing SQL Server to quickly locate specific data values within a table. Indexes are typically much smaller than their underlying tables so they can be searched much more efficiently. (They aren’t…
Read more
Coach John Wooden is a legend. He led his beloved UCLA Bruins to ten NCAA National Championships in twelve years. That is an unparalleled accomplishment in any sport, in any endeavor really. So, I began wondering: what if Coach Wooden led a team of DBAs? What would he do? How Coach Wooden’s approach applies to…
Read more
“If three people are responsible for feeding the dog, the dog is going to starve. You must have clear areas of responsibility.” In his book Risk, retired United States Army General Stanley McChrystal shared this quote. It’s from a mentor he had as a young officer. And It helped shape his career. As a family…
Read more
I was on my morning walk recently when I noticed this laying on the walking path. Some call it a binky. Others a pacifier or fooler. Whatever you call it, it’s an essential piece of equipment for some infants. Without it, their world falls apart. And the calamity is contagious. They, and everyone around them,…
Read more
I’m not really a car guy. My daily driver is 10 years old but it serves me well. It’s reliable. It gets me where I want to go and back again. And I want to keep it that way so I maintain it. I change the oil regularly, I rotate the tires almost as often,…
Read more
Are you a seasoned DBA that’s feeling a bit stagnant? Or maybe a junior DBA who wants to elevate her DBA game? Perhaps, you’re an “Accidental DBA,” someone whose primary role is something besides DBA yet you’re being asked to take care of the database in your spare time? Wherever you are in your career,…
Read more
We’re often asked to provide support during a crisis. Maybe a critical database is corrupt and no longer accessible. Or worse, an entire SQL Server instance is lost. Fortunately, many companies have a documented backup process. What’s far less common, however, is a well-documented process for restoring and recovering the critical databases. That part is…
Read more
“It takes forever to login to the clinical application. I have patients waiting. And I have to sit there waiting for the application to let me in. It’s not good.” Or, “I click the report and wait, and wait, and wait. Finally, I give up and hit Refresh. Nothing happens. Can’t you fix it?” Sound…
Read more
Some companies take virtual machine snapshots of their web servers, their file servers, and their Citrix servers. They regularly snapshot before software patching, before server upgrades, and before other configuration changes. Snapshotting a good way to ensure they can recover the VM if something goes wrong. So, that begs the question: should you use VM…
Read more
Cumulative Updates, CUs, are the way bug fixes and other improvements are released for SQL Server. These updates can make your SQL Servers more secure, they can fix performance issues, and they can make your system more reliable. But, as with any new code, they can sometimes introduce new issues. It’s not often that this…
Read more
Recent Comments