Email Formatted HTML Table with T-SQL
Create a professional looking HTML table from T-SQL, not SSRS.
2015-08-28 (first published: 2013-06-20)
23,363 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,235 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)
37,936 reads
Blogs
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Introduction to SQL Server Execution Plans
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
Forums
How to send queued emails
After an upgrade, sql server stopped sending emails. Problem is not solved but during...
TLS 1.2 and Database mail
Hi, We use office 365, and just recently received an email from them saying...
Left join not pulling all from left table
T has 57,000 distinct rows Z has over a million. I did row over...
Ask SSC