Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Guest Columnist: David Rueter profile

   Items 1 to 7 of 7   

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.  Read more...
By David Rueter 2015/07/14 | Source: | Category: math
Rating: |  Discuss |   Briefcase | 7,023 reads

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
By David Rueter 2015/01/22 | Source: | Category: version tracking
Rating: |  Discuss |   Briefcase | 6,030 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?  Read more...
By David Rueter 2014/12/23 | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 4,267 reads

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2015/08/21 (first published: 2013/05/08) | Source: | Category: pdf
Rating: |  Discuss |   Briefcase | 27,123 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.  Read more...
By David Rueter 2013/05/07 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 6,000 reads

Parsing HTML to SQL using SQLDOM

It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM  Read more...
By David Rueter 2014/12/26 (first published: 2012/04/16) | Source: | Category: html
Rating: |  Discuss |   Briefcase | 14,820 reads

Geocode Addresses in T-SQL

Geocode, look up postal codes, and perform validation for street address information natively T-SQL  Read more...
By David Rueter 2010/05/19 | Source: | Category: geocode
Rating: |  Discuss |   Briefcase | 20,779 reads
   Items 1 to 7 of 7