Fabulous news on Reporting Services in SQL Server 2005

If anyone ever doubted whether Microsoft listens to its customers, look no further than the following announcement from Paul Flessner:


Changes to the SQL Server 2005 product line. In February, we announced the product line for SQL Server 2005. As part of this announcement, we revealed that Reporting Services would ship with Standard and Enterprise Editions and that Report Builder would be available with Enterprise Edition. Based on your feedback, and because we believe that reporting is a core scenario for all customers, we’ve made the decision to include Reporting Services in all versions for SQL Server 2005 including Express, Workgroup, Standard and Enterprise Editions. In addition, Report Builder will be available with Workgroup, Standard and Enterprise Editions.


This is simply an outstanding outcome and directly based on feedback that has been acted on. Thank you Microsoft!


 

New T-SQL Syntax

Is this one T-SQL statement or two?


CREATE SCHEMA marketingdata AUTHORIZATION peter


CREATE TABLE products (RecID int IDENTITY(1,1), ProductName varchar(35))


Yep, you wouldn’t be alone if you said “two“. But it’s only one. Had this come up in the classes I’ve been running last week on SQL Server 2005 development. Some students highlighted it a line at a time, some ran the batch. The results are then different. If you run it as a batch, the table gets created in the new schema, otherwise it’s in the default schema of the user executing the commands. Can’t say I like the syntax but it’s an example of the table definition clause (optional) in the CREATE SCHEMA statement. See more in Books Online under CREATE SCHEMA.


 

Now Mitch has me doing it

Now Mitch has me doing it. I’ll get to some more of Canada one day. Promise :-) 


Your Travel Profile:

You Are Extremely Well Traveled in Australia (100%)
You Are Extremely Well Traveled in the United Kingdom (88%)
You Are Very Well Traveled in the Northeastern United States (71%)
You Are Well Traveled in the Western United States (53%)
You Are Well Traveled in New Zealand (50%)
You Are Somewhat Well Traveled in the Southern United States (38%)
You Are Somewhat Well Traveled in Western Europe (36%)
You Are Somewhat Well Traveled in the Middle East (25%)
You Are Somewhat Well Traveled in the Midwestern United States (25%)
You Are Somewhat Well Traveled in Asia (21%)
You Are Mostly Untraveled in Eastern Europe (20%)
You Are Untraveled in Africa (0%)
You Are Untraveled in Canada (0%)
You Are Untraveled in Latin America (0%)
You Are Untraveled in Scandinavia (0%)
You Are Untraveled in Southern Europe (0%)