If you create a primary key, then you do get uniqueness, but the identity property doesn't manage that. Common misconception

Testers needed

OK, we're getting close on the new site, and I know a bunch of you want to test forums. Send me a note (PM or email sjones...

Steve M pointed this out, but the

SELECT @CMD + xxxx

lines create a statement. The last one with just

select @cmd

Once you get the code: http://www.sqlservercentral.com/articles/Stored+Procedures/183073/

Are you auditing successful logins?

Are you asking if these should not be from SSMS or if this is a large amount from SSMS? Every time you open a...

That should help. the log files are supposed to fill before moving to the next one, and it's possible that if they are closely sized and full that you're growing...

If you want to learn Unix/Linux, I'd install a VM and practice there. Working inside a container is OK, but you're slightly crippled, so you don't really learn. The Stairway...

It's not even about free  Some of the issues are for paid services 

Data really is the new oil and organizations are loathe to have any restrictions. Hopefully l...

What are you protecting from? If you have the machine fail, there's no HA. If you think the db files might fail, I guess you could back up and restore...

Why replicate? I'm not sure what you want to do. The distributed transaction is less of an issue on the same server, with SELECT queries, and more with writes.

There is a lot of legacy code out there using text/image, and various other features. Large customers especially, and large vendors (think ERP, Accounting, etc.) that have legacy code they...

I do use Google photos now, and try to back up the important ones locally (and to Backblaze). I'll grab a set from my phone via USB and keep them...

Please don't run code you don't understand without working with it in production. You noted you had a test database, which is slightly better, but what if I had malicious...

Ah you BI people always cause problems.

good point. Need to submit a change for the docs and update the question to say rowstore.

I'm not sure what you mean. Do you mean change the LSN sequence? Full/diff backups don't change this. The log backups work with the LSN. The subsequent full/diffs can be...