Back in the early 1960s, someone probably wrote an article stating that in the near future coding would be less important. By "coding" they meant machine language instructions punched into...

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...