Setting the Container Name–#SQLNewBlogger
I had started a Stairway series on containers (which I need to get back to), and I got a question. How do we set the name of a container?...
2022-04-18 (first published: 2022-04-11)
149 reads
Blog Posts
Daily Coping 15 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-15
17 reads
KQL Series – quick intro to Azure Data Explorer
Azure Data Explorer is a PaaS offering from Azure providing an end-to-end solution for data exploration. https://azure.microsoft.com/en-us/blog/individually-great-collectively-unmatched-announcing-updates-to-3-great-azure-data-services/ Here is a quick introduction of the features: https://azure.microsoft.com/en-us/services/data-explorer/#features This service from...
2022-04-15 (first published: 2022-03-31)
414 reads
Talk to the duck.
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is ... Continue reading
2022-04-15 (first published: 2022-03-31)
332 reads
Azure Redis Commands
Now that we have created our Redis Cache lets connect to it. You can use the most common tool redis cli.exe https://redis.io/download or as I am going to do,...
2022-04-14
128 reads
Daily Coping 14 Apr 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-04-14
9 reads
Minimal blocking UPDATE statements
How to perform minimal blocking updates in a high concurrency environment
2022-04-14
332 reads
Book Review – Snowflake Security
When I was working with Snowflake on a project, it seemed security (assigning roles to users, assigning permissions etc.) is not as straight forward as it is in SQL...
2022-04-13 (first published: 2022-04-02)
214 reads
Choco upgrade, y’all
Chocolatey is a package manager for Windows, like the built-in package managers on Linux, and third-party ones on macOS like Homebrew and MacPorts. The idea is this: when you’re...
2022-04-13
73 reads
Creating a Generic SSRS Report
Creating useful reports is part art and part science. On one end of the spectrum, you have visually appealing and highly customized reports and dashboards that are truly works...
2022-04-13 (first published: 2022-03-31)
438 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
Powershell extract
$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...