Viewing 15 posts - 16 through 30 (of 229 total)
Eric M Russell (7/20/2016)
No more tears.
ALTER SERVER ROLE [sysadmin] DROP MEMBER [<USER_NAME>];
USE <DB_NAME>;
ALTER ROLE [db_owner] DROP MEMBER [<USER_NAME>];
Too funny. I'm surprised nobody else picked up on this one.
August 25, 2016 at 1:58 pm
I am very curious to learn how you proceeded once you have completed it. Please get back to us on this.
Regards
July 21, 2016 at 8:30 am
Excellent question ! Even though my answer is wrong, I have learned something I never even suspected.
I azzumed that the fundamental property of addition : commutativity, i.e. the order of...
July 21, 2016 at 8:23 am
Jeff Moden (7/15/2016)
July 18, 2016 at 7:31 am
Jeff Moden (5/6/2016)
I'm with Ed. The auditing software is incorrect. Properly used, xp_CmdShell isn't a security problem.
I am not familiar with proxy accounts and even less on what...
July 15, 2016 at 12:18 pm
Could be an interview question. Ideally the candidate should ask "who in his right mind would even try to do this ?" Followed by "I don't even care if it...
July 15, 2016 at 12:07 pm
Luis Cazares (7/14/2016)
j-1064772 (7/14/2016)
Thank you for the post going further on the advice. 😉
My pleasure.
July 14, 2016 at 10:33 am
Alberto Ferrari and Marco Russo have produced remarkable articles on this subject. I suggest you look into this video: Vertipaq vs OLAP: Change Your Data Modeling Approach. [font="Courier New"](
July 14, 2016 at 9:14 am
Luis Cazares (7/13/2016)
July 14, 2016 at 9:05 am
Gail Shaw - As with the OP's original code, that is prone to concurrency problems (will cause duplicates under load)
Sipping from the hydrant ... I doubt I...
July 7, 2016 at 8:40 am
The performance of this "work-around" (for those who are stuck with earlier SQL Server) is inferior to the performance of the LEAD / LAG functions, which require reading the table...
June 28, 2016 at 7:37 am
Thanks for your explanation.
My curiousity was raised when I read about 00 being a "NULL" which scrapped whatever was following it.
But since in T-SQL '1' + NULL + 'whatever after'...
June 21, 2016 at 12:11 pm
[h3]select convert(varchar(max), val) as NormalConvert -- gets obliterated as second byte is NULL[/h3]
"Obliterated" ?
Isn't the 00 byte a terminator as in other languages ? So the conversion simply stops at...
June 21, 2016 at 8:59 am
Obviously, I did miss the intended sarcasm. In turn implying it was considered seriously.
Sorry.
June 15, 2016 at 11:22 am
"... I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all pipes...
June 15, 2016 at 9:58 am
Viewing 15 posts - 16 through 30 (of 229 total)