Are the posted questions getting worse?
- Jeff Moden wrote:
Ok...
Luis Cazares wrote:I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising permissions. Yesterday he emailed to notify that the process had been implemented. Today, when I'm looking for the table and can't find it, I ask him for it. He just created it on production and offered to copy it whenever I need it. I ASKED FOR THE TABLE TO AVOID HAVING TO REQUEST IT EVERY SINGLE TIME! I'm really not sure how I should reply to him.
How often did you ask for it previously?
I didn't ask for it before, but I know that other people had asked multiple times and I was being proactive as they came to me to get the information this time.
- Brandie Tarvin wrote:
Not only would I follow that advice, but I'd have that discussion in person then follow up with a bulleted email of the "requirements" discussed, asking for the DBA to respond with verification via email once the task had been completed. This way, everything is also in writing for if / when the DBA either fails to understand or something else comes up regarding this project.
I like this as a response. Set up a list of items to make it clear what you expect, since somewhere communication broke down. If that doesn't work, I'd likely learn to automate a daily email to the ticketing system asking for a copy. Hopefully after a week, the production people would just set up an automated task.
-
As an FYI, asking for replication to be implemented is a large change, especially with the potential issues of coupling with log backups in the future. More, I would ask for a daily export with some mail/file share drop for the data and then a potential ETL/import elsewhere, or just have daily files that the devs can grab.
-
Just noticed that in SSMS 2018 there's a little Tux (the Penguin) next the database icon now if you connect to SQL Server on Linux. Not really sure it was a needed update, but it did bring a little smile to me when I noticed it earlier.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk - Thom A wrote:
Just noticed that in SSMS 2018 there's a little Tux (the Penguin) next the database icon in now if you connect to SQL Server on Linux. Not really sure it was a needed update, but it did bring a little smile to me when I noticed it earlier.
That's adorable!
-
Well here's a fun little tidbit for you: https://www.bleepingcomputer.com/news/security/nansh0u-miner-attack-infects-50k-ms-sql-phpmyadmin-servers/
Your SQL Server might be involved in mining a crypto-coin! Of course, it also sounds like you need to be rather poor at even basic security and have your SQL Server hanging out on the internet in its' underwear to get infected, but still...
- Steve Jones - SSC Editor wrote:Brandie Tarvin wrote:
Not only would I follow that advice, but I'd have that discussion in person then follow up with a bulleted email of the "requirements" discussed, asking for the DBA to respond with verification via email once the task had been completed. This way, everything is also in writing for if / when the DBA either fails to understand or something else comes up regarding this project.
I like this as a response. Set up a list of items to make it clear what you expect, since somewhere communication broke down. If that doesn't work, I'd likely learn to automate a daily email to the ticketing system asking for a copy. Hopefully after a week, the production people would just set up an automated task.
It's a real shame that we need to do such things but I generally subscribe to the idea of NVO and NVR (No Verbal Orders and No Verbal Responses). I do make exceptions to that with some of the folks I work with but it adds great clarity even with them just to prevent misunderstandings. Helps make it easier to get right the first 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) -
Some people are of the opinion that if you have to go back and forth a few times in email then you are better off picking up the phone or going in person to someone's desk. I am decidedly not of that opinion. If I am forced to do something like that, I send a follow up email saying "per our conversation", so I still have a paper trail.
Last week I had to explain to someone why "no records are missing" was not understood to mean "no, records are missing". (to hell with the punctuation! Full speed ahead!)
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses - jonathan.crawford wrote:
Some people are of the opinion that if you have to go back and forth a few times in email then you are better off picking up the phone or going in person to someone's desk. I am decidedly not of that opinion. If I am forced to do something like that, I send a follow up email saying "per our conversation", so I still have a paper trail. Last week I had to explain to someone why "no records are missing" was not understood to mean "no, records are missing". (to hell with the punctuation! Full speed ahead!)
Totally agreed. The art of communication, especially in short emails, is paramount.
--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) -
I have a bit of bittersweet news. After more than a decade of coaching youth soccer I am finally hanging up the whistle (although I never actually use one in practice). My son's team fell apart and he is going to try out for one of the large local clubs. I am not at all concerned for him as he is a great athlete and always lands on his feet. Ending my coaching career is the second major commitment I have been able to step down from in the last year.
The other was stepping down as cubmaster for cubscouts at the beginning of 2019. I held that role for 9 years. I am still mentoring and helping the new cubmaster (and an entirely new committee) as my son still has another year until he crosses over to boy scouts.
I am still coaching baseball over the summer and likely basketball in the winter but my schedule is finally starting to have some holes. I am planning on spending many hours trying to uncover my woodshop which has been neglected for several years now. I am also thinking I may finally be able to start knocking out some of the bigger projects on my "honey do" list.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Sorry to hear that your son's team fell through, but seems that he's on the right path and trying out for a new team. Good luck to him and I hope he does well.
Sean Lange wrote:I am planning on spending many hours trying to uncover my woodshop which has been neglected for several years now. I am also thinking I may finally be able to start knocking out some of the bigger projects on my "honey do" list.
I assume the first thing you'll be creating is a fully functional porkchop launcher?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Thanks Thom.
Thom A wrote:I assume the first thing you'll be creating is a fully functional porkchop launcher?
Yes indeed!!! I believe I still have the design specs from Jeff somewhere. 🙂
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ - Sean Lange wrote:
Thanks Thom.
Thom A wrote:I assume the first thing you'll be creating is a fully functional porkchop launcher?
Yes indeed!!! I believe I still have the design specs from Jeff somewhere. 🙂
If you don't, I'm sure he'll be happy to send you the specs for any one of the models. From the X-1000 all the way up to the fighter-jet mounted monster. I'm still waiting for the one based on the rail gun to come out. 🙂
- Ed Wagner wrote:Sean Lange wrote:
Thanks Thom.
Thom A wrote:I assume the first thing you'll be creating is a fully functional porkchop launcher?
Yes indeed!!! I believe I still have the design specs from Jeff somewhere. 🙂
If you don't, I'm sure he'll be happy to send you the specs for any one of the models. From the X-1000 all the way up to the fighter-jet mounted monster. I'm still waiting for the one based on the rail gun to come out. 🙂
I was going to build the trailer hitch mounted version. Works great for those pesky tailgaters.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
When I came back from Afghanistan four years ago I found myself winding down my officiating soccer. Partly because I coached a U18 girls competitive team in the Fall of 2015. But one of the things I have found after finally stopping officiating that I miss getting on the pitch with kids, but I don't miss the drama from the sidelines. You may find the same thing, you'll missing working with the kids but not dealing with the parents.
Have fun in the workshop. I would still like to get out there and meet you. Perhaps the next SQL Saturday in your area.
I still have a lot to do here taking care of my dad's estate. Taking longer than I would like just going through every in the house.
Viewing 15 posts - 63,646 through 63,660 (of 66,549 total)
You must be logged in to reply to this topic. Login to reply