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)
30,933 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,256 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,197 reads
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
Is TemporalTable SysStartTime available before performing an insert/Update?
I want to align a Date column (datetime2(7)) with the same full resolution date...
multiple PAGELATCH_UP waits on data file
Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...
dynamic update to SP
Looking for suggestions\examples of how to update a SP that the table used changes...
Ask SSC