Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,736 through 15,750 (of 59,063 total)

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
RE: Loading Non Duplicated Data Using SSIS

Shifting gears a bit, I wouldn't use SSIS for any of this other than maybe a process controller. Between things like WITH IGNORE DUPLICATES as a part of an index...
--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 9:56 pm

#1925993
RE: Finding Within dates

Suth - Friday, January 27, 2017 4:31 AM
Hi
Im new to sql and I have a date column created , I'm...
--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 9:51 pm

#1925992
RE: Finding Within dates

Thom A - Friday, January 27, 2017 5:19 AM
CREATE TABLE #Date (DateColumn DATE)
GO
INSERT INTO #Date
SELECT '01-Jan-2017';
GO
SELECT CASE WHEN DateColumn...
--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 9:41 pm

#1925991
RE: DUPLICATING A ROW BY NUMBER OF OCCURENCE OF A PARTICULAR FIELD IN ANOTHER TABLE

JALLY - Tuesday, January 31, 2017 4:09 PM
drew.allen - Tuesday, January 31, 2017 3:55 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 31, 2017 at 9:32 pm

#1925989
RE: FAQ: Using the new forum Software (Jan 2017)

xsevensinzx - Friday, January 13, 2017 10:59 PM
All I want to know is how in the world did Jeff get his gif...
--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 9:26 pm

#1925988

Viewing 15 posts - 15,736 through 15,750 (of 59,063 total)