blogs.conchango.com

Browse by Tags

• Books Online
• fuzzy
• fuzzy logic
• Grouping Sets
• katmai
• Microsoft
• Microsoft Connect
• Scripting
• SQL Server Integration Services
• SQL Server Management Studio
• SSIS
• SSMS
• T-SQL

• Fuzzyness

  SQL Server 2008 is introducing some interesting querying and storage enhancements such as the introduction of spatial data and the FILESTREAM attribute on VARBINARY(MAX) columns and my thoughts have recently turned to what querying enhancements we are Read More... Posted 21 May 2008 07:57 by jamie.thomson | 6 Comments Filed under: SQL Server, SSIS, Microsoft, sqL server 2008, fuzzy, fuzzy logic

• Katmai bug fixes

  There's some good news filtering into my inbox today about SQL Server bugs that have been fixed in the upcoming CTP (i.e. CTP6). Title: SSIS: Raw files throw an error at 4GB Description: It is not possible to load more than 4GB of data into a raw Read More... Posted 19 December 2007 18:41 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, SSMS, SQL Server Management Studio, katmai, sqL server 2008

• Why datetime2?

  In SQL Server 2008 a new datatype will be introduced that can support storing of date values from the year 0001 to 9999. This new datatype is called datetime2 . OK, so tell me what's wrong with the following picture: smallint, int, bigint smalldatetime, Read More... Posted 24 October 2007 15:32 by jamie.thomson | 5 Comments Filed under: SQL Server, sqL server 2008

• More T-SQL Goodness in SQL Server 2008 (codename katmai)

  Back in June I talked about some T-SQL enhancements that are coming our way in SQL Server 2008. One of those things is the ability to define multiple rows in an INSERT statement like so: insert t1 values (@i),(@i+1); Very cool stuff. Some people seem Read More... Posted 17 August 2007 20:33 by jamie.thomson | 2 Comments Filed under: SQL Server, T-SQL, katmai, Microsoft Connect, sqL server 2008

• Katmai\SSIS: C# comes to the script task/component

  "Why the <insert your favourite expletive here> doesn't SSIS support C# for the script task and script component?" I've heard the above complaint, in various different ways, many many times over the past 18 months since SQL Server 2005 was released. Read More... Posted 09 June 2007 15:51 by jamie.thomson | 7 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Microsoft, Scripting, katmai, sqL server 2008

• Katmai: T-SQL Grouping sets

  SQL Server 2005 includes the WITH CUBE and WITH ROLLUP syntaxes that are used to display summary information for combinations of columns in the GROUP BY clause. That's useful functionality but it didn't provide particularly fine-grained control Read More... Posted 04 June 2007 02:03 by jamie.thomson | 1 Comments Filed under: SQL Server, Microsoft, T-SQL, katmai, Grouping Sets, sqL server 2008

• Katmai: New T-SQL enhancements

  A very short post here showing some of the new T-SQL constructs in katmai . Check out the following code snippet: declare @i int = 1; set @i += 1; create table t1 (col1 int ); insert t1 values (@i),(@i+1); There are actually three syntax enhancements Read More... Posted 04 June 2007 02:03 by jamie.thomson | 4 Comments Filed under: SQL Server, Microsoft, T-SQL, katmai, sqL server 2008

• SSIS: Books Online documentation

  On a recent trip to Seattle I met up with Doug Laudenshlager. Doug is the guy that writes all the fantastic Books Online documentation that is delivered with SSIS. Following the trip Doug shared with me some titbits of info about BOL and he's graciously Read More... Posted 17 March 2007 21:57 by jamie.thomson | 3 Comments Filed under: SQL Server, Books Online, katmai, sqL server 2008