Can You Let Go of Determinism
Voice of the DBA
Why do we reboot machines when something goes wrong? I'm sure all have done it, and I would guess quite a few of you have found situations where this seems to fix issues, but there isn't an underlying root cause that you can pinpoint. This is a fairly accepted way of dealing with issues, but have you thought about why this is a way to solve some problems? The main thing that a reboot does is return the system to a know starting state. It's why quite a few people complain about some modern laptops and mobile devices because they avoid restarts and try to sleep/wake instead. Most software...
info_outline
Doing Good at SQL Server Central
Voice of the DBA
This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. We did photoshoots at Redgate many years ago. We had a bunch of props, including some phrases written down. We could create our own, but my handwriting is atrocious (likely why I never became an architect), but I ended up with this one: Read the rest of
info_outline
Engineer Lessons
Voice of the DBA
Many of you reading this have a number of years working with technology. You might have 1 year or 20 years, but you've likely grown and learned along the way. Some of you may also know someone who has several years of seniority in a position but not that many years of experience. In this case, a person might have been working at this job for 5 years, but they really have one year of experience that's been repeated 5 times. That's been a common complaint over quite a few years from people who interview others. They find candidates often have very limited experience, yet are applying for senior...
info_outline
Expanding into Print
Voice of the DBA
This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month. When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were based around the digital world and treating the community as we would want to be treated. Over time, however, we realized that continuing to grow this business was hard in a digital-only world. We experimented and proposed helping others build similar sites, like ReportingServicesCentral...
info_outline
The Power of Data and Privacy
Voice of the DBA
I tend to be fairly careful with data, especially data on this site. When we started the site, we were worried about potential issues and worked hard to ensure we kept our systems safe and limited the attack surface area for personal information. We also declined the various offers we had to sell our list of subscribers to marketing firms. We know that some places add value for marketing, but some abuse the trust of their users and our approach was always to be careful. When we sold the site to Redgate, we emphasized the need for this trust, and to date, Redgate has been a great steward of...
info_outline
The DBA is Dead; Long Live the DBA
Voice of the DBA
I remember getting a job at a startup in the Denver Tech Center. This was shortly after SQL Server 7 was released, with a marketing campaign that the platform was auto-tuning and wouldn't require a DBA. My colleague asked me if I wanted to learn Cold Fusion and have a longer career. I declined and stuck with this SQL Server thing, which has seemed to work out pretty well over the years. I was reminded of this when I saw a "" post, this time from an Oracle DBA. There are plenty of links in there from Larry Ellison and Oracle about how some version of Oracle won't require a DBA. I've seen (and...
info_outline
When SQL Server Central Went Down
Voice of the DBA
Read the rest of
info_outline
Expensive CPUs
Voice of the DBA
There have been a lot of features added to the SQL Server platform over the years. Several of these features let us perform functions that are beyond what a database has traditionally been designed to handle. SQL Server has had the ability to , , and in SQL Server 2025, we can . Quite a few of these features (arguably) are more application-oriented than database-oriented. There's nothing inherently wrong with having a server perform some of these functions, and there have been some very creative implementations using these features. I recently ran into , where she shows how to use the...
info_outline
25 Years of SQL Server Central
Voice of the DBA
The oldest article we have on the site is , by me. It's dated 2001-04-18, though I think that's a date we picked when we converted all the content from one database to another. The founders agreed sometime during Feb 2001 to jointly run SQL Server Central. Since we each owned the copyright of our articles from another site, we migrated several articles to build up our content library. This was back when , , and I all had full-time jobs and managed the site during breaks, nights, and weekends. That was 25 years ago. Twenty. Five. Years. Read the rest of
info_outline
There Are a Lot of Databases
Voice of the DBA
I was reading Andy Pavlo's . He's done this for a number of years, and there are links to previous recaps in the piece. He is at Carnegie Mellon University, working on quite a few database-related projects. In the review, he tends to track the database world from the perspective of business success and money. There are certainly parts of it that discuss technical changes, but my overall impression is more about the business and usage success than it is about the way database systems work. The main thing that struck me after reading the review was how many database systems there are in the...
info_outlineMost of us that work with SQL Server likely use either the Windows authentication or a user name and password when connecting to an instance in SSMS or ADS. It's how we've operated for years, and likely will for some time to come. If you connect to Azure cloud resources, perhaps you use some multi-factor authentication (MFA), but that's a minority of us.
If this article is a picture of the real world, far too few people are using authentication beyond passwords for many services. While plenty are using fingerprints, patterns, or face recognition on a mobile device, that's usually the extent to which they actually go beyond a password. I've actually started to see people using PINs on laptops instead of a password, which feels like a step backward.
Read the rest of Getting Beyond Passwords