I like questions related to covering indexes, and I always have that card in the interview deck, because answering this question involves practical knowledge, especially if the interviewer asks a...

What motivates these new editions (or hosting options) for SQL Server is probably an attempt by Microsoft to lure more high value corporate customers into the Azure tent. I'm sure...

Data! Data! Data! The more the merrier! Right???

Face Book sold personality profile data for millions of users to this data analytics company called Cambridge Analytica. So, who is Cambridge...

Cyber security and digital privacy are rarely ever political campaign issues up for debate here in the US, at least not in the same way that immigration, the environment or...

This sounds sort of like IaaS, except without a SQL Server license and without access to the host VM.

Rather than paying $$$ for the latest phone, you can just reach into the recycle bin at Whole Food and grab the previous model still in good condition. There are...

... I ran across a talk from Uber on reliability. It's more of a high level architecture talk about distributed systems and being able to detect and respond to issues....

I have a password manager app on my phone, the type which maintains a local encrypted database file along with backups to a 3rd party cloud. Despite the option being...

There are a lot of applications that have DST logic hard coded into them. It will be sort of like Y2K.

Moving forward, I predict that cloud based database-as-a-service (DBaaS) and software-as-a-service (SaaS) solutions will become more prevalent. Implementing e-Commerce, data warehousing, or Big Data projects on-premises is complicated and too...

... Any number of other companies also use data to power their BI systems and dashboards that help their employees make better choices. That seems in contrast...

If we're talking about DML auditing, then Change Tracking can potentially give you what you need with less overhead and storage than insert / delete triggers.