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,688 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,295 reads
Tracking Database DDL Changes with SQLVer
Presents an open-source T-SQL based version tracking system for MSSQL
2015-01-22
6,547 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,193 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,052 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,832 reads
Geocode Addresses in T-SQL
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
2010-05-19
27,506 reads
Blogs
Daily Coping 10 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 9 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Forums
Controlling Intelligent Query Processing Features
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features,...
To use the same function to pass table name as a parameter
I have this function, but I wanted to pass a table so as to...
Create SQL Login to View only one database on server
Hi All, I have one task to create a login, and user need to...
Ask SSC