You are browsing archives for
Microsoft has quietly kicked out the final version of SQL Server 2005 and Visual Studio 2005 to MSDN subscribers ahead of the Launch Tour 2005. The .Net 2.0 Framework has also been released, which you will need to install/use either of these great things. If you’ve been keeping track of SQL Server 2005’s development, you’d […]
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 […]
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, […]
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 […]
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 […]
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 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 […]
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 […]
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 […]
Earlier on I wrote about how you can Select just the date part from a DateTime or SmallDateTime data type. (See [story:t-sql-date-without-time]) Using the CONVERT( … , … , style ) function we can specify the style attribute, that lets us specify to SQL Server (using style 14 or 114) that we just want the […]
