I'm not convinced that execution plan optimization can be significantly improve by throwing more CPU power at it. Sub-optimal plans are typically the result of stale or missing statistics and...

So the reported issues ranged from: Outages, zero balances, performance issues, customers seeing other customer's account data, cryptic error messages like "..Singleton bean creation not allowed while the singletons of...

After migrating some of our databases to Azure, I installed SQL Server 2016 Enterprise Edition and SSIS on an Azure IaaS host and consolidated all of our ETL packages there....

Forget about Windows and Linus, it's theoretically possible that SQLOS could be retrofitted to run alone on bare metal.

If you're like me and work in a larger sized IT organization where the on-prem server hardware and VMs are provisioned and managed by a dedicated Platform Operations / DevOps...

Of course, deleting data from the online operational database doesn't mean it isn't archived somewhere offline or accessible online from a data warehouse. These days, even the most ancient and...

... For the purpose of a discussion, let's say you run an older version of SQL Server on Windows, like SQL 2000 or 2005. You want to upgrade, but...

Whenever I hear about "The Right to be Forgotten", I think about that 1995 movie, The Net, where Sandra Bullock has her digital identity erased by hackers. That movie introduced...

It makes perfect sense to retain things like sales orders, financial transactions, court records, and health records in digital format indefinitely, because there may be an essential need for this...

Simply querying system tables won't cut it. Check out the sys.fn_my_permissions function which can be used to determine "effective" permissions, meaning it covers permissions inherited by membership in domain, server,...