The introduction of self serve online trading back in the late 90's changed the role of stock traders and personal financial advisers somewhat - but it didn't lead to their...

I don't sign into websites using my Google or LinkedIn ID, and I also I don't browse the web while logged into these things. I try to log out from...

Back in the 1980's, most US states passed versions of the "Library Privacy Act" and "Cable TV Privacy Act" - and those laws are still on the books. Folks were...

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

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