Hi Folks, SQLDownUnder podcast #2 is now available for download from www.sqldownunder.com. The guest for this show is Hilary Cotter, SQL Server MVP and replication guru. Regards, Greg
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, … Continue reading Fabulous news on Reporting Services in SQL Server 2005
I did a Technet webcast last Saturday morning. It’s A SQL Server DBA’s Guide to CLR Integration and is now online here.
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 … Continue reading New T-SQL Syntax
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 … Continue reading Now Mitch has me doing it