New TPC-H Results

Last week Unisys posted their latest 10TB TPC-H results for their 16 socket Xeon X7460. There are a number of things that I find interesting about these results, beside the fact that they have set a record for price/performance. The first is that the X7460 has six Xeon cores per socket however Unisys only enabled…


Free Microsoft Press SSIS or Server Core eBook

More free stuff  for anyone who works with or wants to know more about SQL Server SSIS  the guys over at Microsoft Press have released  a step by step guide to SQL Server 2005 SSIS as part of the the MSPress 25th Anniversary celebrations. To get this book all you need to do is sign…

1

SQL Server 2005 SP3 on Microsoft Update

In the middle of December SQL Server 2005 SP3 was release on the Microsoft Download Center but as of today it is also available on Microsoft update. It is an optional update and currently only includes the update for Standard, Workgroup, Developer and Enterprise Editions. The Express editions will be released as automatic updates in…


Project Real Content back online

Over the last couple of years I have really found the Project Real content to be valuable. With the release of SQL Server 2008 and a reorganization of all the SQL and BI URLs this content went MIA for a while but the good news is that its back at a new URL  http://www.microsoft.com/sqlserver/2005/en/us/project-real.aspx The…


Cumulative Update 3 for SQL 2008 Released

SQL Server 2008 CU3 has been released today! To keep your SQL up to date with all the hotfixes since the release of SQL Server 2008  check out the KB article for more detail on it’s  contents: http://support.microsoft.com/kb/960484/en-us <Gary>


SQL Remove Duplicates Function (T-SQL vs CLR)

Pinal Dave did a post of an example of a function to remove duplicates from a comma delimited string. The code looks similar to this CREATE FUNCTION dbo.fnDistinctList2 ( @List VARCHAR(MAX) ) RETURNS VARCHAR(MAX) AS BEGIN DECLARE @Delim CHAR = ‘,’ DECLARE @ParsedList TABLE ( Item VARCHAR(MAX) ) DECLARE @list1 VARCHAR(MAX), @Pos INT, @rList VARCHAR(MAX)…


SQL Server Enterprise Architecture Summit – South Africa 2008

For those of you who attended the SQL Server Enterprise Architecture Summit held in Durban in December presented by Stuart Ozer, Kevin Cox and Thomas Kejser, the presentations are available at www.Derivco.com/SEAS. For those of you who missed it, keep an eye out for future SEAS events as they are well worth the time and…

1

Windows 7 running SQL Server 2008

After really enjoying the experience of running Windows 7 on my netbook last night, I have now moved on to installing it on one of my other PCs, a Tablet PC. The single most exciting thing about this install was that despite the drivers not being part of the build, once I ran a Windows…