Good article, we are also a VMWare environment and thus applicable. I noticed the example selects a single storage location, yet spins 8 drives out of this over 3 SCSI...

Need trick and scanning the AD-group is certainly useful, but wouldn't you want to know the real permissions in SQL Server itself to the Database level? Or at least compare...

the article will provide answers: http://sqlmag.com/database-security/sql-server-encryption

Usefull technique that I have used mysqelf, even to re-org a DB. One does have to question why there is this over allocation of space in the DB's to begin...

Great Article and well explained. I hear 'disk space' is cheap all the time as well. The problem typically stems from the fact that the developers don't fully understand what...

You may want to look at the disk space on those server boxes, particularly the logs. Insert INTO creates logs for the session. Afterwards the logs are emptied when you...

Thansk Parthi, works like a charm 😉

I don't want to change the table because the server frequently runs multi-day processes, so renaming/dropping/moving is out of the question because it could affect those processes.

The list itself is...

sorry, should have added that the username is not sufficient info, because it is likely some automated process. I rather see the query that is performed and from which DB...

Good article.

Not sure that on larger datasets and/or busier server one would want to DELETE/TRUNCATE records. The risk with DELETE/TRUNCATE is that you change your original content, thus you are...

Interesting thought but returns several records. The hostname parameter did put me in the right direction for a new Google search, which resulted in the following:

SELECT HOST_NAME() AS HOST_NAME

Reference:

decided to use COALESCE() function to improve coverage 😉

--> coalesce(suser_sname(),suser_sname(),suser_name())

forgot to mention, we use 'windows authentication'

what is the difference between SYSTEM_USER and suser_sname?

thanks again

Thanks for Sharing the website Brad! I find it useful to see how the robot learns and improves as generations pass. Although even higher generation can get themselves driving in...

youngi,

in my example:

nsewca

000014

000114

000211

starting at top left as indicated by article

Line 1: instruction is not to move and pick up the can

Line 2: Move 1 square to west and pick up...