If insurance companies are going to start paying for ransomware mitigation, then the policy should require that the insured have adequate anti-malware, procedures, and training in place. This would be...

I work in an open office plan, but we also have plenty of meeting rooms and secluded work spaces for when a fellow needs to focus.

Also, it's easier to get...

I'm unconvinced whether AOG and other replication or scale out technology increase or decrease database availability. Designing the applications (and monitoring) to be more fault tolerant can increase system availability...

"..When we started SQLServerCentral, there were originally 7 of us. We all decided to "invest" $50 to get the site going. With this seed money, we paid for a VM...

I just now rated the article 3 out of 5, because while it's well written, no discussion of very large table index maintenance would be complete without mentioning the PARTITION...

If you ever complete something like a product registration survey and specify your income range, then it's in the wind. Marketers, employers, crooks, and even your next door neighbor can...

I don't expect to bump into a database with UTF-8, unless it's something like a 3rd party ISV application that enables it by default. What is the use case for...

When job hunting, I'm point blank with potential employers or recruiters about what my current salary is. The way I see it, if either party can't match the...

Thanks Eric.  The cmd is "TASK MANAGER" - i don't know how to figure out what that means, specifically, except I'm guessing it's part of the db restore that...

The object drop events are logged in the default trace, and from there you can get date/time, session login name, etc.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/default-trace-enabled-server-configuration-option

Whatever service (I'm guessing something like monitoring, backup, or replication) is holding locks on the database, perhaps you can temporarily stop that service.

When job hunting, I'm point blank with potential employers or recruiters about what my current salary is. The way I see it, if either party can't match the expectations of...

"... I do carry electronics, usually a laptop, though sometimes two, along with the various supporting plugs and wires for charging it and my mobile. There was a time when...

We use  Atlassian hosted Bitbucket - locked away behind encrypted repositories...

Canada has something similar.

".. Information on all public sector employees who were paid $100,000 or more in 2018 and are subject to the Public Sector Salary Disclosure Act .."

https://www.ontario.ca/page/public-sector-salary-disclosure-2018-all-sectors-and-seconded-employees