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

My understanding is that the client only needs to have installed the root certificate of the Certificate Authority, and then the client can validate any server certificate issued by that...

Lay folk (non-techies) are impressed by Avatars, because they look more human. They can do things like provide context sensitive winks and smiles, so they're perhaps assumed to possess more...