Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,526 through 33,540 (of 59,099 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

We're good now. Steve Jones and one of the Developers were able to recover the article in it's entirety. None of us know what happened for sure.
Thank you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2011 at 5:22 pm

#1342744
RE: Analytical Interview Questions

Craig Farrell (6/21/2011)
Jeff Moden (6/21/2011)
toddasd (6/21/2011)
What do yall think about giving the interviewee a "broken" database to analyze? Script out one of your databases except remove some indexes, rewrite a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2011 at 9:27 am

#1342498
RE: Does anyone have a good reason to run xp_CmdShell?

rmechaber (6/22/2011)
BUT: doesn't this tie all non-sysadmin execution of xp_cmdshell to that proxy account?
Yes it absolutely does... just not the way that most people have been led to believe mostly...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2011 at 9:14 am

#1342479
RE: Does anyone have a good reason to run xp_CmdShell?

Craig Farrell (6/22/2011)
Thankfully, I'm not wearing britches... so I don't care.
Ummmm.... and you're at work? Now I'm the one that's skeered. 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2011 at 8:57 am

#1342463
RE: Does anyone have a good reason to run xp_CmdShell?

opc.three (6/22/2011)
Craig Farrell (6/22/2011)
For anyone following along with the Level II masquerading as a III, here's my next hint for research:
With Sommarskog's help
Hey, I resemble that remark 😀 and if...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2011 at 8:52 am

#1342458
RE: Does anyone have a good reason to run xp_CmdShell?

rmechaber (6/21/2011)
Jeff Moden (6/21/2011)
The problem that I'm becoming more and more aware of is that people really don't know how to run procs that contain xp_CmdShell without giving the proverbial...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 11:56 pm

#1342238
RE: Does anyone have a good reason to run xp_CmdShell?

opc.three (6/21/2011)
Visceral would be a good word to describe my reaction when I see recommendations like "oh yeah, you can just use xp_CmdShell to do that" doled out nonchalantly on...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 11:48 pm

#1342237
RE: Does anyone have a good reason to run xp_CmdShell?

Craig Farrell (6/21/2011)
Don't look to me to have insider information. I'm blindly stumbling along in the wake of this thread, being the voice of the average soul going "Wait,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 10:47 pm

#1342229
RE: Does anyone have a good reason to run xp_CmdShell?

opc.three (6/21/2011)
I won't let the cat out of the bag as to how I think you're planning to create the misdirection necessary to accomplish a secure xp_cmdshell environments without any...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 9:46 pm

#1342217
RE: Does anyone have a good reason to run xp_CmdShell?

Craig Farrell (6/21/2011)
Craig Farrell (6/20/2011)
I may need to, however, learn more about this before I go any further in this debate:
opc.three (6/20/2011)
xp_cmdshell can be used by everyone on the instance...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 9:19 pm

#1342211
RE: Does anyone have a good reason to run xp_CmdShell?

opc.three (6/21/2011)
Re: the hiding, I have to ask because I know I'm missing something...ORIGINAL_LOGIN() shows us "who really ran the proc" in T-SQL and SessionLoginName shows us "who" inside a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 9:12 pm

#1342209
RE: Analytical Interview Questions

toddasd (6/21/2011)
What do yall think about giving the interviewee a "broken" database to analyze? Script out one of your databases except remove some indexes, rewrite a basic update statement to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 5:33 pm

#1342185
RE: Does anyone have a good reason to run xp_CmdShell?

mvillar (6/21/2011)
Couldn't that kind of process be controlled completely outside of SQL Server?
Wouldn't it be easier to do it in .net?
well, it have a lot of uses, to do some...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 4:36 pm

#1342172
RE: Does anyone have a good reason to run xp_CmdShell?

opc.three (6/21/2011)
Jeff Moden (6/21/2011)
Craig Farrell (6/20/2011)
I know I'm personally horrified at the idea of having my devs write up their own xp_cmdshell with EXECUTE AS permissions as a proc for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 4:30 pm

#1342168
RE: Analytical Interview Questions

mrngorickets (6/21/2011)
GilaMonster (4/3/2011)
Jeff Moden (4/3/2011)
GilaMonster (4/3/2011)
Please note: 3 year old thread.
It doesn't matter on such timeless subjects.
I post those as a notification as to the original age so that people...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2011 at 8:31 am

#1341880

Viewing 15 posts - 33,526 through 33,540 (of 59,099 total)