Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,906 through 7,920 (of 59,072 total)

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
That was precisely my thought. A fellow DBA in another company recently went through a bout with a ransom-ware. The ransom-ware was able to track down where the...
--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 12, 2020 at 3:12 pm

#3714756
Reply To: Creating Test Data

Steve Jones - SSC Editor wrote:
Jeff, you want CI to be fast, because you want to get feedback quickly. This runs constantly, so it needs to be fast.
This IS NOT THE ONLY TESTING done...
--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 11, 2020 at 8:27 pm

#3714694
Reply To: Creating Test Data

David.Poole wrote:
@jeff, how do they know the mid string search will always work? How is that more provable than your method?
They don't, actually. 😀 It's more of a visceral fearon...
--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 11, 2020 at 6:33 pm

#3714683
Reply To: Creating Test Data

Chris Harshman wrote:
One of the hardest things to do when generating test data as opposed to obfuscating production data is the non-normal situations. I've found in my years in IT that...
--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 10, 2020 at 4:25 pm

#3714487
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
no more articles for me for a short while, Steve already has one that he wants me to edit, but I've been in hospital since start of December 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 10, 2020 at 3:34 pm

#3714438
Reply To: Are the posted questions getting worse?

Jeff Moden wrote:
x wrote:
Phil Parkin wrote:
Do you have any favorite links on the subject of pulling rather than pushing?
Hmmmm ...
Nah thought I had one but no luck retrieving it.
I get better luck...
--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 10, 2020 at 2:58 pm

#3714381
Reply To: Are the posted questions getting worse?

Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
Grant Fritchey wrote:
Honestly, I thought we had pulled this from the product, but I was wrong. Here you go, object level recovery in Redgate SQL Backup.
ha , I...
--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 10, 2020 at 2:43 pm

#3714376
Reply To: Are the posted questions getting worse?

x wrote:
Phil Parkin wrote:
Do you have any favorite links on the subject of pulling rather than pushing?
Hmmmm ...
Nah thought I had one but no luck retrieving it.
I get better luck when...
--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 10, 2020 at 2:36 pm

#3714371
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
Grant Fritchey wrote:
Honestly, I thought we had pulled this from the product, but I was wrong. Here you go, object level recovery in Redgate SQL Backup.
ha , I hadn't...
--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 10, 2020 at 2:25 pm

#3714367
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
Honestly, I thought we had pulled this from the product, but I was wrong. Here you go, object level recovery in Redgate SQL Backup.
That was my understanding, as...
--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 10, 2020 at 2:18 pm

#3714360
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
jasona.work wrote:
Steve Jones - SSC Editor wrote:
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Yeah, I've trialed...
--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 10, 2020 at 2:15 pm

#3714359
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
jasona.work wrote:
also object level recovery from a .sqb file without needing to restore is cool (by the way - I don't work for Redgate - I just bug their...
--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 10, 2020 at 1:57 pm

#3714350
Reply To: Are the posted questions getting worse?

x wrote:
Steve Jones - SSC Editor wrote:
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Is Redgate backup able...
--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 10, 2020 at 1:52 pm

#3714348
Reply To: Creating Test Data

Steve Jones - SSC Editor wrote:
Things like CI need to be quick, so we want a limited data set.
Gosh... I absolutely cringe when I hear things like that. That's one of the reasons...
--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 10, 2020 at 6:50 am

#3714224
Reply To: Validating meta data of xls file

Eirikur Eiriksson wrote:
Jeff Moden wrote:
Getting kind of back on topic, has anyone tried the demo I provided?
I have, brilliant work my friend
😎
But as I'm ACE'phobic and I do not trust the black-box...
--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 10, 2020 at 5:55 am

#3714222

Viewing 15 posts - 7,906 through 7,920 (of 59,072 total)