Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,766 through 15,780 (of 59,098 total)

RE: Merge multiple .sql files into one single file

lewisdow123 90045 - Wednesday, February 1, 2017 4:42 PM
Hi,
Does anyone have a program or utility that can merge multiple .sql files in...
--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)

February 1, 2017 at 8:04 pm

#1926236
RE: Any way to guesstimate internet needs for remote DBA?

I'm just curious... if you normally have the "unlimited" and "high speed" thing, why is it that you will have less than that for a period of time? Hopefully, it...
--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)

February 1, 2017 at 8:01 pm

#1926235
RE: The New DBA is a Developer

Steve Jones - SSC Editor - Wednesday, February 1, 2017 5:59 PM
Jeff, that's just not true.
It was not a scripting issue. It...
--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)

February 1, 2017 at 7:44 pm

#1926233
RE: The New DBA is a Developer

This is just poor administration, regardless of job title.
Databases don't just live in SQL Server. Just like job titles, databases come in many forms. And "Just poor...
--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)

February 1, 2017 at 5:18 pm

#1926220
RE: Are the posted questions getting worse?

Koen Verbeeck - Wednesday, February 1, 2017 3:03 PM
Happy, delighted, humbled and overall gleeful to announce that I'm awarded the Microsoft Data...
--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)

February 1, 2017 at 4:04 pm

#1926212
RE: Multithreading to upload .bak files in parallel to S3 storage using PowerShell

lsalih - Wednesday, February 1, 2017 12:36 PM
Greetings -
I wrote below PS to upload my backup files from local machine to AWS...
--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)

February 1, 2017 at 2:47 pm

#1926205
RE: Linking a Database to its Backup Schedule on a SQL Server

Paresh Motiwala - Wednesday, February 1, 2017 10:55 AM
Jeff Moden - Wednesday, February 1, 2017 10:50 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)

February 1, 2017 at 1:26 pm

#1926193
RE: Byte Me: Avoiding Detection

Eric M Russell - Wednesday, February 1, 2017 6:11 AM
Maybe I'm missing something.
First, why would the PM wander into the server...
--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)

February 1, 2017 at 10:58 am

#1926155
RE: Linking a Database to its Backup Schedule on a SQL Server

Paresh Motiwala - Wednesday, February 1, 2017 10:35 AM
folks
I am wondering if we can find, using a sql script, when a 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)

February 1, 2017 at 10:50 am

#1926153
RE: The New DBA is a Developer

Eric M Russell - Wednesday, February 1, 2017 8:35 AM
Jeff Moden - Wednesday, February 1, 2017 7:43...
--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)

February 1, 2017 at 10:17 am

#1926144
RE: Urgent Career Advice Required

Can anyone let me know the status and the vacancies of DBA jobs available in Canada?
You obviously have an internet connection... hit up on some of...
--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)

February 1, 2017 at 8:18 am

#1926102
RE: The New DBA is a Developer

Heh... here's what happens when you have people that know how to script without being a DBA.
http://www.theregister.co.uk/2017/02/01/gitlab_data_loss/
Although I've not taken the time to confirm 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)

February 1, 2017 at 7:43 am

#1926085
RE: The New DBA is a Developer

David.Poole - Tuesday, January 31, 2017 12:21 PM
I loved the stack overflow cartoon https://static1.squarespace.com/static/518f5d62e4b075248d6a3f90/t/583aa5b1bebafb6551322268/1480238530975/?format=750w
These days a technical estate can be so diverse...
--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 31, 2017 at 11:01 pm

#1926001
RE: The New DBA is a Developer

David.Poole - Tuesday, January 31, 2017 12:21 PM
I loved the stack overflow cartoon https://static1.squarespace.com/static/518f5d62e4b075248d6a3f90/t/583aa5b1bebafb6551322268/1480238530975/?format=750w
These days a technical estate can be so diverse...
--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 31, 2017 at 10:48 pm

#1926000
RE: The New DBA is a Developer

I don't believe I am splitting hairs. The article clearly stated that you have DBAs that can do scripting and DBAs that don't who are not as efficient. That's patently...
--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 31, 2017 at 10:32 pm

#1925997

Viewing 15 posts - 15,766 through 15,780 (of 59,098 total)