Email Formatted HTML Table with T-SQL
Create a professional looking HTML table from T-SQL, not SSRS.
2015-08-31 (first published: 2013-06-20)
32,977 reads
Steve Moore
SQL Server Management Studio and SQL Azure
A new article from Steve Moore shows us how to use SQL Server Management Studio with your SQL Azure databases in the cloud.
2009-12-09
6,279 reads
Importing XML Files Into SQL Server
Have you ever received an XML file from someone to import into SQL Server? It's not as easy as you might expect, especially in SQL Server 2000. New author Steve Moore brings us an article and code on how to do just that.
2007-11-23 (first published: 2006-02-15)
38,250 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...