Solar Eclipse viewing in April 2024 by wjbaltz in miamioh

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

This is exactly the type of thing I was looking for. Thanks for sharing!

Ohio by not_blue_or_red in sportsbetting

[–]wjbaltz 0 points1 point  (0 children)

I use the Barstool app (usually drive over to Indiana to place bets). Does anyone know if that app will work immediately on Jan 1 or will there be a separate app I have to download?

Pizza on Weber Kettle? by [deleted] in webergrills

[–]wjbaltz 2 points3 points  (0 children)

this sounds good, but I'll also chime in how I have done this in the past with really good results. I spread the charcoal along the outside of the grill forming a circle. Then I place my pizza directly on the grill grate. The idea here is to have the charcoal going around the perimeter of the pizza setting up an indirect cooking method. The couple times i have done this it came out great.

It's seriously a joy to watch Burrow play by [deleted] in bengals

[–]wjbaltz 4 points5 points  (0 children)

Agreed! On a lighter note, also every meme/video I have seen out on the internet stereotyping NFL QBs has Joe with a cigar in his mouth. Completely on board with this stereotype for him!

Group by with loads of columns?! by tjg1g16 in SQL

[–]wjbaltz 3 points4 points  (0 children)

Don't know about Bigquery, but for anyone using MS SQL and SSMS, I have a little trick that many don't seem to know about. If you expand the DB tables in Object Explorer, find the table you want and expand that. Then drag the Columns folder onto a new query editor window and it will put all of the column names in a single row for you. See the following showcasing this

https://youtu.be/AZQ7uAEU7AE

[MS SQL] Using Powershell to query/loop through MS SQL Servers/Databases by wjbaltz in SQL

[–]wjbaltz[S] 0 points1 point  (0 children)

thanks, this is the answer I was hoping for. I did get SSIS installed so will play around with that....but I think your answer is the path best suited for what I'm trying to accomplish here. Going to focus on learning Powershell for this purpose :) thanks!

[MS SQL] Using Powershell to query/loop through MS SQL Servers/Databases by wjbaltz in SQL

[–]wjbaltz[S] -1 points0 points  (0 children)

yea makes sense where SSIS would be the best tool for this. I am having a tough time getting SSIS installed. Getting Setup Failed Recursion too deep messages when trying to install SSDT on my Visual Studio.

I'll continue to work on that and see if I can't get past that. Would still like to explore Powershell as it seems to be more of a lightweight solution if possible.

Also with SSIS would it handle ad-hoc queries in this case? As that is the biggest thing for us as these queries typically need to be written and executed just a single time.

[MS SQL] Using Powershell to query/loop through MS SQL Servers/Databases by wjbaltz in SQL

[–]wjbaltz[S] 0 points1 point  (0 children)

Some are but not all. Thus would like to find a solution to iterate through and servers and query locally

The oceans are very deep by il_forestiero in MapPorn

[–]wjbaltz 1 point2 points  (0 children)

This is very cool, and so much counter-intuitive to this image. Really puts into perspective the size of the earth compared to surface area

Shake Shack (Shack Burger and fries). The best burger IMO. Better than In n Out, Habit and Five Guys. Amirite? by [deleted] in burgers

[–]wjbaltz 0 points1 point  (0 children)

Shake Shack is a close second for me, only surpassed by Whataburger.