Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

SQL Server Relational and Beyond

News

  • This posting is provided "AS IS" with no warranties, and confers no rights.
  • Technorati Profile

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Mini Computing Performance
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...
SQL Server 2008 Report Builder v2.0 RC1
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...
Career Limiting Move, SQL Server 2008 Transparent Data Encryption
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...
Analysis Services Backup
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...
Managing SQL Server 2008
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...
Flying with Small Business and Essential Business Server
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...
Licensing in a Virtual World
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...
SQL Server 2008 not just for DBAs
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...
SQL Server 2008 Intellisense support for SQL 2000/5
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...
SQL Server 2008 Unleashed
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...
Who stole my Report Builder
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...
SQL Server 2008 Released
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...
SQL Server Migration
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...
SQL Server 2008 TechNet Webcasts
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...
Reporting Services drill-through for a matrix report
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...
More Posts Next page »
Page view tracker