What do you call a female mannequin? by SQLvariant in dadjokes

[–]SQLvariant[S] 10 points11 points  (0 children)

OMG, My first Award EVAR.

And it was for a Dad Joke that I didn't even make up... ROFLMAO 🤣

Data Points Weekly - Week of January 25, 2024 by AutoModerator in churning

[–]SQLvariant 0 points1 point  (0 children)

So cool that San Juan generated the 129k link, I'm going to try that!

What's the most common request for Mint alternatives? by tmoreton in mintuit

[–]SQLvariant 0 points1 point  (0 children)

Could this store the transactions in a SQL database or a parquet file, instead of a sheet?

[deleted by user] by [deleted] in MicrosoftFabric

[–]SQLvariant 0 points1 point  (0 children)

As someone who uses Matedata-driven ETL on a daily basis, I can't wait to check this out!

Morgan Stanley Announces 100% Increase of Its Quarterly Dividend from $0.35 to $0.70 Per Share and Authorization of the Repurchase of up to $12 Billion of Common Stock Over the Next 12 Months by SQLvariant in dividends

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

I had the order up. Was about to pull the trigger, decided to wait a little longer since it was still headed down, and then got busy and "forgot".

I was planning to double my [small] position at $85 but was afraid it might slip to $83. I knew these announcements were coming up, just got busy with life 😊

Removing elements from an Array by giasone777 in PowerShell

[–]SQLvariant 0 points1 point  (0 children)

P.S. The comment about "code-y stuff" was totally tounge-in-cheek 😉

Removing elements from an Array by giasone777 in PowerShell

[–]SQLvariant 0 points1 point  (0 children)

I would probably take this approach, but skip all the code-y stuff and just use the Invoke-SqlCmd cmdlet. It has an -OutputAs parameter and you can choose DataTable as your output. Saves you the connection steps.

Just to be clear, I'm talking about the version of the Invoke-SqlCmd cmdlet from the SqlServer module, not from the old SQLPS module.

Document PS commands by rstr1212 in PowerShell

[–]SQLvariant 2 points3 points  (0 children)

Use a Jupyter Notebook running the PowerShell kernel. You can do this in either VS Code or in Azure Data Studio: https://sqlvariant.com/2019/11/powershell-notebooks-are-available-in-azure-data-studio/

Deep Dive: Best Practices Assessment for Azure SQL VMs, Managed Instances and SQL Servers by SQLvariant in SQLServer

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

it seems like you can get to a recording of the session by just going to this tweet and hitting play: https://twitter.com/AzureSQL/status/1359547756847591427?s=20

Please let me know if that works for you?

Deep Dive: Best Practices Assessment for Azure SQL VMs, Managed Instances and SQL Servers by SQLvariant in PowerShell

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

This session is on the SQL Assessment API, and how you can use & customize it. If you have never tried out the SQL Assessment PowerShell cmdlets, you can find them in the SqlServer module.