Browse by Tags

Looking for some .NET Developers

Published 6 June 8 10:19 PM | William

A client of mine located in the Aiken/Columbia South Carolina Area has asked me if I had any friends who are .NET Developers and looking for a job. They are looking for at least one Junior Developer, on Mid-Level Developer and several Senior developers...

Filed under: Compact Framework, Data Access, Web Services / WSE, .NET Basics, .NET General, Coding Techniques, Misc Technology, Biztalk, WPF, WCF, .NET 3.0 Framework, WIX, Sql Server Integration Services, SSIS, Silverlight, Sql Server, Sql Server 2008, Sharepoint, LINQ To ADO.NET, .NET 3.5 Framework, LINQ, LINQ Training, ADO.NET 3.5, C# 3.5, Windows Mobile, Job Stuff

Coding Arguments - aka How to Start Religious Wars

Published 23 July 7 5:33 AM | William

I am lucky enough to work for a company that really encourages us to get together and learn/hang out etc. One way this happens is by Tech Nights. Basically, we have in office meetings which are recorded via Live Meeting, where someone picks a topic and...

Filed under: Data Access, Life in General, Coding Techniques

Musings on the database formerly known as Sql Everywhere

Published 2 November 6 2:53 AM | William

The IM volume I received today about the Rollback to SqlCE issue was enough to border on overwhelming. Between PMs and some lazy SOB CRM guy trying to get me to do all his work for him, it was hard focusing on work today. (And seriously, if you are a...

Filed under: Compact Framework, Data Access, Visual Studio .NET 2005, Coding Techniques

Differentiating between "Denormalization" and excuse making.

Published 27 September 6 6:47 AM | William

I've actually got a lot to discuss about database stuff but wanted to start out explaining a very basic concept. All me to disgress for a moment. I've worked at a few places where there were some Cobol/AS 400 developers that were quite full of...

Filed under: Data Access, Coding Techniques

Comment of the week - Sql Server Reporting Services vs. Crystal

Published 27 September 6 6:27 AM | William

A while ago, I posted this about how much a55 I think Crystal Reports sucks. A long time ago, back at like v.7, I thought Crystal was a decent product. And to be honest, it still is a decent product. But it comes with a lot of baggage and has a lot that...

Filed under: Humor, Data Access, .NET General, Coding Techniques, Mindless Babbling, Misc Technology

Normalization really does matter

Published 7 September 6 3:30 PM | William

It seems like years ago, but I remember one of my professors giving us an assignment. It involved taking a database chock full of redundancies and writing the SQL Statements to make a few small updates. We thought it was an assignment to test our SQL...

Filed under: Data Access, Coding Techniques

Transferring data around with ADO.NET 2.0 - SqlBulkCopy

Published 26 August 6 5:3 PM | William

I'm working at a client on a data migration and found some results that were surprising. I expected there to be a difference but not one quite this large... Synopsis of Problem: Right now I'm working on a rather complex migration from a bunch of disparate...

Filed under: Data Access, Visual Studio .NET 2005, Coding Techniques

To use Stored Procedures or not.

Published 14 June 6 9:14 PM | William

A while ago, Frans wrote Stored Procedures are Bad, M'Kay . None other than Adam Machanic chimed in, arguing essentially the opposite . The always insightful Anatoly Lubarsky gives his take on it and well, my head is spinning. I was Mr. Stored Procedure...

Filed under: Data Access, Coding Techniques

Where's the Extra Connection String Coming From?

Published 14 June 6 1:33 AM | William

One of the issues I came across when writing my new book was with ConnectionStrings. Examine the following configuration section: <connectionStrings> <add name="AdventureWorksString" providerName="System.Data.SqlClient" connectionString="Data...

Filed under: Data Access, Coding Techniques

Pablo Castro on ADO.NET 3.0

Published 12 June 6 11:39 PM | William

I'm bummed that I couldn't make it to Tech Ed, Sahil is presenting and everyone I know is up there. Anyway, i've been reading Kent Tegels liveblog of Pablo Castro's ADO.NET 3.0 presentation report on ADO.NET 3.0 and am green with envy. Pablo is one of...

Filed under: Data Access, Coding Techniques

Learn ADO.NET from the Best

Published 6 June 6 10:29 PM | William

Well, saying someone is 'the best' is a pretty big statement, but one thing is certain, any discussion of 'the greatest talent in ADO.NET' will have Sahil's name featured prominently. Just look at what his people who read his book say! Anyway, if you...

Filed under: Data Access, Coding Techniques

With ADO.NET DataTables Remove != Delete

Published 10 May 5 7:39 PM | William

One of the very first mistakes I made when I was learning ADO.NET was confusing DataTable.Select with Remove. I wrote this a while ago which explains the distinction in detail. Bill Vaughn was kind enough to set me straight on the issue. Anyway, in a...

Filed under: Data Access, .NET General, Coding Techniques

What's wrong with this Transaction?

Published 15 April 5 6:55 PM | William

I've seen this come up in newsgroups quite a bit and figured that although it's not exactly hot news, it's worth mentioning. Let's say that you have a DataSet and you want your updates to work transactionally [meaining that they all succeed or fail together...

Filed under: Data Access, Visual Studio .NET 2005, Coding Techniques

DataReader vs. DataAdapter

Published 26 February 5 12:53 AM | William

I'm totally stoked to see Bill Vaughn blogging because he's 1) Irish 2) named William 3) He's a bad a33. I saw Sahil and Rocky chimed in on this issue - and it's one that I feel like running my big trap about too. In the debate between which to use, there...

Filed under: Data Access, Coding Techniques

http://www.everythingado.net

Published 30 January 5 2:45 AM | William

Well, I finally bit the bullet and purchased my site from Brinkster. I'm going to be hosting blogs for a few of my disaffected DNJ friends - but well, due to the nature of the site - I'm not handing them out to everyone - If I know you, or you can convince...

Filed under: News, Humor, Compact Framework, Data Access, MVP Stuff, Me, .NET General, Visual Studio .NET 2005, Coding Techniques, Mindless Babbling

Requests for Content

Published 23 January 5 10:40 PM | William

I've finally started to get a little free time these days and I'm going to be doing some quality Travelling in the next few weeks - if you're interested in something in particular, I'm taking requests. Anything ADO.NET, Anything Compact Framework, (Not...

Filed under: Compact Framework, Data Access, Remoting, MVP Stuff, .NET General, Visual Studio .NET 2005, Coding Techniques

BinaryFormatter in ADO.NET 2.0

Published 23 January 5 10:26 PM | William

This is hardly hot off of the press, but I had a few questions about it and figured I'd post it. There is a new RemotingFormat property w/ DataSets in ADO.NET 2.0 - and depending on how you are trying to work things, the differences can be profound. Note...

Filed under: Data Access, Remoting, Visual Studio .NET 2005, Coding Techniques

Rowstate is EVERYTHING

Published 21 January 5 7:16 PM | William

Well, not really, but if you don't get the concept of Rowstate, you'll have little fun with ADO.NET. I've written about this several times before, but it's a very persistent problem. I had my share of problems with it at first, until one day I 'got' it...

Filed under: Data Access, Coding Techniques

Caught Up on some reading this weekend

Published 28 December 4 12:47 AM | William

Got the chance to read through two new books although it looks like I got a few more on my list that look pretty good. Office 2003 Programming - Real World Applications - Ty Anderson ( APress ): Normally, I run from books with these sorts of titles. There...

Filed under: Data Access, Books, Coding Techniques

Andres on Remoting Datasets...

Published 16 December 4 12:40 PM | William

Andres Aguiar , the superbrain behind Deklarit responds to Rory's comments on Stuart's post . <<As I cannot comment in Stuart's blog, I'll do it here ;) a) He's right about that if you are not going to update data, then it's probably not a good...

Filed under: Data Access, Remoting, Web Services / WSE, .NET General, Coding Techniques