Restoring a database in production, even just a point in time restore from log backups, can potentially cause more harm than good. It's always seemed to me that the vast...

In past jobs, there were many situations where the business wanted to know the data behind a report that was produced on a certain day in the past, maybe even...

Yes, an extended event or sql profiler trace is needed to tell you the client host name and/or account name that executed the query. That information isn't contained in execution...

By default, I typically have a daily job that will REORGANIZE (partitions) having fragmentation > 15%, and a weekend job that will REBUILD (partitions) having fragmentation > 30%, but that...

On my desk at work, I have two paintings made by my kids during their summer camp. Also, there is a collection of assorted carved wooden animals, which are gifts...

Whenever I hear non-IT folks talk about how those of us in IT have it easy, I'm reminded of that Dire Straits song 'Money For Nothing'.  😛

Normally I don't...

... The service does this by keeping a log of all transactions for a set amount of time (up to 72 hours). When things go bad after you dropped...

.. The problem is that for many of us, we may run DBCC CHECKDB on another machine, perhaps on a restored copy of production, so how can we track...

If your burnout is the result of boredom then that's a symptom of not taking on enough risk or perhaps not reaching out to take on new challenges.

The thing is, folks in IT are often far removed from the fruits of their labor. A job working for the world's largest eCommerce company versus working for a bank,...