Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,586 through 24,600 (of 59,099 total)

RE: CommandShellLogin

arooj300 (1/29/2014)
Hi All,
I am new in the SQL SERVER.
Can anyone tell me why we used to give IMPERSONATE grant access for the login CommandShellLogin to the user .
Example:
USE...
--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)

January 29, 2014 at 4:22 pm

#1684502
RE: Disk Space recomendation

Admingod (1/29/2014)
How do you recommend the disk space needed for next 1 year. Based on my understanding we can get by calculating previous year growth for MDF files.However, how do...
--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)

January 29, 2014 at 4:12 pm

#1684500
RE: Vulnerable to SQL Injection third-party API

Ya just gotta love the people that say things like "Well, it's always been that way" after you point out a major problem to them.
{EDIT} I just realized that could...
--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)

January 29, 2014 at 3:40 pm

#1684495
RE: Comparing string with date

ChrisM@Work (1/29/2014)
Jeff Moden (1/29/2014)
Post deleted. I made a mistake. I'll be back.
A little history Jeff. Might save you some time.
You're right. That's insane and now I know...
--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)

January 29, 2014 at 9:55 am

#1684390
RE: Comparing string with date

Heh... crud. I posted the same mistake... I'll be back.
--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)

January 29, 2014 at 9:36 am

#1684372
RE: Comparing string with date

Post deleted. I made a mistake. I'll be back.
--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)

January 29, 2014 at 9:21 am

#1684363
RE: Help with switching partition - getting error x contains primary key for constraint...

This is the "root" problem that needs to be prevented from happening...
We have a situation that data in a partition occasionally gets put into a wrong partition because the partition...
--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)

January 29, 2014 at 8:37 am

#1684342
RE: Vulnerable to SQL Injection third-party API

Cadavre (1/29/2014)
Thanks for taking the time to reply Jeff.
Unfortunately, none of the options you've laid out are viable for me. If I did any of them, the only loser would...
--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)

January 29, 2014 at 8:29 am

#1684340
RE: Pros and Cons of a Central Management Server

Steve Jones - SSC Editor (1/28/2014)
Jeff Moden (1/28/2014)
Thank you both. That's more inline of what I thought CMS should be for. What I've found is that a lot...
--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)

January 28, 2014 at 2:50 pm

#1684085
RE: Help with switching partition - getting error x contains primary key for constraint...

sherrerk (1/28/2014)
I figured the problem out. I had to nocheck the fk constraints referencing the table that was being switched.
Thanks!
That's cool. Still, the best thing to do would...
--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)

January 28, 2014 at 2:47 pm

#1684084
RE: Powershell code encapsulation into exe with dynamic parameters

AlexMcCo (1/28/2014)
Might be anyone could help with solution. I need to encapsulate powershell logic into exe. At the moment I am calling *.ps1 file using an agent job with passing...
--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)

January 28, 2014 at 2:45 pm

#1684081
RE: Forum Etiquette: How to post Reporting Services problems

Miles Neale (1/28/2014)
Oh Magoo, you've done it again! - Excellent piece of work!
M.
BWWAAAA-HAAAAAA-HAAAAA!!!!! ROFLMAO!!!! SEE? I'm not the only one that says that! :-D:-P:hehe:
--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)

January 28, 2014 at 2:42 pm

#1684080
RE: Help with switching partition - getting error x contains primary key for constraint...

sherrerk (1/28/2014)
We have a situation that data in a partition occasionally gets put into a wrong partition because the partition function was not changed properly.
My suggestion would be to fix...
--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)

January 28, 2014 at 1:14 pm

#1684055
RE: Powershell code encapsulation into exe with dynamic parameters

AlexMcCo (1/28/2014)
Might be anyone could help with solution. I need to encapsulate powershell logic into exe. At the moment I am calling *.ps1 file using an agent job with passing...
--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)

January 28, 2014 at 1:13 pm

#1684051
RE: Vulnerable to SQL Injection third-party API

Cadavre (1/28/2014)
Not sure where this post should go. . .
I have a third party API that I pass data from my database to. The UI front end of my database...
--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)

January 28, 2014 at 12:52 pm

#1684040

Viewing 15 posts - 24,586 through 24,600 (of 59,099 total)