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,838 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,321 reads
Tracking Database DDL Changes with SQLVer
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
6,636 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)
16,711 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
6,893 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
8,392 reads
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
2010-05-19
29,565 reads
Blogs
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Daily Coping 26 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Why are DBAs not paid for knowledge and other IT Professionals are?
DBAs are being asked to know everything for 6 figures which cap out for...
Common Table Expression Misunderstandings
Comments posted to this topic are about the item Common Table Expression Misunderstandings
Distributed AG DB movement
I have a DAG between On prem and Azure. We have a maintenance window...
Ask SSC