Monday, March 5, 2018

Get SQL columns with specified default value

Query to find all columns with specified default value:

SELECT SO.NAME AS "Table Name", SC.NAME AS "Column Name", SM.TEXT AS "Default Value" FROM dbo.sysobjects SO INNER JOIN dbo.syscolumns SC ON SO.id SC.id 
LEFT 
JOIN dbo.syscomments SM ON SC.cdefault SM.id  WHERE SO.xtype 'U' AND SM.TEXT = '[XXXXXXXXXXXXXX]' ORDER BY SO.[name]SC.colid 
 


Reference:
https://www.mssqltips.com/sqlservertip/1512/finding-and-listing-all-columns-in-a-sql-server-database-with-default-values/
- Option 1

Sunday, March 4, 2018

Scammish: TurboTax discount has not worked for multiple years

Every year and through different channels (Robinhood, Fidelity, StateFarm, etc.), the discount is never applied for me. The site states that you have to go through the affiliated site, which I do. Clear cache, clear cookies, restart browser, the whole same BS. If you go to their support page, it points to the same page or the suggested link is broken.

This year, I even tried all the data clearing and link clicking multiple times. From my personal recommendation, if you are trying out TT because of the discount... try another service. HR Block sounds like they have done a decent job catching up to TT. I may strongly consider them for next year.

There is even a user post that says he was told this problem is not common (https://ttlc.intuit.com/questions/3984616) (also assuming the link does not break or deleted). Yet, if you search online on "turbotax discount not working," you'll get a ton of pages over the span of several years.

A technology company that does provide codes nor allow agents to apply discounts. Users have been credited by affiliated site or on a single post by TurboTax. In the TT post, went through support which had them submit the form and was told he would be credited. Who knows if the credit was ever applied. Clearly, TT has no interest in making this any better.

Monday, January 29, 2018

Back to Running - 2018 - Day 1

I haven't ran on a treadmill since I sprained my ankle. I've "ran" while playing volleyball with no problems. I also did a lot of hiking over two weeks. I also haven't had any soreness in my ankle or foot.

So I was a little disappointed that I could still feel my ankle when I ran. It wasn't a pain or a sore, but I didn't want to push it so kept at a slow pace. On the bright side, the run felt a little easier than the last time. One reason may be that I lost about 10 pounds over my vacation (about how much I weight at the beginning of 2017).

My foot was a little sore the next morning only for a few minutes. It was a little sore when I tried running again the following night but was able to run it off.

A week later, I can still feel my ankle but less than the first day. I was also able to run a little faster and longer (from 5 minutes at 5 mph to 10 minutes at 5.5 mph).