sql server

A 5-post collection

SSRS .rdl file will not open in design view in Visual Studio

So you've got a SQL Server Reporting Services .rdl file and you want to open the report in Visual Studio and modify it. But it just keeps showing you the XML of the report. You've installed all the right SQL Server Data Tools / Business Intelligence Studio (BIDS) bits for your »

TechEd - Helicopter ride

If you follow me on Twitter you probably saw my delirious excitement about the helicopter ride I won. There was a competition and the Windows Server 2012 team were giving away these joyflights as a prize. I was fortunate enough to win in the first round and went for a »

TechEd: Real world SharePoint Customisation - IT Pro v Developer

In this session Jeremy Thake and Mark Rhodes took us through both sides of SharePoint customisation, pitting developers against IT pros.  Jermey started by taking us through a common scenario – the blame game. Customised SharePoint performs slowly, devs are guilty until they prove themselves innocent and need to prove their »

TechEd - Introduction to SharePoint 2013

Before attending this session I had downloaded and installed a preview of SharePoint 2013 and had a bit of a play with it. But this session was very helpful and well presented. The first part of the presentation was about My Sites and social features in SP2013. The My Sites »

SQL Server – cannot connect to named instance

Problems connecting to your newly installed SQL Server instance? Did you happen to create a named instance (e.g. sql01)? Microsoft SQL Server named instances use dynamic TCP ports and rely on the SQL Browser service to provide the port number to the client in order to establish a connection. »