developerworkshop.net  2009                    

 

 

 

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