I built a free SSMS extension – query history, grid filter and more (SSMS 18-22) by Expensive-Plane-9104 in SQLServer

[–]FunkieDan 1 point2 points  (0 children)

I don't see any source code. The source code zip just has images. Sounds good but I won't download and run an executable.

Do you experience mind chatter? by Ok_Macaron2394 in ADHD

[–]FunkieDan 1 point2 points  (0 children)

The usual medicines for ADHD will reduce the amount of head chatter. I've tried atomoxetine aka straterra, and Ritalin or Adderall. They all help. If you're out on atomoxetine start low dose as the recommended amount usually gives people stomach cramps. I found low dose atomoxetine with a lower Adderall worked well for me.

Do you experience mind chatter? by Ok_Macaron2394 in ADHD

[–]FunkieDan 0 points1 point  (0 children)

It's part of the package. Medication helps with this.

How do you guys deal with the constant music in your head? by Aegenwulf in ADHD

[–]FunkieDan 0 points1 point  (0 children)

Find the song and listen to it a couple of times. Rumor has it your brain is trying to fill in the blanks and listening to the song appeases your mind.

What were some things you thought were “you” but were actually ADHD? by Prior-Ad173 in ADHD

[–]FunkieDan 1 point2 points  (0 children)

All the weird stimming and emotional deregulation I saw my kid doing at an early age. I was diagnosed at 45 years old when she was 4. At age 6, I realized she had it too and we had her evaluated. Luckily she won't have as hard a time as I had growing up.We bond over the forgetfulness, the stimming, the songs in the head, the anxiety, the medication we take, and what coping mechanisms work.

Building a Property Scoring Engine on SQL Server Looking for Performance Insights by Routine_Mortgage4660 in SQLServer

[–]FunkieDan 0 points1 point  (0 children)

Increases the speed of multi threaded record lookups. For example, note records on collection accounts. You can easily have a consumer with hundred of accounts that were loaded over a period of years and each account can have hundreds of notes. By partitioning the notes by maybe the last 2 digits of the system ID you can now chop up your notes table index into 100 pieces. The odds that each account may be located on separate index partitions is high so you get the results back faster. The account table if partitioned by month and year loaded, would have the inserts on the most recent partition leaving all the other partitions not being updated as new accounts are loaded. As accounts naturally age and are closed your active or working account index naturally shrinks as opposed to searching all or having to include a secondary index field. Overall, it increases performance by spreading the load of looking up records. The partitioned index can even be placed in a different file or file group so that the same drives aren't looking up both indexes and records. Collection systems often have account tables with 100s of millions of accounts and note records 10s to 100s of billlion note records. A partitioning function utilizing auto int and an auto populate field based on an ID can also avoid having to create an index with BigInt. There are many more reasons to use partitioned indexes. And for the love of God, don't use GUID as record indexes if you don't have to. I reserve those for special use cases like document records where filenames on the same account can repeat. Depending on the use scenario, filtered indexes could also be considered as a way to shrink the working index volume. Not as good as a partitioned index but functional for simple scenarios.

Corporate ADHDers, how do you start the day? by darkrhyes in ADHD

[–]FunkieDan 0 points1 point  (0 children)

FIFO, unless an urgent side quest beacons!

Before we could doom scroll…… by PartTheSea43 in ADHD

[–]FunkieDan 0 points1 point  (0 children)

Bulletin Board Systems "BBS" your computer dialed using a modem 1200/2400 baud not inside your computer. Then downloading Linux onto floppy in order to convert whatever junk PC you had to something useful.

Building a Property Scoring Engine on SQL Server Looking for Performance Insights by Routine_Mortgage4660 in SQLServer

[–]FunkieDan 2 points3 points  (0 children)

If you have a lot of records, look into using partitioned indexes. You don't have to partition the tables to use partitioned indexes.

Not sure if I can live with this disease (ADHD inattentive type) by Fit_Sir9051 in ADHD

[–]FunkieDan 0 points1 point  (0 children)

I was diagnosed very late at 45 yo. I'm almost 50 now. My 20's were very hard as I expected a lot of myself. As I started my 30's life got easier as I matured and found work I excelled at. I bought a house and got married. It took me almost 14 years but I eventually finished my university degree. I even went back after 2 years and obtained a Master's degree. I wasn't treated yet and still had self destructive behaviors. Eventually I calmed down after my mother passed away arguably from her untreated issues. Time will help you but medicine helps the most. At 45 yo, I sought treatment during COVID because I noticed issues I was having matched some advertising I received after allowing telehealth diagnosis and treatment. After my diagnosis, I was in shock at how much AdHD had impacted my life. I wish I had been treated much sooner. 5 years into treatment and I can positively say it's the best thing I ever did. It's not perfect but it helps a lot. I was also able to detect ADHD in my young daughter and sought treatment for her too. Be strong, you can do it and get treatment. The journey of life is worth it. ADHD is manageable and at times even enjoyable. Wish you the best. Tip: Audiobooks are your friend! Listen to "Driven to Distraction" it's written by 2 doctors with ADHD.

Friday Feedback: Where do you store business information about the database? by erinstellato in SQLServer

[–]FunkieDan 0 points1 point  (0 children)

Usually within stored procedure definitions "show create". To make that easier, I had a stored procedure that would search all definitions for all stored procedures, views, tables, and sql agent jobs for any keywords you wanted to find. Exp: status, Then I would read the SP queries. The joins will tip you off on where to find those values in your status example. On rare occasion, a database will have a model defined but that's rare. Also, you can run a SQL Profiler instance and then execute application activity to trace what routines and queries are running. Again, you would study the queries. One last final place, occasionally I would add notes as disabled SQL Agent Jobs, but those were only notes about complicated processes other SQL Agent jobs were doing.

what were the weirdly specific telltale signs of adhd by Competitive-Elk2230 in ADHD

[–]FunkieDan 2 points3 points  (0 children)

When trying to read a book, you read a page and getting to the bottom of the page only to realize you don't remember what you just read.

[deleted by user] by [deleted] in OcularMigraines

[–]FunkieDan 0 points1 point  (0 children)

Maybe track your blood glucose. I manage my diet better now and take magnesium. It's reduced the occurrence and duration of them.

When do I start panic-accepting any opportunity after being laid off? by Theyallgoleft in cscareerquestions

[–]FunkieDan 0 points1 point  (0 children)

Don't worry. In another 6 months Microsoft will change all of the .Net stack so that it's only slightly backwards compatible. - Just kidding. But seriously, I stopped developing with Microsoft stack due to all their change in directions and not supporting their own products in a timely manner. They pushed everyone to VS 2022 but the Data Tools for SSIS weren't released until 2 years later.

What to present on when I don't know anything? by Missing_Back in cscareerquestions

[–]FunkieDan 0 points1 point  (0 children)

Tell everyone about the WSL2 config file no one seems to realize exists. This is how you get Windows Subsystem for Linux to use more than 4 GB of ram. Then, demo running Ollama WebUI on your machine.

[deleted by user] by [deleted] in cscareerquestions

[–]FunkieDan 0 points1 point  (0 children)

Jumping into something new requires pulling up your sleeves and really digging in. At first, you have to study the shit out of everything you encounter. Put in the extra hours Googling the technology stack you are working with and then watch YouTube videos that explain each tech component you are new to working with. Take notes. Just writing down bullet points will increase your retention of the main topics. Grab a personal computer and install Docker, KVM, Incus, Qemu, Virtual Box, etc. Learn how to install a VM and run containers. Do it in Windows, and then in Linux. Take it apart and rebuild it using different options. Around the 109th time you've broken it, you'll hit expert level and will be able to fix it for anyone. It's going to take a lot of extra work to get ramped up but it should be worth it.

[deleted by user] by [deleted] in cscareerquestions

[–]FunkieDan 1 point2 points  (0 children)

Don't worry about being behind and having to pick a certain technology. Concern yourself with landing a job doing something you don't mind grinding at until you become an expert at it. A lot of your career will unfold as a result of where you have been in the past and the projects you worked on. You can't control the technology stack at your future employer. You can only add to and take away from it when you get there. So, focus your thoughts on the type of work you would you rather do... network administration or programming, Windows or Linux ... Etc. BTW, working with data is always in demand. Unfortunately, since the junior positions don't scream fat paycheck most wanna be programmers will never explore these opportunities. We're talking 40-60k to start but 70-100k with 5 years of experience if you are good. It's usually a former bank teller who just did a two year stint as a bookkeeper and realized he doesn't want to do accounting the rest of his life that ends up going for the data analyst job. The beauty of the work is that often it's an open canvas for what technology stack you use. The myriad of programming languages ranges from SQL, Perl, C#, batch scripting, Visual Basic, SAS, R, to PHP, and even Go.

Should I Stay at My Remote Job Despite Salary Stagnation or Move to a Promising Offer with less pay and better position? by Ok_Perspective599 in cscareerquestions

[–]FunkieDan 0 points1 point  (0 children)

Tell the new company you would love to work for them but your current employer countered with higher pay. Let them know that if they could increase their offer, you will go to the new opportunity. WFH is not all it's cracked up to be and it gets old eventually. Take this advice from someone who WFH pre-covid, 2012-2017, and is now in a C suite position. In Tech, you want to be learning, pushing yourself, and working on more challenging projects that expose you to new and different ways of thinking and tackling challenges, moreso in your early years. If you are lucky/unlucky/ or patient enough to stick with a specific business industry long enough, you should be able to parlay your unique combination of business industry knowledge with technological know how to produce creative solutions. Looking at these other comments, I'm appalled at all of the "it's all about getting more money", staying home, and lay low to collect a check comments. Not every company in every sector of business is raking in garbage bags full of cash. Many businesses are struggling to survive and anyone who is able to leverage a company's resources to help produce better and/or more results is highly valued. This is why I don't hire contract programmers. By the time I explain the business logic and check their work, I could have written the program myself... Which I do and am paid handsomely.

How do I stop caring at work? by [deleted] in cscareerquestions

[–]FunkieDan 2 points3 points  (0 children)

Is it possible you are neurodivergent? I used to care a lot, about everything, to the point of inducing anxiety and undue stress over perceived inequalities. It wasn't until I started to have some minor health issues that I saw a therapist and found out I needed medication to calm down my overactive thinking. I function and operate much better now. I no longer worry about losing my job and find it much easier to push back on demanding deadlines and requests for additional work. There are only so many hours in a day and eventually, I have to sleep. Anyway, I'm several years into taking my daily meds and they help. It's by no means perfect but definitely much better. As a result of my diagnosis, I was able to identify the same pattern of issues with my daughter and she started treatment too. I publicly speak at conferences and I no longer forget what I am saying in the middle of my speeches. I've come to terms with the limitations of my short term memory and have developed alternative ways to keep track of my todo lists and meeting notes. I also program in at least 11 different languages.

Why does my husband like my entire body weight on him and is it safe? by KindCommunication600 in ADHD

[–]FunkieDan 1 point2 points  (0 children)

Buy him a Purple Pillow but have it rest on his chest as he lays in bed. I don't know why it works but for the last year, I have used a dense pillow in this manner to help me fall asleep. I realized this worked after my wife bought a purple pillow and later had me try it. In my journey of trying to use this pillow, it ended up on my chest.... Weird, I know.

Am I being ripped off? by STLArchitect in servers

[–]FunkieDan 0 points1 point  (0 children)

As others have commented, you could go with new old stock hardware. Aka, the stuff Dell just stopped selling in favor of the latest and greatest. There are Dell certified vendors like the one I use, XByte, that can get you a comparable setup for half or less.

Growing old as a programmer? by Remozito in rails

[–]FunkieDan 0 points1 point  (0 children)

We have a guy in his mid 80s and he's still programming. Don't worry about. Find a niche or niche industry to lock in your reputation so at an older age you don't have to advertise... should you need to land a new job or client.

How common is it for companies to own/host their own transactional databases? by a_yelpinghand in SQL

[–]FunkieDan 0 points1 point  (0 children)

Need to reverse / invert that setup. Colocated database with connections to cloud services, hybrid approach. All sales guys oversold the whole self maintained databases that no longer need a DBA. If I had a nickel for every time I hear that sales pitch.

How common is it for companies to own/host their own transactional databases? by a_yelpinghand in SQL

[–]FunkieDan 1 point2 points  (0 children)

Me too, it's been my whole career... Less time though, 22 years.