It depends on what type of lab you want to setup. I believe that building up a local lab is way more expensive than an Azure subscription (both in financial...

I'm not sure the FTC has a general reporting rule. They have rules over health data and there was (maybe law?) a draft on credit agencies, but I don't...

Here in the US, the Federal Trade Commission (FTC) mandates that corporations report data breaches, and other agencies enforce HIPPA and Sarbanes-Oxley Act (SOX). But is there an agency (the...

We keep hearing about data breaches resulting from data being exposed on the internet, meaning that a web search could access the data in un-encrypted form. There is more to...

a_dep like '100%'

What I meant was that, when considering which version of SQL Server to run on, if there are...

I've never known any release of SQL Server to be categorically "unstable". Every release fixes some issues and introduces new issues, but every experience is unique depending on what features...

I believe that Azure Stack and server-less architecture could make financial sense for an organization with a very large IT enterprise; maybe something like a government or global bank where...

Also, since the application is only filtering on a tiny subset of rows, then consider simply using Filtered Indexes as an alternative to my previous suggestion of a Paritioned View...

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