Installing the SQL Server 2005 BOL help requires the .Net 2.0 Beta Framework, which you might not wish to install yet. In my case, I have a virtual machine with a full 2005 install, but on my physical machine, I often need to refer to 2005 BOL. If you used to refering to the MSDN […]
You are browsing archives for
Month: September 2005
Getting Personal With Google
I don’t have an RSS Aggregate program. I don’t think I need one. There are just so many blogs that I pass over in a week, and most of them don’t update more than that (this one included at times). I’m also a bit of a devourer of information. New anything is interesting to read, […]
SSIS: Handling Lookup Misses
Let me direct you to an article by Ash on speed differences between two approaches to handing failed lookups in SQL Server Integration Services. Failed lookups are likely to happen at some point, and in most cases you won’t want your package to fail as a result, but rather a default or derived value or […]
RSS Feed Autodiscovery & Pinging
If you’re using GeekLog you’re probably aware of the Content Syndication / RSS Feed feature. It will automatically output the stories from your site, or a topic, into a standard RSS XML file that can be polled for updates. With more and more blogs coming online, search engines like Google are starting to build specialised […]
When MONEY is not enough
SQL Server’s MONEY data type is where you should be looking first if you are storing something like prices and order totals. But what about pesky GST and VAT values? These sometimes need to extend out to 6, 8 or even more decimal places in order to calculate the correct tax inclusive price. Along comes […]
SQL Server 2005 September CTP Released
SQL Server 2005 September Community Technology Preview (CTP) has been released today by Microsoft and is available for download now. The September CTP will be the last CTP/Beta before Microsoft releases the RTM/Gold version in November. Its available in the same five flavours as before: Enterprise, Standard, Workgroup, Express, and Developer. Microsoft have said that […]
Determining Store Procedure Creation Options
If you’ve scripted out a stored procdure, you’ll have noticed the SET ANSI_NULLS ON or SET QUOTED_IDENTIFIER ON options are also scripted. If your a verteran SQL coder, no doubt you set these before you create any stored procedures. But once a stored procedure is created, how do you determine what options were set? Well […]
That warm fuzzy feeling
While I find my full-time job constantly challenging, its also like any job: limited to the current projects and development. This is not a downside, just a fact that what you do in your job will be limited by the scope of your work. Sure there’s daily study, and home projects, things you choose to […]