Browse by Tags

LiveDataScript: Scripting data from a database into insert statements

We've partnered with a company called Live Software Solutions on a number of projects recently and they've just decide to release a great tool we've been using on a number of projects as a free download. It allows you to generate a single script with insert statements from multiple sources...

Posted to Christian Bolton's SQL Server Blog (Weblog) by Christian on 07-30-2008
Customer Advisory Team - BizTalk Server Performance Optimization Guide

We've been doing some work with the BizTalk Customer Advisory Team at Microsoft to help develop official guidance for SQL Server in a BizTalk environment. This has just been launched as part of the Microsoft BizTalk Server Performance Optimization Guide. BizTalk has a strong depenency on SQL Server...

Posted to Christian Bolton's SQL Server Blog (Weblog) by Christian on 07-09-2008
SSIS - Convert various String date formats to DateTime with the Script Task

The script below is really nice if you need to convert String dates that come in different (unexpected) formats. Just copy and paste the code in your Script Task (paste the function outside Main() ) and it works right away. Supported date formats: YYMMDD YY-MM-DD YYYYMMDD YYYY-MM-DD Of course it's...

Posted to Jorg Klein's Microsoft Business Intelligence Blog [Macaw] (Weblog) by jorg on 06-12-2008
Will you still want me, when I'm 64?

Thankyou to all those who attended my session on 64-bit SQL Server at the UK SQL Server User Group on 17th April 2008. I've just got round to uploading the slidedeck for those of you that have been asking for it. You can download it here: http://coeo.com/conferences.html . For anyone interested that...

Posted to Christian Bolton's SQL Server Blog (Weblog) by Christian on 04-29-2008
MCITP - I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!

Today I passed the Microsoft IT Professional(MCITP) 70-446 “ PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam. This makes me one of the 337(January, 2008) Microsoft Certified IT Professionals worldwide! ( Nr. of MCP's worldwide ) To try the 70-446 exam...

Posted to Jorg Klein's Microsoft Business Intelligence Blog [Macaw] (Weblog) by jorg on 03-28-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
My session at SQLBits II - What Are You Waiting For?

Thankyou to all those who attended my session "What Are You Waiting For?" last Saturday at SQLBits II in Birmingham. There was some great feedback and constructive comments which I will incorporate when I deliver the session at the European SQLPASS conference next month in Germany ( http://www.european...

Posted to Christian Bolton's SQL Server Blog (Weblog) by Christian on 03-06-2008
SSIS – Non-blocking, Semi-blocking and Fully-blocking components

How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or threads? Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or fully-blocking. Before I explain how you can...

Posted to Jorg Klein's Microsoft Business Intelligence Blog [Macaw] (Weblog) by jorg on 02-27-2008
SQL Server 2008 – iFTS Introduction

This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008. This is one of my favourite features which I’ve had to keep stum about for quite a while. Firstly an introduction to full text. Full text is the feature in SQL Server that allows you to search text content...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 02-19-2008
Table Valued Methods on Type

I amd really getting into the use of UDTs as a way of packaging up SQL CLR code. I'm also looking into implementing an array type so I can do code like declare @s dbo . SQLArray set @s . AddKeyword ( 'sas' ) set @s . AddKeyword ( 'dog' ) Fo this to be realy useful you would want to...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 02-15-2008

Page 1 of 20 (197 items) 1 2 3 4 5 Next > ... Last »