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

All about Nothing- SQL Server Nulls in Powershell

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…

0

Testing for Database Null Values from PowerShell

PowerShell is super, but its documentation is still lousy. You might think that how to test a database field for a null value would be straightforward, and indeed it is, but it ain’t documented anywhere. I’ve just spent the afternoon searching and eventually had to work it out for myself. So here it is, with…

1

A Look into data privacy in the cloud computing world

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…

0

Upgrading to SharePoint 2007

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…

0

Upgrading from SPS 2003 to MOSS 2003

Upgrading from SPS 2003 to MOSS 2003 Recently I have been involved in upgrading our intranet from SPS 2003 to MOSS 2007 and I know this is something that is going to be increasingly important as more and more companies look to take advantage of the benefits of MOSS. With this in mind I have…

1

Martin Bell

  Martin Bell has been a freelance computer consultant in the UK for over 23 years. He has worked on many relational database systems and since 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003. He runs the Scottish Area meetings of the UK SQL Server…

3

Time for a Date?

As a DBA I wear many hats! If I had to choose a hat for my data architect role it would probably be a nice white panama, the sort you see in the Agatha Christie re-runs on ITV3, but I digress!. As a data architect you extol the virtues of “correctly data typing” in your…

0