Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,246 through 13,260 (of 59,095 total)

RE: OPENROWSET when Excel worksheet name is unknown

Hansiehans - Wednesday, January 3, 2018 3:25 AM
Jeff Moden - Saturday, December 23, 2017 8:29 AM
--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 3, 2018 at 5:05 pm

#1974369
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Wednesday, January 3, 2018 3:50 PM
Jeff Moden - Wednesday, January 3, 2018 3:23 PM
--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 3, 2018 at 5:00 pm

#1974368
RE: Creating multiple Rows from one row by substringing a column

lsinoff - Tuesday, January 2, 2018 9:33 PM
I need to create from 1 to n rows from a single row where the one...
--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 3, 2018 at 3:56 pm

#1974364
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Wednesday, January 3, 2018 2:29 PM
Caruncles - Wednesday, January 3, 2018 8:34 AM
--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 3, 2018 at 3:23 pm

#1974362
RE: An Introduction to PowerShell for a DBA

kevaburg - Wednesday, January 3, 2018 12:07 AM
Alex Chamchourine - Tuesday, January 2, 2018 11:53 AM
--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 3, 2018 at 3:21 pm

#1974360
RE: Is there a way to identify dynamic sql that may be vulnerable to sql injection?

GilaMonster - Wednesday, January 3, 2018 12:07 PM
Thom A - Wednesday, January 3, 2018 11:47 AM
--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 3, 2018 at 3:12 pm

#1974359
RE: Find a string with two dots

khpcbgnt - Tuesday, January 2, 2018 5:06 AM
Hi ,
I have two values 13.4. and 16.8.7 in a field that is varchar type....
--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 3, 2018 at 3:06 pm

#1974357
RE: Are the posted questions getting worse?

jasona.work - Wednesday, January 3, 2018 10:34 AM
Greg Edwards-268690 - Wednesday, January 3, 2018 10:16 AM
--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 3, 2018 at 12:32 pm

#1974321
RE: Is the old stuff worth learning?

Eric M Russell - Wednesday, January 3, 2018 12:01 PM
We have come full circle, sharing time and the same decades old problems...
--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 3, 2018 at 12:29 pm

#1974320
RE: Is there a way to identify dynamic sql that may be vulnerable to sql injection?

GilaMonster - Wednesday, January 3, 2018 11:21 AM
sp_statement_completed & sql_statement_completed and look for sp_executesql or EXEC with brackets.
Or the entire batch with...
--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 3, 2018 at 12:26 pm

#1974318
RE: The Case of the Shrinking CFO, err Database

Ray Herring - Wednesday, January 3, 2018 11:10 AM
Jeff Moden - Wednesday, January 3, 2018 10:23 AM
--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 3, 2018 at 12:20 pm

#1974316
RE: No Magical DevOps

To me, DevOps has absolutely nothing to do with helping to deploy code any faster or automating anything, although that's frequently the end result of a proper development and support...
--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 3, 2018 at 12:13 pm

#1974313
RE: Is there a way to identify dynamic sql that may be vulnerable to sql injection?

grant@scarydba.com - Wednesday, January 3, 2018 8:53 AM
juniorDBA13 - Wednesday, January 3, 2018 7:05 AM
--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 3, 2018 at 10:49 am

#1974288
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, January 3, 2018 9:34 AM
We don't turn off our AC until about mid-December and then it's back 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)

January 3, 2018 at 10:28 am

#1974282
RE: The Case of the Shrinking CFO, err Database

Ray Herring - Wednesday, January 3, 2018 9:57 AM
Three different points.
A.) It is not the DBA's job to convince the CFO and...
--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 3, 2018 at 10:23 am

#1974280

Viewing 15 posts - 13,246 through 13,260 (of 59,095 total)