Browse by Tags
All Tags »
SQL Server 2008 (RSS)
Performance Management doesn’t just apply to SQL Server, it is just as important in all aspects of engineering. My cousin Stuart is one such engineer, he takes a standard Mini Cooper (the old kind) and adds a turbo and an Emerald engine control
Read More...
As I mentioned a few weeks ago the end user reporting tool for SQL Server 2008, Report Builder v2 didn’t release with SQL Server 2008. There was an RC0 version of it with SQL Server 2008 RC0 and when SQL Server 2008 released this download disappeared
Read More...
Transparent data encryption (TDE) in SQL Server 2008 enterprise edition is a great tool for protecting your data ‘at rest’ , but you need to be careful when you use it. TDE only really comes into play when you move the database to another location (hence
Read More...
Backing up a cube is not an ideal experience in SQL Server 2005 for two reasons, it’s a manual process to schedule a backup and as the size of the cube grows the backup time increases exponentially i.e double the size of the cube and the backup time and
Read More...
There are loads of add-ins and management stuff from Microsoft and other vendors to make taking care of SQL Server easier, and in case you haven’t noticed SQL Server 2008 has now been released so will those tools work with the new version? For the most
Read More...
Small Business Server (SBS) is like flying a single engined aircraft. There’s a lot of stuff going on but you only have one box to worry about and backup and interoperability are all a lot easier because of this. Flying a twin engined aircraft is
Read More...
Even if you work for Microsoft licensing can be complicated. I am pretty confident on what’s what with SQL Server, but I was in TV land yesterday at a large broadcaster, and they are looking to adopt Windows Server 2008 and SQL Server 2008 as a standard
Read More...
I am sure SQL Server is administered by many ‘accidental’ DBAs i.e. IT Professionals who get saddled with looking after databases, while performing a bunch of other infrastructure management tasks. One of my good friends Jonathan Noble at Newcastle
Read More...
Intellisense for SQL, how hard is that? Well judging for how long we have been asking for it the answer is “very”. Also talking to the product team it is actually much harder than for C# VB etc. because of the nature of SQL. Anyway intellisense
Read More...
Although the official UK launch of SQL Server 2008 merged in with the launches of Windows Server 2008, and Visual Studio 2008 back in March, we wanted to celebrate the actual release as well. So please join us in TVP on 10th September for SQL Server
Read More...
Anyone who has tried Report Builder v2, aka Report designer Preview, blue etc. will have noticed that it isn’t fit for purpose yet. By this I mean it is not in a state in which you could give it to a what Microsoft calls an information worker i.e.
Read More...
I hope you are sitting down, and don’t have a coffee in your hand when you read this, but SQL Server 2008 released at 17:00 GMT today! This is good news for all the people who have asked me about release dates as they can now start to plan and deploy
Read More...
I knew that there was a toolkit to help move an application from Oracle to SQL Server, but I hadn’t appreciated that there was one for Sybase and Access these also now come in two flavours, one to move you to SQL Server 2005, and one for SQL Server 2008:
Read More...
If you can’t find anything to watch on the telly tonight… TechNet Webcast: Security Enhancements in SQL Server 2008 (Level 300) https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032364703&EventCategory=5&culture=en-US&CountryCode=US
Read More...
One of the great things about working in Microsoft is the huge e-mail threads with where we share problems and resolve them, as you get to learn loads of tips and tricks. One of the nightmares of working at Microsoft is the huge e-mail threads with where
Read More...
