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

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

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

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

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

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 is useful and provide some examples of how you can use PowerShell with…

6

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, (specifically because it ran WM6,) and entered into a contract (something to do with a…

1

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 Point, the first one was obvious a…

2