If you do a lot of scripting, SP2 for SS 2005 is going to be a must-have. Luckily it was just released. Here are some of the BIG improvements for people who like to script a lot: Generate Script Wizard. You can now specify that the scripted objects include a DROP statement before the CREATE statement.  Scripting of objects into separate ...

I recently did some book reviews for the ASP Alliance (which will be throwing up a SQL Server Reporting Services portal in the near future).The reviews are for (links are to the reviews):Hitchhiker's Guide to SQL Server 2000 Reporting ServicesandThe Rational Guide to SQL Server Reporting ServicesThe reviews were easy to do as both books are ...

Paolo has started up his own blog on SqlAdvice. Make sure to check it out and subscribe. The focus of his blog will be on Experimental SQL technologies, including AI and self generating SQL entities. Should be a great ride.

In SQL Server 2000, if you use Enterprise Mangler to script your tables, you need to watch out that your constraints don't get turned off. For example, here's a snippet generated from the Northwind.dbo.Employees table (just using the right click > All Tasks > Generate SQL Script wizard). ALTER TABLE [dbo].[Employees] WITH NOCHECK ADD ...

I've got a new project coming up that Involves SQL Server 2005 reporting services. I've got a good handle on the basics, but the project will be on a tight deadline, and I'd like to have as much 'backup' as possible, so I went out to Amazon.com to find some books that may prove handy. To be honest, projects are always a great excuse to ...

Microsoft's Paul Flessner just sent out an email to all of the official Yukon Beta Testers: SQL Server 2005 will ship the week of November 7, 2005. Very cool news. One of my favorite new features: The Oracle Conversion Wizard... muhahahah.

Here's a shout out to SqlAdvice.com's newest blogger: Bill Swartz. SqlAdvice is happy to have Bill onboard. Bill's been doing a great job of helping people on the lists, and sharing his insights with others. Today he posted an incredible insight to the lists on the perfect metaphor for SQL Server's ''text in row'' option. Happily he posted ...