bcp works with text files, with any delimeter, so a csv would work.

Keep in mind with log shipping the databases aren't in sync unless there are no changes on the primary after the last log backups is sent to the secondary. When...

AFAIK, if you truncate the table, the pages allocated to the NDX are deallocated. They are then cleaned up with the ghost cleanup process.

If there is data in...

Is this for testing or production? If production, you're not going to get support if you have issues. Pay for RHEL in production. For a lab, just do it.

It works on CentOS, but not officially supported.

Congrats, and enjoy. Sorry I'll miss you here, but I'll be on an airplane that day.

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