Jon Winer


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

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,173 reads

Blogs

Thoughts on Unique Resource Names in Azure

By

Each resource type in Azure has a naming scope within which the resource name...

Nonclustered index leaf records always contain a null bitmap – since SQL 2012

By

While testing a script that involved calculating index record size recently I was getting...

Using Framing for a Running Total–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

CPU and Memory issues

By garryha

I am a DBA  trying to get to the bottom of some instances when...

Error shrinking database

By Ram

While trying to shrink a database using the command "dbcc shrinkdatabase ([db_name])", I get...

Are Powerplans still relevant for VM servers?

By WebTechie

Hello, I am rolling out a new monitoring environment.  While in testing, it is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers