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,994 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,260 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,394 reads
Tracking Database DDL Changes with SQLVer
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
7,139 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,968 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,539 reads
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
2010-05-19
34,927 reads
Blogs
Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS
One of the nice things about the Microsoft Connector for Oracle is that it...
ChatGpt Experiments–Getting Documentation
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
A New Word: Jouska
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
Forums
SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati
Introduction to SQL Website Development What is SQL? Importance of SQL in web development...
puzzeled with "exec sp_cursor 180150007,40,1"
I've noticed in one of our applications a cursor uses operation 40 and that...
Ask SSC