Welcome to TechNet Blogs Sign in | Join | Help

April 2005 - Posts

Wednesday, April 27, 2005 7:46 AM

SQL Server Reporting Services: Secure reports, passing parameters and User!UserID

After taking a customer query regarding securing report parameters I found this blog entry from Tudor Trufinescu – I thought I would share it with you.  The moral of the story is – don’t pass sensitive parameters.   http://blogs.msdn.com/tudortr/archive/2004/07/20/189398.aspx
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Wednesday, April 27, 2005 5:30 AM

Yankee Group identified a sharp rise in companies' assessment of Microsoft's security level

For 3 or 4 years I’ve been telling people how Microsoft has made security and privacy the number one priority.  From this Yankee Group article (excerpt below) – it’s good to see perception change and that change based on customer experience.  
posted by Mat_Stephen | 0 Comments
Filed Under:
Wednesday, April 27, 2005 4:17 AM

Top Tip SQL Server Reporting Services fields cannot be used in headers or footers - work around

I'm grateful to Chris Hayes for this top tip. Reporting Services doesn't like you using data fields in its headers and footers - here are two ways to work around the problem Add a parameter to the report without a prompt (so the user doesn’t see it)
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Tuesday, April 26, 2005 11:33 AM

SAP and Microsoft Create 'Mendocino' Product to integrate Office, Exchange and SAP

Microsoft and SAP are to release a joint product to bring Office, Exchange and SAP together - code named 'Mendocino';  harnessing Web Services and Services-Oriented Architecture to Ease Integration You can find more info here http://uk.news.moneycentral.msn.com/ticker/article.asp?Symbol=US:MSFT&Feed=PR&Date=20050426&ID=4395944
posted by Mat_Stephen | 0 Comments
Filed Under:
Tuesday, April 26, 2005 6:03 AM

SQL Server 2005 Integration Services - Migrating SQL Server 2000 DTS tasks

I have extracted the following from a useful article: SQL Server 2005 Integration Services: Lessons from Project REAL, http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/SQL05InSrREAL.asp   SQL Server 2005 Integration
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Monday, April 25, 2005 8:11 AM

SQL Server 2005 feature comparison by edition

You can find which editons of SQL Server 2005 have which feature @ http://www.microsoft.com/sql/2005/productinfo/sql2005features.asp Essentially as you move from SQL 2005 Express edition through to SQL 2005 Enterprise edition you gain the features
posted by Mat_Stephen | 0 Comments
Filed Under:
Monday, April 25, 2005 5:36 AM

Download Microsoft SQL Server 2005 Express Edition: Community Technology Preview April 2005

Microsoft SQL Server 2005 Express Edition: Community Technology Preview April 2005 Download the Community Technology Preview (CTP) of Microsoft SQL Server 2005 Express Edition. Unlike beta releases that receive a much higher level of testing and feature
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Monday, April 25, 2005 3:53 AM

SP2 for Microsoft SQL Server Reporting Services is now ready for download

The Reporting Services team has just released Service Pack 2 of SQL Server 2000 Reporting Services! The service pack is available for download from the Microsoft Download Center: http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Wednesday, April 20, 2005 3:38 PM

Additional code samples based on the Business Intelligence Portal

Additional code samples based on the Business Intelligence Portal for the developer community
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Tuesday, April 19, 2005 3:44 PM

Want to hear the latest on SQL Server 2005 from the big cheese? Want to get a go-live-license for SQL Serever 2005 Express Edition?

I want to share with you a letter from Paul Flessner that has been sent to 'Testers of SQL Server 2005'.  Why?  Because if this is news to you, you are not a tester and if you’re reading this you are most likely interested in what’s going on
posted by Mat_Stephen | 0 Comments
Monday, April 18, 2005 4:49 PM

TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning

For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorksGO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1ALTER DATABASE AdventureWorks ADD FILEGROUP FG2GO
posted by Mat_Stephen | 0 Comments
Filed Under: , , ,
Friday, April 15, 2005 5:44 PM

Get SQL Server Analysis Services OLAP Online on your PDA Pocket PC

Have you ever been asked to do OLAP on a PDA – Pocket PC.  If you have this http://www.euroman.co.uk/pcktindex.html has to be the best answer.  I’ve seen it demoed and it rocks – its so cool; bringing scalable OLAP server power to your
posted by Mat_Stephen | 0 Comments
Filed Under:
Friday, April 15, 2005 10:10 AM

Feature comparison: Microsoft SQL Server 2000 Reporting Services vs Business Objects Crystal Reports / Crystal Enterprise

At last, here is a feature comparison between Microsoft SQL Server 2000 Reporting Services vs Business Objects Crystal Reports / Crystal Enterprise that I can actually point you to.  We've had our own internal one for quite sometime, but for what
posted by Mat_Stephen | 1 Comments
Filed Under: , ,
Friday, April 15, 2005 9:47 AM

Microsoft SQL Server 2005 Educational Webcast Series on TechNet

Sorry I'm a little late in alerting you to this SQL Server 2005 Educational Webcast Series on TechNet, which runs from March 21-May 18. This 10 part series will provide IT Professionals with a broad overview of the benefits of SQL Server 2005
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
Thursday, April 07, 2005 4:11 PM

Microsoft SQL Server 2005 fuzzy logic in matching and grouping - how does it work in SQL Server Integration Services?

Following on from a presentation 'First Look at SQL Server Integeration Services' to some MVPs here at TVP Reading, I am responding to the a question I was asked, 'how does SQL Server's fuzzy logic work'.  I was meant to explain how the confidence
posted by Mat_Stephen | 1 Comments
Filed Under: , ,
Wednesday, April 06, 2005 3:49 AM

Microsoft SQL Server 2005 Virtual Labs on MSDN

Are you ready to experience SQL Server 2005? Announcing the launch of the SQL Server 2005 Virtual Hands on labs. In these labs, you will get to experience many of the new features in SQL Server 2005 including CLR integration, XML support and deep business
posted by Mat_Stephen | 1 Comments
Filed Under:
Tuesday, April 05, 2005 10:48 AM

UK Technical Roadshow – a few places left so hurry if you want one

There are three technical tracks at the 2 day roadshow this year.  The second day is a ‘SQL Server 2005’ day with a number of sessions covering SQL 2k5 from three angles: ITPro (DBA), Developer and Security.   On the ITPro track there will
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Monday, April 04, 2005 8:12 AM

Two new free Microsoft SQL Server Reporting Services Report Packs released for IIS and Great Plains

From the blog hits I received the last time I posted some info on free report packs available for SQL Server Reporting Services, I'm sure many of you will be pleased to find we've just posted two more for IIS and Great Plains. Objective: The Report
posted by Mat_Stephen | 1 Comments
Filed Under: , ,