Taking a step back, if the table gets routinely updated, then it's probably more like a queue table or a run log table (ie: row gets insert with StartTime populated...

Thanks to virtualization, your chances of running an instance of SQL Server 2008 in the future 2038 is very good. Going forward, you and your successor DBA(s) will need to...

Yes, I'm just being sarcastic about lines of code. 😉

If you work for an organization that counts lines code as a metric for developer productivity, then RedGate's "SQL Prompt" extension for SSMS is a great investment. A poorly formatted...

Speaking of Intelligent Query Processing, does it have a functional dependency on Query Store?

One of my PMP goals for 2019 is to implement Query Store on all of our >=...

• This reply was modified 6 years, 6 months ago by Eric M Russell.

If the web application is secured properly, then that web.config file is secure from outsiders, but it can be visible to many inside the organization. For one thing, the developers...

Of course, most of us already code assertions (more or less) into our T-SQL, and this type of defensive coding may constitute half of the lines of code written for...

I believe the T-SQL language could benefit from assertions, perhaps declared using an new ASSERT clause. For example, the following query would abort with an error when the actual rowcount...

• This reply was modified 6 years, 6 months ago by Eric M Russell.
• This reply was modified 6 years, 6 months ago by Eric M Russell.

Personally identifying data should be protected and regulated like hazardous material. Even with the owner's consent, there should be guidelines regarding how the data is stored and used. For example,...

• This reply was modified 6 years, 6 months ago by Eric M Russell.

While we're on the topic of digital data posted on the web getting used out of it's original context, one major issue is meta-data embedded in the files. For example,...

Of the big 5 data companies (Google, Amazon, Apple, FaceBook, Microsoft), Microsoft is the one I would expect to get HealthVault right, at least on the technical and security side...

I believe that having my health records stored in an online vault that can be accessed by my physicians or myself is very useful. However, all the apps, bots, and...

I've been playing around with some free alternatives, not interesting in any of the online only type of tools. Apex has a free data modeling tool you may want...

I wonder if Jeff Bezos has Alexa turned on in his home, or if Lary Page uses Google Nest for home monitoring. I suspect they probably don't, or maybe they...

Step 1, notify the DBA, and explain in detail how you as a developer were able to drop a production database in the first place, so the DBA can revoke...