Tag Archives: Table Value Parameters

Pittsburgh Code Camp – SQL 2008 for Developers

Posted on October 16, 2010 by | Leave a comment

This past weekend I presented SQL Server 2008 for Developers at the PGH.NET Code Camp.   You can download the slides here if you would like a copy.  You can also check out my scheduled speaking engagements.

The PGH.NET 2010.2 Code Camp was organized very well.  I want to give a big shout out to organizers as they did a great job.  My favorite session of the day was Scrum 101 with Eric Kepes (Blog | Twitter).  Personally, I knew very little about Scrum coming in to the presentation so this was a great opportunity for me to see how others have implemented it in their shops.  The presentation lead to some great debates.

If you would like to see Eric’s presentation or download a Scrum worksheet check out his blog post.

Leave a comment

Posted in Events, Professional Development, SQLServerPedia Syndication

Tagged , , , ,

Table Value Parameters with SQL Server and .NET

Posted on September 29, 2010 by | Leave a comment

Have you ever wanted to send multiple insert statements using one round-trip to the database? This month I published a tip on mssqltips.com to do this implementing Table Value Parameters with .NET.  It will be the first of many tips and blog entries on SQL Server 2008 Development as I am schedule to present at a few events across the country.

For more on Table Value Parameters check out my links.

Leave a comment

Posted in SQL Server

Tagged , , ,

Recap: PGH.NET August 2010 Meeting

Posted on August 12, 2010 by | 1 comment

On August 10th 2010 I attended and presented at the PGH.NET User Group meeting named “5 Guys with Code.”  According to one of the PGH.NET leaders tweet it looks like the headcount was 60+

Twitter David Hoerster @brittrking Awesome mtg la ..

The following are some thoughts and highlights from the presentations.

Presentations

  •  
    • John Sterrett (Blog | Twitter) – Table Value Parameters with SQL Server 2008 and Microsoft .NET  

    • I presented a feature that is included in SQL Server 2008 and underused by many developers.  This presentation shows developers how to pass a  DataTable, DataReaders and Lists to SQL Server database objects with only two extra lines of C# or VB.NET code. 

    As promised below are some reference links

  • David Hoerster (Blog | Twitter) – jQuery Code Snippets in Visual Studio 2010

Time is money and David’s fifteen minute tip might just save you a lot of time and money.    He covered several tools that will help you generate some awesome JavaScript. 

I  really liked the jsFiddle.NET tool.  It looks like a great tool to mockup some a user interface (more on user interfaces later).

  • Rich Dudley (Blog  | Twitter ) – A Quick Look at the New SQL CE Engine

Being addicted to databases I very happy to see that I wasn’t the only one presenting a topic based on databases.  Rich did a great job explaining what SQL CE can do and what it cannot do. 

Rich blogged about his experience (post includes photos, slides and more)

  • John Hidey (Blog | Twitter) – Layout Controls for XAML

I have to admit that XAML and I don’t get along well.  We had a fling a few years ago.  XAML cheated on me and I haven’t been the same since.

Ok seriously, I tried XAML a few times and found it very hard to understand.  John did a great job going over the common things that are hard to understand when you get started with XAML.   John started with some very basic controls and then built a final example that included all the basic controls.

At this summers PGH.NET Code Camp we had a speakers session where one of the presenters said, “Code is considered legacy code when TDD is not applied.”  Eric bowling for TDD example showed how anyone can start developing TDD.

1 Comment

Posted in Events, SQL Server, SQLServerPedia Syndication

Tagged , , , , ,