Parsing HTML to SQL using SQLDOM
It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM
2019-07-15 (first published: 2012-04-16)
17,631 reads
David Rueter
Rendering PDFs Natively in SQL
How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
2015-08-21 (first published: 2013-05-08)
28,153 reads
SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion
How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.
2015-07-14
7,369 reads
Tracking Database DDL Changes with SQLVer
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
6,944 reads
Dealing with the Evil of FMTONLY from SSRS
SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?
2014-12-23
8,458 reads
Deploying CLR Assemblies with T-SQL
Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.
2013-05-07
9,222 reads
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
2010-05-19
33,462 reads
Blogs
PGSQL Phriday #001: Two Truths and a Lie
As a part of my own journey of learning within PostgreSQL, I’ve decided that...
Daily Coping 7 Oct 2022
By Steve Jones
Today’s coping tip is to be willing to share how you feel and ask...
T-SQL Tuesday #155 –The Dynamic Code Invitation
By Steve Jones
Apologies for the late invitation. A minor snafu has me hosting again. This is...
Forums
How to display original part and recommende part with each other but must recome
I work on sql server 2019 i face issue on slow running when I...
Any reason to use AWS WAF over Cloudflare?
I'm primarily using Cloudflare for security. I was wondering if AWS WAF is any...
OP identification
In lengthy discussions and in developing trial and error scenarios I sometimes find it...
Ask SSC