Skip to Content

peter debetta (75 Posts)

RSS

SQLblog is Moving to a New Hosting Provider

Posted July 14, 2017

By ,

In SQLBlog, Uncategorized

After a long run on our current hosting provider, SQLblog will be moving to a new hosting provider. During this process, starting later this evening, SQLblog... more »
0

SQL vs. Oracle Live Debate (AKA Smackdown!)

Posted May 30, 2012

By ,

In Oracle, SQL Server, Uncategorized

A few years ago I was speaking at a conference in Raleigh, NC where Ted Neward and I found a fun way to promote a Java vs. .NET debate that was planned one... more »
0

Extracting GPS Data from JPG files

Posted May 21, 2012

By ,

In Uncategorized

I have been very remiss in posting lately. Unfortunately, much of what I do now involves client work that I cannot post. Fortunately, someone asked me how he... more »
0

2008: Converting XML to HIERARCHYID

Posted December 09, 2007

By ,

In Uncategorized

While working on a new book, I have been experimenting with the new HIERARCHYID data type. And since I’ve seen comparisons drawn between using XML versus... more »
2

2008: Row Constructor or Table-Valued Parameter

Posted December 06, 2007

By ,

In Uncategorized

Denis posted a follow-up to the posts by both Louis and me. However, I have to say that there is a better way to pass a bunch of data to a procedure. The... more »
12

2008: More Row Constructor Fun

Posted December 05, 2007

By ,

In Uncategorized

My esteemed colleague Louis Davidson just wrote about a new feature in SQL Server 2008 known as row constructors. I thought I’d follow up with some more... more »
1

Non-Technical: SQLblog has moved!

Posted November 17, 2007

By ,

In Uncategorized

If you are reading this post then you are being served up by SQLblog from its new home at MaximumASP hosting provider. We are very excited to be working with... more »
0

SQL Server Connection Level Parameters

Posted July 19, 2007

By ,

In Uncategorized

Have you ever needed to pass in a value that would be used throughout the lifetime of a connection – perhaps a connection session level value that would... more »
2

Manage Visual Studio Auto Connect to Team Foundation Server

Posted July 19, 2007

By ,

In Uncategorized

I’ve been on a project where we are using Team Foundation Server (TFS). As you may already be aware, Visual Studio (VS) automatically tries to connect to... more »
0

DevTeach Code Samples

Posted June 07, 2007

By ,

In Uncategorized

A little overdue, here are my code samples from my sessions at DevTeach Montreal 2007. more »
0