The Industry Insiders

Insight from the heart of the IT industry

The Industry Insiders

  • 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...
  • 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 28 th at the Manchester Metropolitan...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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. ...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • Time and Relative Dates in SQL Server 2008 (TARDIS)

    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 .
  • 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...
  • An introduction to Powershell for SQL Server 2008

    Although I understand what Powershell is I didn't understand really get it until I worked with James on our last TechNet road shows. I did know that there were special extensions and support for it in SQL Server 2008, so I suggested to our good friend...
  • PowerShell in SQL Server 2008

    At the time of writing SQL Server 2008 is currently at the Community Technology Preview (CTP) stage. CTP 6 was delivered in February 2008 and includes a PowerShell provider. In this article I will explain what PowerShell is, why a PowerShell provider...
  • Setting up ActiveSync Between Exchange Server 2007 and Windows Mobile 6

    Adrian Beasley sent me this article the other day explaining how he managed to connect his Windows mobile 6 phone to connect to Exchange Server 2007. It's certainly worth a read if you're struggling to get connectied and are running out of ideas.....
  • ActiveSynching Between Exchange Server 2007 and Windows Mobile 6

    Adrian Beasley General Inspired by recent TechNet sessions and User Group meetings, where I heard expounded the wonders of Windows Mobile 6, and its close integration with Exchange Server 2007, I bought a top-of-the range mobile phone, an HTC TyTN11...
  • The Dilemma of Presenting SQL Server 2008

    Martin Bell runs the Scottish Area meetings of the UK SQL Server User Group , discusses the problems of deciding what to present on SQL Server 2008 to a bunch of developers in this entertaining article .
  • Data Presentation in Sharepoint

    Jennifer Stirrup from Aspective has written another great business intelligence article for us on her experiences of presenting data in SharePoint . Jennifer rightly points out that getting the numbers right is not enough, easy to understand and compelling...
  • What’s new in SQL Server 2008 - dilemmas!

    The other week I was asked by Colin Mackay of Scottish Developers to do a 15 minute talk on “What’s new in SQL Server 2008” for the Community Launch of Visual Studio 2008 and Windows 2008 in Glasgow. So I set about putting some slides together in Power...
  • Representation of data in Sharepoint

    Let’s be honest - it can be frustrating and difficult to have conversations with users over things like report colour, graphics and so on. For some very bright technically-focused people, a real pain point is the ‘soft stuff’ regarding the presentation...
  • Business Intelligence and the importance of users

    It's about time there were a few business intelligence posts on Industry Insiders so I am pleased to get an article about the Microsoft BI and the importance of users in form Jennifer Stirrup from Aspective - a Vodafone company. Jennifer has over ten...
  • Microsoft BI and the importance of users

    Recently, I took part in a discussion, where a number of people were debating the need to have a business representative or business-focused Project Manager involved in the design stages of a data warehouse. My own view is that business users should have...