Except I worked in a doctor's office in high school. The info wasn't private. Doctors were difficult in copying records, and they shared them easily. I saw people giving out...

I agree in  some sense that things with data haven't really changed, but the reality is that there is a lot of data that has never been private. It's been...

Now that's an interesting idea, Roger. Imagine we could easily store every address in an area, or maybe a whole host of fake addresses that we don't even link or...

Thanks, and that's a place you need to understand them. I was quite confused about times when working with the rest of the world on my trip down under.

I'd completely disagree. I think their quality in many areas has gone up. Windows is better at patches than it used to be. Quality going up doesn't mean there aren't...

Love seeing these posts. That's the point.

A new bump in the road with one person in the office. I'm working on a improving performance for a procedure and send it to code review with him....

Glad you liked it. I enjoy the Python questions, though they can be hard to structure.

This is actually fascinating. I need to test, but a rebuild should (with rebuild with drop existing) spread the index across all four files. Note that if you have space,...

Please repro this with a new db and provide the code. The EXECUTE AS USER maps to a user. What user is mapped in your database.

It seems like you want a table where the flags auto update based on that current date. I think you might better phrase what you're trying to do and show...

Let me give you a small overview. If you have a filegroup, SQL Server tries to write to all files in the filegroup. I assume you have 1 filegroup now...

Please send a note to the webmaster (webmaster@) to chase this down. Use your subscription email or make a note in the email.

Also network segmenting - https://www.sqlservercentral.com/editorials/segments-for-protection

Committees in most cases, perhaps an individual in some, but likely some group.

I think T-SQL, probably SQL as well, are horribly broken in their models. The whole "Create" "ALTER issue...