Toluu

The Industry Insiders

Insight from the heart of the IT industry

USING SQL Server Integration Services to retrieve data from an IBM AS400October 1

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 and Data Transformation Services, at least it’s easier now to find out where it’s all going wrong, but as Jenny points out it’s essential to have the right drivers and hotfixes for SSIS for this to work.

All about Nothing- SQL Server Nulls in PowershellSeptember 15

Finding stuff about one Microsoft technology isn’t too hard it’s when you try and use two things get a little harder at Adrian J. Beasley found out when he was looking for nothing in particular; the use of SQL Server nulls in a Powershell script.  Having got the answer it would be rude not to share it so he’s written a short article to show you how.  You might also want to check Richard Siddaway’s introduction to Powershell for SQL Server while you’re here.

A Look into data privacy in the cloud computing worldAugust 21

Leonard Chung, CEO of Syncplicity.com, discusses issues around web privacy and data protection laws his company deals with in the world of online storage.  Leonard and I dive deep into legal world of privacy statements what these types of documents actually mean for the industry.

 

Leonard Chung, President & CEO

Leonard is an experienced entrepreneur with a particular emphasis on developing and delivering version one products and ideas. Notable past projects include SETI@home, Windows PowerShell, and internet storage company Scale Eight. Past collaborators include RISC/RAID inventor Dr. David Patterson and ACM Turing Award Winner Jim Gray.

Leonard received a B.A. in Computer Science and a B.A. in Cognitive Science from the University of California, Berkeley.

 

 

read the article

Upgrading to SharePoint 2007June 30

In BI and in SharePoint there is a great community which transcends the many partners, contractors etc. that specialise in this field.  We all keep in touch as we move companies and change roles as best we can using LinkedIn, Face book etc.  So I asked a friend of mine Darren Wray what he was up to know he runs a large Sharepoint Practice (and Microsoft Gold Partner) called Interakting and he mentioned all the upgrade work they were doing, usually as part of a large overhaul of the design of an older site.

I thought that there would be a lot of good advice coming form this work so Darren has asked one of his top SharePoint guys Raymond Little to write this up and so you can read all about it here

Time and Relative Dates in SQL Server 2008 (TARDIS)May 27

Martin Bell, MVP and time lord has been getting to the bottom of the new date and time data types in SQL Server 2008 in this practical and useful article.