Browse by Tags

USB support in virtual machines

One of the few gripes I have with Microsofts virtualisation story is the lack of support for USB. Well a company has just come up with a USB network server, which allows a host machine with USB support to act as a sort of proxy to the USB devices. Charlei Russell has tried it out and here's his intial...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 07-31-2008
Usergroup meeting follow up post

As promised here is a follow up to the questions and points raised during the meeting tonight. We didn't get to cover full text but here are my posts on iFTS in SQL 2008 which works very differently to how it does in SQL 2008. Compression of a large table, how much space do you need? The compression...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-19-2008
SQL Server 2008 - The MERGE and TVP data access pattern with DataAdapters

The MERGE statement and Table Valued Parameters (TVPs) are two new features in SQL Server 2008 that make the process of doing DML (Data Manipulation i.e. INSERT, UPDATE and DELETE) on multiple rows very easy. This article shows how you can adapt Historically to save data using the DataAdpater you configure...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-18-2008
SQL Server 2008 - Handling deletes with MERGE

The MERGE statement is a new statement introduced in SQL Server 2008 that allows you to perform inserts, updates and deletes in one statement. You use a rowset as the source for the MERGE and as with all rowsets this can have any number of rows in it. For an introduction see “MERGE an introduction”....

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-18-2008
SQL Server 2008 - MERGE and optimistic concurrency

Most applications are written nowadays using optimistic concurrency. Locks aren’t placed on a piece of data for the duration of someone viewing that data in their application. Instead what you do is when someone wants to save the data you check to see whether someone else as changed it since the time...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-18-2008
SQL Server 2008 - Killer features - MERGE and Table Valued Parameters

Table valued parameters along with MERGE are in my view the two killer features and the two that I believe will get most uptake when people start to use SQL 2008. Table valued parameters enable you to send a set of data as a single parameter to your code whether it be adhoc SQL, a stored procedure or...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 06-17-2008
SSIS truncating BLOB fields from Sybase

Last week I struggled with issue that had been causing many problems in our work. We have implemented SSIS packages that synchronize Sybase and SQL Server databases. Some of tables contain text (on Sybase) columns that have to be passed to varchar(max) columns on SQL Server. It wasn't apparent on...

Posted to Piotr Rodak (Weblog) by Piotr Rodak on 04-19-2008
SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

In a recent post SQL Server 2008 - HierarchyId whats the point? I talk about the scenarios that the new hieararchyId can be applied to. Here we expand on this further and also provide a solution for moving hierarchies around. The limitation is that you can't do something like this to change the parent...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-31-2008
Set based splitting of delimited strings to columns

I recently presented on using CLR in SQL at DevWeek and commented on how TSQL Udfs just don't perform. A common scenario people in the audience were using TSQL Udfs for was splitting delimited strings. One guy asked me afterwards what the best way to do it was, he had addresses in one field he wanted...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-17-2008
SQL Server 2008 - Whats this abut 30,000 columns?

Its all about Sparse columns and they are a great feature of Katmai Imagine you have a products table, you will have attributes for some products that don't apply to others i.e. cup size applies to bras but not to socks. There are a number of ways of modelling this each with downsides. With sparse...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-16-2008

Page 1 of 13 (123 items) 1 2 3 4 5 Next > ... Last »