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

Great Barr School Implements OCS in 8 months

I recently had the opportunity to interview Alex Pearce, Microsoft MVP and network manager of Great Barr School.  In the interview he goes on the to discuss the state of the school prior to his arrival and then fast forwards to the present day where teachers are using technologies like Windows Mobile and Communicator to…

0

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

Chris Testa O-Neill

Chris Testa-O’Neill is the Database Product Manager at Remarc Group Ltd. He specialises in SQL Server Business Intelligence Solutions and teaches all Microsoft courses in the SQL 2000, 2005 and 2008 product range. He also conducts closed company sessions and consults on thier business implementations of SQL Server. Chris is also a technical author is…

1

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