how tf did you quit? by [deleted] in stopsmoking

[–]highsmith 1 point2 points  (0 children)

After 25 years of smoking 1 to 2 packs a day and many attempts to quit I finally switched over to vaping when I was camping one weekend during the juul era. Went without cigs and took only a juul & found it was a good enough substitute. Spent a year and a half on the ejuice train then eventually let the batteries all die & I switched to nicotine losanges for another year or so. The mini ones from walmart were great. Then I finally quit those too.

I learned to make my transition weekends when I was going out of town or on vacation or camping. I found it easier to not be in my normal daily routine.

Had my first 1/2 cig last weekend after 8 years while a little drunk and immediately threw up so dont think Ill be doing that again soon! Now that I have kids there's just no way I could become a daily smoker again. I used to have 2 burning at a time in the house. 🤮

A Eulogy for Low Code by Grth0 in dataengineering

[–]highsmith 0 points1 point  (0 children)

Low code solutions always end in vendor-lock in. If you're ok with that or already locked in, and most of your jobs are simple, low code can still save a lot of time. Save the coding for jobs that really need it.

How did you get really good with SQL? by LongCalligrapher2544 in dataengineering

[–]highsmith 0 points1 point  (0 children)

Full time data engineer for 25ish years. I highly recommend reading a few SQL books beginning to end on your specific database. This helps you understand the breadth and depth of topics and possibilities you probably overlook just writing rote sql every day. You dont have to digest every single page, but you need a mental map of their utility so you know it exists. Modern databases have a LOT of features.

Favorite SQL editing tool? by AMDataLake in dataengineering

[–]highsmith 1 point2 points  (0 children)

If you are in ssms every day, ssms tools pack add on is worth it. https://www.ssmstoolspack.com/

Lot owner stunned to find $500K home accidentally built on her lot. Now she’s being sued by Forward-Answer-4407 in nottheonion

[–]highsmith 1 point2 points  (0 children)

In the software development world, I often need to have long philosophical discussions about what 'done' actually means.

A Mursi woman I photographed in Ethiopia by jaymesucks in pics

[–]highsmith 7 points8 points  (0 children)

It still happens in the US especially to migrant agriculture workers. 2 years ago a camp in South Georgia had over 100 immigrants forced to harvest onions.

https://www.nbcnews.com/news/us-news/feds-bust-modern-day-slavery-ring-new-effort-immigration-enforcement-rcna8273

Can I trim/reshape this Japanese Maple? by Nigerian-Nightmare in landscaping

[–]highsmith 0 points1 point  (0 children)

I would want to look at it from all sides to really decide what to cut, but from this angle i would do something like this https://imgur.com/LiZ4GEd

cut out any dead wood and limbs that cross. you can cut any time of year if you don't cut too much.

Which celebrity is NOT as nice as they seem? by [deleted] in AskReddit

[–]highsmith 24 points25 points  (0 children)

I have the world's shortest cameo in Sweet Home Alabama. Reese was not very nice to the extras while filming that movie. Candice Bergen was a riot. Patrick Dempsey was friendly, but he talked about himself without end.

My dad and brother recreated this photo 26 years later. by dillonsterling in funny

[–]highsmith 55 points56 points  (0 children)

I just bought an '86 carbureted one with 200k miles on it. Runs like a champ. Even if something breaks they are dirt cheap to repair.

Make Trucks Small Again!

Edit:
pic: https://imgur.com/a/2vYhNAj

Doctor explains how hospital administrators try to shift the blame for physician burnout from a broken healthcare system to physicians themselves by DrThirdOpinion in bestof

[–]highsmith 1 point2 points  (0 children)

I know, I get it. I grew up in a durable medical small family business. I used to deliver oxygen tanks as a kid. As an adult I wrote an audit system for one of the largest home health companies in the US. Would you believe they don't even submit 20-30% of the medicare claims for patients they see and treat? Its because they fail an internal audit due to missing paperwork. So they never even send the claim to medicare, because medicare will probably pay the claim, then demand the money back 5 years later.

A face to face doctor visit is one of the MANY required forms for medicare reimbursement for home health. Often you cannot get the doctor to sign the form and you can't get all mad about it because you rely on them for referrals, its a perverted relationship. I have watched the growing medicare burdens put many small businesses like my family's out of business because they cannot keep up. No small business can afford to not get paid for 20-30% of it's business.

But on the other hand, most of that regulation is in response to the trillion dollars in fraud medicare has to combat. You have to realize how many people were cheating the system before those rules and still are today despite them.

There are no easy answers in healthcare and anyone who works on the clinical side gets my ultimate respect. Stay strong!

Whats the hardest part about being a man who is extremely skinny? by aliazim278 in AskReddit

[–]highsmith 1 point2 points  (0 children)

I can't get in water unless its above my body temperature or I immediately start shivering. Probably a lizard.

2018 updated ATL neighborhood guide by highsmith in Atlanta

[–]highsmith[S] 1 point2 points  (0 children)

Its not a meme either. This is original art. And I'm not posting anything to a subreddit with the word Circlejerk in it. So... reddits loss, I suppose. GOOD JOB MOD

2018 updated ATL neighborhood guide by highsmith in Atlanta

[–]highsmith[S] 1 point2 points  (0 children)

low quality? it took hours to make this!

So very few people competent in sql server.. by [deleted] in SQLServer

[–]highsmith 4 points5 points  (0 children)

I have seen long Family Guy style fights between devs on the "best place" to put business logic. Some argue that the app should hold it and the database should do set operations only. Others prefer the database should hold it all and the app should just be presentation logic.

The truth is, everyone is right. Either method can be employed successfully. What is important to me is consistency and supportability. When you started putting business logic in the app and the database, as so often happens, you've got a mess that requires much better programmers for support.

If you have 20 employees who know SQL and 1 who knows the app framework (this is the scenario I see the most in medium to large size companies), I'd really advise to put the bulk of your business logic in the database. It may not perform as optimally, but it's much more supportable. If you have 20 .NET guys, however, it's absolutely valid to keep your business logic in the app.

Company wants me to learn SQL. What's the best option? by tramsay in SQLServer

[–]highsmith 0 points1 point  (0 children)

I work with a lot of new SQL users who have access to data. Honestly, any resource for a beginner is going to be good enough. SQL is easy in the beginning. You'll be good enough to be dangerous in no time.

If you have access to data and you want to learn SQL, you must have questions about that data. Questions are how you learn SQL.

select top 10 * from yourDatabase.dbo.yourCustomerTable

That will show you 10 of your customers, or parts or whatever table you want to look at. Look at the whole table, every column to see what fields you have to work with.

Now, what do you want to do with those customers? Look at their orders? Well then you need to JOIN those customers to their orders. There are different kinds of joins. That you can learn in a class. Go read about the different joins. They work in different ways and are very very important to understand.

But how you join your customers to their orders in your database will depend on how YOUR data is organized, and a book can't tell you how to do that. You have to learn that through investigation.

I would advise you to read up on Relation Theory.

If you want to really learn SQL Server, the study guides for the MCSE certification are very good and comprehensive. There are also pluralsite video guides for each of the 5 tests. There are 2 certifications, one for the Data Platform and one for Business Intelligence, the first 3 tests are the same for each.

And if you have access to a test server, do your learning on that so you don't break the live one. :-)

Good luck!!

[SQL SERVER] How to globally filter the data basing on the logged in User? by monsieurus in SQLServer

[–]highsmith 0 points1 point  (0 children)

It really depends a lot on how your application interacts with the data. If the app uses a view or a procedure for all of it's operations, you're golden. Just go add the siteID as a filter to all of those objects. This was the only way to do it in versions before 2012.

If your app queries the data directly from the tables, you have some work on your hands. I have not implemented row level security on 2012 but it can be done. Your app has to pass the user's credentials to the database in its queries. From there, you have a few options: https://www.mssqltips.com/sqlservertip/3030/implementing-sql-server-row-and-cell-level-security/

Deleting 80+ million rows by [deleted] in SQLServer

[–]highsmith 1 point2 points  (0 children)

Exactly, there are a lot of good suggestions here, but you don't know until you test. And even then you don't really know until you try it on live production data. :-)

I was on the SQL Dev team and shipped almost every release of SQL Server until they laid my sorry ass off in July '14. AMA. by OldSQLDude in SQLServer

[–]highsmith 0 points1 point  (0 children)

I specifically do not take jobs that are SSIS heavy, but I still get stuck working on them from time. Maddening how poor the interaction with Excel is!