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)
27,548 reads
David Rueter
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,239 reads
Tracking Database DDL Changes with SQLVer
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
6,328 reads
Parsing HTML to SQL using SQLDOM
It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM
2014-12-26 (first published: 2012-04-16)
15,465 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
5,046 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
6,867 reads
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
2010-05-19
23,955 reads
Blogs
Weekly reading #26
By damianwidera
Good morning! It was a tough weekend as we supposed to be in Goteborg...
Delete an Azure DevOps Project
By Steve Jones
Not something you’ll do too often, but you might find yourself doing this if...
Ways to access data in ADLS Gen2
By James-Serra
With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
“Included columns” for non-clustered indexes explained
Comments posted to this topic are about the item “Included columns” for non-clustered indexes...
Reindexing a database
Comments posted to this topic are about the item Reindexing a database
Ask SSC