Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,311 through 2,325 (of 59,086 total)

Reply To: Create graphic report showing databases backed up and success stats

Here's one more that shows some promise but it's not apparent as to whether or not it includes SQL Server backups.
https://www.bocada.com/product/backup-monitoring/

--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)

December 12, 2022 at 6:23 am

#4124500
Reply To: Create graphic report showing databases backed up and success stats

It's been a long time since I've looked at backup dashboards and monitoring software. All of the ones I've looked at in the last hour are pretty disappointing. LiteSpeed, which...
--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)

December 12, 2022 at 6:20 am

#4124499
Reply To: Create graphic report showing databases backed up and success stats

I believe that NetBackup actually provided the monitoring dashboard you speak of. What are you using for backups now? Are they SQL "native" backups or are you using some other...
--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)

December 12, 2022 at 4:32 am

#4124472
Reply To: Create graphic report showing databases backed up and success stats

got2be wrote:
A reply to my post was deleted as spam. My post was not marked as spam. I want the reports to show how many databases I’m backing up, time...
--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)

December 12, 2022 at 4:23 am

#4124465
Reply To: Create graphic report showing databases backed up and success stats

To be honest, you're post looks like a typical two part spam, the second part of which has already been deleted as spam.
Since you're new on this forum, if your...
--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)

December 11, 2022 at 11:32 pm

#4124416
Reply To: No PK on any tables - Need that to enable Change Tracking on SQL Server

cbarus wrote:
Thanks Michael. The issue is I don't want to touch the existing vendor DB. It is anyways out of support but it still works and we don't want 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)

December 11, 2022 at 9:23 pm

#4124403
Reply To: Blocking

As a bit of a sidebar, check out Adam Machanic's sp_WhoIsActive at the following link. Click on the "Documenation" tab and look for "blocking" on the next list of links. ...
--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)

December 10, 2022 at 9:11 pm

#4124213
Reply To: Poking the Bear

I value you as both a long-distance friend and a mentor so I'm not going to passive-aggressively insult you or gas-light you like you just have many of us. 😉
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)

December 10, 2022 at 2:43 am

#4123997
Reply To: Data Activity Tracking Using SQL Triggers

Hemandu Malhotra wrote:
Hi Jeff Moden,
Thank you for your response. I am not sure if I follow some of your concerns. Yes, this is an old method and we have customized 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)

December 9, 2022 at 10:15 pm

#4123940
Reply To: Data Activity Tracking Using SQL Triggers

I have a grand appreciation for anyone that steps up to the plate with an article.
Shifting gears to the subject at hand, this is an old method that was written...
--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)

December 9, 2022 at 5:52 pm

#4123890
Reply To: The Temp Alias

And you should see what happens when you drop the table! 😀
--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)

December 9, 2022 at 5:23 am

#4123666
Reply To: record loading

Bruin wrote:
Sorry Jeff.
I have been working with open query trying to get the values I need for my Insert into Staging Table. The query I have is returning 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)

December 8, 2022 at 9:57 pm

#4123552
Reply To: Either/ Or Query

homebrew01 wrote:
Jeff Moden wrote:
Heh... I've been having issues with caffeine absorption lately. 😀
Too much ? Or not enough ?

Both, actually. Too much in the morning and too little in afternoon/evening, 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)

December 8, 2022 at 5:16 pm

#4123491
Reply To: record loading

Gosh, Bruin... how do you expect anyone to help with such little information?
--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)

December 8, 2022 at 5:14 pm

#4123490
Reply To: Retrieve Password from CyberArk using powershell

Ross McMicken wrote:
Jeff Moden wrote:
frederico_fonseca wrote:
Jeff Moden wrote:
I don't know about CyberArk but I would hope that getting a Password for an SQL Service Account couldn't actually be done in such an easy...
--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)

December 8, 2022 at 2:20 am

#4123182

Viewing 15 posts - 2,311 through 2,325 (of 59,086 total)