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,594 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,265 reads
Tracking Database DDL Changes with SQLVer
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
6,439 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,782 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,510 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
7,328 reads
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
2010-05-19
25,370 reads
Blogs
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors...
Forums
SSIS Excecute SQL Task not executing simple T-SQL correctly.
Hello, I have an SSIS package with an Execute SQL Task that runs the...
Case when index scan faster then index seek (see example)
Hi, we had case today where query with existing non clustered index provided 100% ...
Extract date from String
Folks: I have to extract the date from this string which is between files_...
Ask SSC