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

Guest Columnist: David Rueter

SQLServerCentral.com 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: SQLServerCentral.com | Category: math
Rating: |  Discuss |   Briefcase | 6,879 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: SQLServerCentral.com | Category: version tracking
Rating: |  Discuss |   Briefcase | 5,967 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: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 4,233 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: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 26,272 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: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 5,959 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: SQLServerCentral.com | Category: html
Rating: |  Discuss |   Briefcase | 14,711 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: SQLServerCentral.com | Category: geocode
Rating: |  Discuss |   Briefcase | 20,626 reads
   Items 1 to 7 of 7