Martin Bell on SQL Nuggets

Martin Bell MVP and SQL Bits Organiser, wants to promote the idea of SQL Nuggets.  Basically these are 5-10 minute slots on something byte sized (ouch!) at community events where anyone can grab the mike and share their knowledge.  Martin has a good example in this article around activity monitor. So check the article both…

0

SQL Nuggets

It’s been a while since my last entry for Technet Insiders, one reason for the delay is that I’ve been very busy writing and presenting at SQL Server User Groups and organising our forth SQLBits Community Conference on March 28th at the Manchester Metropolitan University. Anyone who has been to a SQL Server User Group…

1

Speaking at SQL Bits

In this unusual Industry post I have got the industry insider on camera to discuss why you should get involved in the premier SQL community event, SQL Bits. Take it away Chris Testa O’Neill   SQL Bits goes fourth is on  28th march this time in Manchester. If you decide you would like to get…

0

USING SQL Server Integration Services to retrieve data from an IBM AS400

Thanks again to Jennifer Stirrup from Aspective (A Vodafone company) for writing up how she gets data into SQL Server using its in built Integration Services (SSIS) from an AS400 in this useful guide. This takes me back to my first ever BI project which was doing the same thing only with SQL Server 7…

0

SQL Server: Using SSIS to retrieve data from AS400

Using SSIS, getting data from one SQL Server to another SQL Server is straightforward enough. However, what about getting data from other non-Microsoft data sources? Here, we will discuss the integration of data from an AS400 system with SQL Server 2005, and insertion into a SQL Server 2005 data warehouse. There isn’t much documentation on…

1