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 Richard Siddaway that he might be best placed to right an…


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…


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… Read it here… Some extra resources that may also be of interest:…


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…


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 visualtisations are also needed by the business.


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…


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 of data in reports. If the data is right, then why does 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 years experience in working with SQL Server, and has specialised in…


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 input at every stage of the development. User buy-in is absolutely critical…