in

Drowning In Technical Debt

C# | ASP.NET | SharePoint | SQL | Architecture | SOA |
All Tags » C# » sql (RSS)

Browse by Tags

  • 2008 SQL Saturday Tampa

    SQL Saturday Tampa 2008 was great, a big thank you to the organizers Pam, Wes, and team, great job guys! To those that attended my session on the SQL CLR I have uploaded my presentation here ( http://cid-afc22ba66ea68f7d.skydrive.live.com/self.aspx/Public/2008_02_16_SQL_CLR.zip )
    Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 02-17-2008

  • Orlando SQL Saturday 2007 & .NET SQL CLR

    Yesterday was the first ever SQL Saturday, mad props to Andy Warren from End2End Training ( http://www.endtoendtraining.com/ ) for all his work organizing this event. Over 200 people showed up to hear about some SQL server goodness. Andy defiantly raised the bar when it comes to these events and we at...
    Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 11-11-2007

  • chunking binary or xml into sql

    this is a little unique of a setup. i'm having to update a varbin field, but the data that is coming in from the other sources is being cast from xml. so i'm sort of replicating the stupid thing we are doing on the other side, but it seems like a good code sample for this particular method. if...
    Posted to roy ashbrook (Weblog) by royashbrook on 10-29-2007

  • chunking varbinary into sql2005

    //reference this metholodogy justification at // http://www.lacoude.com/Docs/public/public.aspx?doc=SQL90XML.PDF int bufferSize = 0; byte [] buffer = new byte [ 8040 ]; string update_sql = @"update tablewithblobs set blobcolumn .write(@a,null,0) where id = @b" ; using ( FileStream fs = File...
    Posted to roy ashbrook (Weblog) by royashbrook on 10-26-2007

  • use CommandBehavior.CloseConnection even with usings

    Recently I put together a SQL talk for developers and gave it at our local JAXDUG meeting. It went over well and one of the items I covered was utilizing CommandBehavior.CloseConnection with the command being used. While the implicit finally created by the using connection below will close the connection...
    Posted to roy ashbrook (Weblog) by royashbrook on 07-10-2007

  • Notes from the TechEd 2007 Birds of a Feather I did with Alan

    Shawn Weisfeld C# MVP President Orlando .NET Users Group http://www.shawnweisfeld.com shawn@shawnweisfeld.com Alan Stevens President East Tennessee .NET Users Group alanstevens@gmail.com http://netcave.org/ Notes by Dave Noderer: daven@computerways.com (thanks Dave for taking notes during the session...
    Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 06-09-2007

  • command cancel vs close

    There are a ton of articles about using command cancel vs close when you are using a datareader. The idea is that it will make things faster if you cancel the command rather than just closing it if you have an occasion to interrupt the execution. If you don’t cancel, it seems that it will read the rest...
    Posted to roy ashbrook (Weblog) by royashbrook on 05-03-2007

  • basic sql load testing with a multithreaded c# console app

    this is a very basic load tester. it basicaly lets you from the command line specify what command to run, how many times, against what connection string and whether you want to see any results. obviously, you can tweak it to print the results differently as you see fit, currently it just spits out field...
    Posted to roy ashbrook (Weblog) by royashbrook on 03-20-2007

  • zipcode sql2005 endpoint sample/example

    i went to look for a super simple way to setup a test of the endpoint feature in sql 2005. i couldn't find one simple enough, so i made this one up. here's some sql code. just run all of this. there are comments in here for what's going on. --copy the database file from --http://www.cfdynamics.com/zipbase...
    Posted to roy ashbrook (Weblog) by royashbrook on 03-09-2007

  • My DataHelper

    While I am a firm believer in the Enterprise Application Blocks from Patterns and Practices ( http://msdn.microsoft.com/practices ) I was recently asked to produce a simple way for people to get data without the EAB. I know there are a million examples on the web but here is mine . . . I start with a...
    Posted to Shawn Weisfeld [MVP] (Weblog) by sweisfeld on 01-19-2007
Page 1 of 2 (11 items) 1 2 Next >
Community Credit
Powered by Community Server (Commercial Edition), by Telligent Systems