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 »
|