Publications and Papers


For SQL Team


DATEDIFF function demystified

Curve Fitting, Trend Analysis and Prediction (also see Application Software)

DateDiff 360 calculation

Bin packaging

Prime number factorization

Enhancements of PARSENAME function

Dijkstra's shortest path

Bayesian estimate and Root Mean Square



For SQL Server Central


How to create a calendar table

PIVOT and Cross Tab for Microsoft SQL Server

RC4 Encryption and Decryption

Checksum replacement

Fetch ordinal number as text

MIME64 encoder and decoder

Full Control Over a Randomly Generated Password




Relevant links


My SQL blog 


Microsoft blogs

Craig Freedman 

SQL Server Development CAT 

SQL Server Engine 

SQL Server Premier Field 

SQL Server Query Processing 

SQL Server Storage Engine 


MVP blogs

Itzik Ben-Gan 

Aaron Bertrand 

Derek Comingore 

Kalen Delaney 

Grant Fitchey 

Madhivanan JR 

Tibor Karaszi 

Brian Kelly 

Tara Kizer 

Hugo Kornelis 

Adam Machanic 

Paul Randal 

Gail Shaw 

Erland Sommarskog 


Other blogs

Adam Haines 

Lynn Pettis 

John Sansom 

Barry Young