A View Inside My Head

Jason's Random Thoughts of Interest
posts - 86, comments - 178, trackbacks - 22

June 2008 Entries

SQL Server 2008: Spatial Data, Part 8

In this, the eighth part in a series on the new Spatial Data types in SQL Server 2008, I'll step away from the database and do a little spatial coding using .NET. Redistributable .NET Library Up to this point in the series, I have demonstrated a lot of interesting (?) things that you can do with the new Spatial data types (Geometry and Geography) in SQL Server 2008. You might be thinking, "That's swell, and all, but I wish I could do some of that stuff without needing to be tethered to a database." Well, you know what? You can! I mentioned in...

posted @ Monday, June 23, 2008 10:18 PM | Feedback (20) | Filed Under [ Articles .NET SQL Spatial ]

Coding in SQL Server: An Evolution

Tuesday at the NWNUG meeting, Steven Smith spoke on various ways to squeeze performance out of your ASP.NET applications. This was a fantastic talk, and gave me plenty to think about (since ASP.NET is not my forte, I only consider myself to have an intermediate skillset on this topic). One suggestion that he made involved caching database writes. That is, instead of immediately writing logging-type information to the database for every request, which is a relatively expensive operation considering the small payload size, that you could accumulate them in a short-term cache, and then perform the write operation periodically. Fewer database...

posted @ Thursday, June 19, 2008 4:50 PM | Feedback (2) | Filed Under [ Articles .NET SQL ]

SQL Server 2008 RC0 Install: Sql2005SsmsExpressFacet

This morning's goal was to quickly install SQL Server 2008 RC0, and then move on with some project work. Let's just say that my project work should resume by this afternoon... In the interest of disk space, I removed an existing installation of SQL Server 2005 Developer Edition. And then the installation of 2008 RC0 began by installing the "Microsoft.NET Framework 3.5 SP1 (Beta)"... which is probably "install-smell" for me needing to pave my machine when the product finally RTM's. But, I digress... The installation went pretty smoothly until it came time for the "System Configuration Check" that takes place after you...

posted @ Thursday, June 19, 2008 11:02 AM | Feedback (37) | Filed Under [ Articles SQL ]

Software Development Meme

This meme is brought to you by Michael Eaton, who just so happens to be a huge fan of my spatial talks. ;-) How old were you when you started programming? Well, we might need to better define "programming" here. I started tinkering with computers when I was about 6 or 7 (is that right, Dad?). In those days, it was more about reading a book about BASIC and typing in the program to run. Then I would make changes to the program to see the results. If modifying an existing program is considered "programming", then this is my epoch. I really didn't start creating...

posted @ Sunday, June 08, 2008 10:56 AM | Feedback (1) | Filed Under [ Articles Me! ]

Powered by: