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,608 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,275 reads
Tracking Database DDL Changes with SQLVer
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
6,476 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,863 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,646 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,461 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,888 reads
Blogs
Schema Filtering in SQL Prompt
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances
By Steve Bolton …………Each group of distance measures surveyed in this segment of the...
Midlands PASS: SQL Server Security Basics
By Brian Kelley
Midlands PASS (Columbia, SC) will be meeting on March 3, 2020, for our monthly...
Forums
Need Help with DBMail sending Excell attachments with query results
Hello All, I'm having trouble trying to get this to work: This is the...
Mean Median Mode using SQL and DAX
Comments posted to this topic are about the item Mean Median Mode using SQL...
Reviewing Your Past Efforts
Comments posted to this topic are about the item Reviewing Your Past Efforts
Ask SSC