SQL Clone
SQLServerCentral is supported by Redgate
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 | 7,196 reads

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
Rating: |  Discuss |   Briefcase | 6,150 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,421 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 | 27,424 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 | 6,243 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,954 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 | 22,008 reads
   Items 1 to 7 of 7