2015-01-23 (first published: 2013-10-08)
29,963 reads
Sioban Krzywicki
Find the Currently Running Scheduled Job
Ever need to automatically stop a long running job? Ever need to find which named Schedule is the currently running version of your job? There's simple code that'll let you find out.
2013-04-25
6,109 reads
Tally Table Uses - Part II
In part II of this series, Sioban Krzywicki shows us another way Tally Tables have helped solve problems - Text Parsing.
2010-08-03
9,324 reads
Tally Table Uses - Part I
In the first part of a series on Tally Tables, Sioban Krzywicki shows how a Tally Table has helped out with fiscal year calculations.
2010-08-02
16,318 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...
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...