Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,511 through 9,525 (of 59,099 total)

Reply To: DBA for future

Didn't say that PowerShell was going to hurt abilities in T-SQL. The problem is that a whole lot of people are using PowerShell instead of T-SQL to do things 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)

April 5, 2019 at 2:53 am

#2828958
Reply To: DBA for future

lsalih wrote:
Grant, well said... Having worked with cloud and SQL DBA work, I found learning Powershell is a must. Anyone deals with cloud and managing different flavors of RDMS needs...
--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)

April 4, 2019 at 8:50 pm

#2807688
Reply To: Unable to send email

LearningDBA wrote:
It's working now.
So tell us how and why please...
--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)

April 4, 2019 at 4:39 pm

#2788724
Reply To: Quoting posts with Line breaks

Steve Jones - SSC Editor wrote:
This appears to be working now. The quote items are a permissions issue, as we work on what we allow/don't by non moderators.
Cool... That and the names appear instead...
--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)

April 4, 2019 at 4:21 pm

#2787502
Reply To: Links in earlier posts not working

Any word on fixing links? Hits on Google and Bing are dropping like flies.

I'm no front-end expert by any means but here's a thought for a possible fix. Rumor has...
--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)

April 4, 2019 at 12:15 am

#2729368
Reply To: db owner best practice

I would make one that reports when the owner is something else but I'm not sure I'd make one do an auto-change. You just can't tell when that could break...
--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)

April 3, 2019 at 10:24 pm

#2723314
Reply To: DBA for future

No... automating things that a DBA does will NOT "automate you out of a job". On the contrary... it will make you even more valuable because you'll have time to...
--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)

April 3, 2019 at 6:11 pm

#2704786
Reply To: Please revert to old site or prevent new content until data loss issues resolved

That and many internal, Google, and hardcoded blog links throughout the world are now broken.
--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)

April 3, 2019 at 4:47 pm

#2699433
Reply To: Ability to delete your own replies and posts that have no replies

They only allowed such a thing for certain people and only on certain forums. I believe the reason for that was that some OPs would delete their original and 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)

April 3, 2019 at 2:52 pm

#2690874
Reply To: Bankers Rounding

Globalleads wrote:
There is certainly a lot to find out about this subject. I really like all the points you made!
Man, quit spamming and get a real job. Just because it's...
--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)

April 3, 2019 at 1:33 pm

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

Robert Chipperfield (Redgate) wrote:
Jeff Moden wrote:
It looks like profiles work again as do the PM messages.
Sorry folks - some rewrite rule badness happened. Should be fixed now (along with followers / following...
--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)

April 3, 2019 at 1:29 pm

#2685052
Reply To: DBA for future

rolltheballaz wrote:
The article is really nice and interesting. I have searched for this type of information and would love to read this information. I hope you will share more useful...
--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)

April 3, 2019 at 4:38 am

#2574883
Reply To: DBA for future

I can't answer your questions but I will offer a bit of advice... remember the phrase "Jack of all trades and Master of NONE" when it comes to databases. Yes,...
--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)

April 2, 2019 at 11:44 pm

#2562319
Reply To: Create another System Admin when password unknown

As a bit of a sidebar, it's a real and very serious security issue for applications to have "sysadmin" privs, never mind using the "SA" login. I strongly recommend a...
--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)

April 2, 2019 at 10:31 pm

#2557154
Reply To: There is insufficient system memory in resource pool 'internal' to run this...

DataAnalyst011 wrote:
...and we're back online.
The fix was to stop Agent and set the service to manual. Then we entered -f as a startup parameter for engine in configuration manager. After...
--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)

April 2, 2019 at 10:24 pm

#2556464

Viewing 15 posts - 9,511 through 9,525 (of 59,099 total)