SQL Server 2005 Reporting Services – what is new? Active Views – what happened to it? Report Builder – what is it?

These are pretty common questions that keep popping up when I work with folks. So…. some answers… SQL Server 2005 Reporting Services – what is new? We are adding new functionality for Reporting Services in SQL Server 2005 – some of the changes are at the level of addressing the “niggly” bits and some much…

2

SQL Server 2005 Webcast week in December – 15 to enjoy!

Get in the beer/milk, pocorn/doritos, a video/dvd for your partner/kids/familiy pet to watch  – and sit down in you most comfy chair, turn on your PC and enjoy 5 evenings of SQL Server 2005 Webcasts. The series is running between December 6th 2004 and December 10th 2004. For details visit http://msdn.microsoft.com/SQL/2005Webcasts. Enjoy!

5

Microsoft announcement on dual and multicore processors 19th Oct

We yesterday announced the decision to treat dual-core and multicore processors as though they are just one processor for the purposes of licensing our per-processor server software. You can find out more at http://www.microsoft.com/licensing/default.mspx. Good news…

0

Focus on Architecture and Architects in the UK

Just wanted to call out some of the work that we doing out of Microsoft UK. This year we have increased the focus on Architects and Architecture  We have a UK site http://www.microsoft.com/uk/msdn/architecture/default.mspx and newsletter and run regular events just for architects – watch out for “Architects Forum” events. You can find presentations from the last delivery (on MDA/Software…

1

Class room based training can be good – honest! SQL Server 2005 development in 5 days – day 2…

This week I am lucky enough to be on a five day training course for SQL Server 2005 delivered by Niels Berglund http://sqljunkies.com/WebLog/nielsb/. The course has been created for early adopters we are working with – but shares a lot of content and structure with the course DevelopMentor can deliver publicly http://www.develop.com/uk/training/course.aspx?id=180. I have a…

0

And for SQL Server 2000 – encrypting/hashing passwords…

Well – no sooner do I post on “SQL Server 2005 Encyption” than someone asks me “and what about SQL Server 2000?”. One route is not to store an encrypted password – instead store a hash of the password (Also knows as “one way encryption”) There are a couple of nice articles I would recommend…

0

SNIPPET: SQL Server 2005 Encryption

SQL Server 2005 Beta 2 adds security to your data through selective encryption of sensitive information with functions that convert clear (character) text to ciphertext (varbinary). You can specify symmetric keys for better performance or asymmetric keys for greater security. For example to insert data encrypted using the certificate “‘JanainaCert02′” (from Books Online) INSERT INTO [AdventureWorks].[ProtectedData04]…

0

Bits and bobs on SQL Server 2005 and SQL Server 2000 BI

Hi folks, I’m sitting in a BI course – and must admit I’m slightly lost. With no history of BI whatsoever, I’m finding it a touch of a struggle. My temporary solution – use the Internet and find some alternatives while the instructor carries on talking 🙂 Probably worth sharing: Lots of new BI webcasts…

0