Friday, January 26, 2018

SSMS (SQL Server Management Studio) I ain't got time for all that...

Command-line SQL has always been easy, I have been writing sql in DOS like this from way back in the day.

sqlcmd -Q "SELECT * FROM [Your].[Moms] WHERE you = 'At school'" -o Milf.txt

But when you mix Powershell and SQL you can be more productive and creative.
$hos = Invoke-Sqlcmd -Query "Select * From [Your].[Family]"
ForEach ($ho in $hos){
if($ho.Name -eq "your mom"){
$script = "Update [Your].[Family] Set Status = 'Worn out' Where id = $ho.Id"
Invoke-Sqlcmd -Query $script

$script = "INSERT INTO [Your].[Mom] ([Description],[InsertDateTime])
VALUES ('All night long', '$(Get-Date -Format "yyyy-MM-dd HH:mm:ss")')"
Invoke-Sqlcmd -Query $script -ServerInstance "localhost\sqlexpress"

Friday, May 26, 2017

Working as a free SDET, Beta testing

Image result for free  testingI was given the opportunity to be a beta tester for Groundfloor AI, that's the Automated Investing feature not Artificial Intelligence. I gotta say pretty nice use marketing acronym because no reasonable person would think it's actually Artificial Intelligence but they will have a subliminal connection to the feature and the product. I stumbled upon the opportunity when trying to locate the feature I found a FAQ on how to turn automated investing on. The FAQ was a little vague, so I called in to there support and found out the feature wasn't released yet, actually the FAQ was just pushed out minutes before my search and the feature was only available for beta testing. I explained to the customer service rep that I was a professional QA and from there it was easy. They did check my account to see if I was an active user first, but within 2 hours of my original search/call I was able to make use of the feature.
They didn't give any instruction on the feature, at first I didn't like that but it's more natural to do discovery on the feature like a normal user first time experience. My first time experience was uneventful, it was easy to setup and configure. I have reconfigured it multiple time with no issues. I guess I was disappointed because I couldn't break it, but as a finance product if I was able to break it I would have lost faith in the company at some level.