Jon Winer


SQLServerCentral Article

Reduce Database RoundTrips Using XML

SQL Server 2000 added XML support to allow some basiuc manipulation of XML data. At the time, XML was a hot buzzword in the computer industry and there were lots of applications being written to use XML. While the buzz has cooled, Jon Winer still uses XML in some interesting ways to make his life easier and his applications more rebust. Here he brings us a technique he's used to reduce the number of round trips required by an application.

2004-11-29

9,419 reads

SQLServerCentral Article

Normalizing Dates

Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance!

2003-09-05

9,888 reads

Blogs

Goal Progress for Jan 2023

By

The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger

By

Does Context Info work across databases? This post shows it does. Another post for...

Introducing… Data On Rails!

By

Data On Rails is a Data On Wheels project designed to give a platform...

Read the latest Blogs

Forums

Identity column and "EntityID" column naming convention

By CreateIndexNonclustered

This isn't* specific to 2022, but SQL in general. I will be joining a...

Replace Primary Server keeping same Log Shipping Server

By BobAtDBS

I have a two node SQL Standard 2014 Failover Cluster at the primary site. ...

Memory Issue With A SQL Server Express 2019 Server Database Application

By Rob Reid-246754

Hi, I have just moved a DB from an old HP laptop, to a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers