This avatar thing seems like an attempt by recruiters to reduce the tedium and workload of having to interview scores of run-of-the-mill candidates for entry level jobs. But rather than...

What is the current status of the database, and also check for messages in SQL Server error log around the time that the instance restarted that would indicate what issues...

Azure Cosmos DB does automatic indexing. By default, it essentially indexes all data access paths, which is possible because it's a collection / document based database where all the relationships...

But can SQL Server support a single table spread across 1 million partitions and files?

It seems that IT within banking, mortgage, healthcare, education, and government is far from being a model of excellence. I feel that the big name IT contracting, ISV, and implementation...

Damage control, or knowing how to fail gracefully, is important in so many aspects of life. In retrospect, it would probably have worked out better for them (meaning IT) had...

It smells like an attempt to direct folks to downloading ransomware.

Sometimes "Fake it, 'till you make it" ends up being "Fake it, 'till you break it".

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