Just a quick one in case I forget – I had a scenario where I needed to replace fn_varbintohexstr in converting an existing product to something more Azure SQL DB friendly. I did some googling and didn’t like the results,… Continue Reading →
Today I was diving into some extremely wide tables, I wanted to take a quick look at things like “How many unique values does this table have in every column?”. This can be super useful if you have a spreadsheet… Continue Reading →
I know I have been writing a lot about ADS recently, but this is even bigger than the Notebook announcement. A Postgres plugin has been announced in the insider release of ADS, and it just works! If the term Postgres… Continue Reading →
It’s only been ten days since my first post about ADS Notebooks, and the team has already pushed out some super useful updates. Now launching an Azure Data Studio Notebook now is almost instantaneous. You are not prompted to install… Continue Reading →
Update: This blog post is already out of date due to the hard work of the ADS team! Check my Azure Data Studio Notebook Update for more details of why you can skip my warnings about your internet connection. I… Continue Reading →
A great question came up in the SQL Community Slack today: I saw this as a great modification on my earlier post, and wanted to show another way to implement the same solution. Walking through the steps: First, use sys.objects… Continue Reading →
I’ve been on a bit of a hiatus with the move to California and figuring out my new life here. I needed some inline TSQL to mask a string based on a simple masking input, like ‘##xx##’ where # would… Continue Reading →
Today Thomas Rayner’s post on Get-History reminded me of a one liner I use to calculate time spent on the last command.
|
1 |
(Get-History)[-1].EndExecutionTime - (Get-History)[-1].StartExecutionTime |
|
1 2 3 4 5 6 7 8 9 10 11 |
Days : 0 Hours : 0 Minutes : 0 Seconds : 0 Milliseconds : 87 Ticks : 870022 TotalDays : 1.00696990740741E-06 TotalHours : 2.41672777777778E-05 TotalMinutes : 0.00145003666666667 TotalSeconds : 0.0870022 TotalMilliseconds : 87.0022 |
You can select any property from the output and get just the TotalSeconds, but I like… Continue Reading →
I wanted to bring you a quote from #SQLSaturday channel in the SQL Community Slack that I found amazing: “They [the PASS board] are already signaling they don’t want to spend $$ on SQL Sat and a few of the board members would… Continue Reading →
@brianszadek says: I am looking to automate the scripting of objects with PowerShell for easier source control integration. I thought this would be a little bit easier, but it looks like the SMO way of doing this is still fairly… Continue Reading →
© 2020 Select Indistinct — Powered by WordPress
Theme by Anders Noren — Up ↑