SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Remember the Simple Things


Remember the Simple Things

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)SSC Guru (602K reputation)

Group: Administrators
Points: 602364 Visits: 21101
Comments posted to this topic are about the item Remember the Simple Things

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)SSC Guru (870K reputation)

Group: General Forum Members
Points: 870360 Visits: 47424
I wish people would remember the simple things when they're writing code. To me, the "KISS" method is "Keep It Super Simple".

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
call.copse
call.copse
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14116 Visits: 2410
I often have to go a bit Zen with this. I see some super cool trendy solution that uses something esoteric to achieve an end and I have to be, "That's lovely, we can leave it like that, but perhaps it would be clearer for others if you just..."

Still, I'm a simple man and like simple things. Guess it's experience, not that I don't get that wrong still occasionally.
djackson 22568
djackson 22568
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9734 Visits: 1298
Every year for Black Friday a particular retailer, with a slogan about being easy, offers label makers for about $10-$20. Since buying one a few years back, I label every cable that comes with any product. Well, not my Apple products of course. Then I can quickly tell which cable is for what device. It has reduced the issues you encountered.

I still get issues where microsoft products simply refuse to work as they should, resulting in flash drives not showing up, removable Western Digital drives not showing up, drives just disappearing for no reason... Usually I can fix those by obtaining non-microsoft drivers.

That said, I have a mental list of things to do before vacations and such, and making sure the memory cards are empty is one such task. For my camera, i make sure that I empty it after every event I tape. If I could only get my kids to play nice, and empty the camera SD cards when they take my camera to shoot pictures...

Dave
Mark Tarquini
Mark Tarquini
SSC-Addicted
SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)SSC-Addicted (439 reputation)

Group: General Forum Members
Points: 439 Visits: 198
This read made my day. Love the comment about troubleshooting printers!

-Mark

MS-SQL 2016 Enterprise, Azure Hosted.
Techie/Sysadmin by trade; completely new to T-SQL. I hardly call myself a DBA. Ive got a lot to learn and doing my best.
djackson 22568
djackson 22568
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9734 Visits: 1298
Jeff Moden - Saturday, October 6, 2018 8:12 PM
I wish people would remember the simple things when they're writing code. To me, the "KISS" method is "Keep It Super Simple".
Great way to think about it. I can't tell you how much code I have had to rewrite because someone felt making it as tight as possible was better than being readable, or accurate.


Dave
Matt Miller (4)
Matt Miller (4)
SSC Guru
SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)

Group: General Forum Members
Points: 111227 Visits: 21706
I love this advice - just wish we had seen this one sooner Smile

Last weekend our biggest deployment in 10 years (we were deploying a brand new enterprise billing system + full financial history migration) almost got derailed because.... we forgot to double check that the production version of SQL Server on a critical component of our architecture was at the same version as QA. The update procedures just flat refused to compile, until we figured out that the production edition was still 2008R2, and the code required 2014+. It didn't take too long to work around the issue once we understood what caused it, but we did spin a little...

I am grateful to report we did finish the job and the new system is stable at this point.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
mercurej
mercurej
SSC-Addicted
SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)

Group: General Forum Members
Points: 463 Visits: 172
How often I have wished user would think of the simple things first.

The most glaring example comes from the days I wasn't just a developer but also IT support and a system admin. I get a call from a user who said the printer wasn't working. I walk to the other side of the building, take one look at printer, open the paper tray and load it!! She never checked the paper. Crazy

The funny part is about 10 years later, 19 years ago next month, I married her!! Smile
IowaDave
IowaDave
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1327 Visits: 643

Steve, I feel your pain and have been through almost the exact same issues - getting photos from phone to computer, transferring data between old and new tablets, etc. It's amazing all the different cords there are. Ermm

The latest "interesting" hardware issue I've run into is with SD card readers. I put trail cameras up in the woods and I wanted a quick way to be able to view the images off the cards right on my phone while in the woods. I bought one and it just plain didn't work - Nothing. (In order to get a refund, I had to upload a video showing it didn't work - and they wanted it under 5MB - that was a challenge!) On a second one, I had the USB-C plug break off in my phone. And what I've noticed about both of the ones that I've gotten to work is that my phone instantly writes TO them instead of reading FROM them. I get some "default phone path" directories on the SD cards. (What I don't know is if it's ever over-written the pictures that my cameras have taken?!?!?) To protect myself now, I always "lock" the SD cards before I insert them. Wink


jasona.work
jasona.work
SSC-Forever
SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)

Group: General Forum Members
Points: 43512 Visits: 16400
Oh so very many stories that can relate to this...

Recently I had the exact same issue as the article mentioned. The wife and I were trying to get photos off her phone to our NAS and the bloody phone WOULD NOT show up. It was the same problem as Steve ran into, I was using some random cable I grabbed, once I pulled the one that came with the phone, voila, there's the phone...

Back in my help desk days, my mantra was always "start with the basics," because more times than not something basic was the problem.
Favorite memory? A customer had a laser printer that would not print. No errors, no warnings, it would feed the paper through, but nothing printed. They had just replaced the toner cartridge that day, as well. So, I had them pull the toner, and lo and behold, the bright orange tab that had to be pulled off (pulling out the strip that sealed the cartridge out with it) was still attached. Once they pulled it, everything was working fine.

Of course, I've caught myself skipping checking the basics sometimes, and it almost always comes back and bites me, because it *does* turn out to be something basic that I skipped checking, because "there's no way *that's* the problem."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search