Yukon Passwords

• by Randy Dyess

• SQLServerCentral.com

• Security

Some good info on password changes in Yukon (SQL 2005). Based on the beta, but worth taking a look at.

Null Functions (Arent those Meetings?)

• by Dinesh Priyankara

• SQLServerCentral.com

• Miscellaneous

Dinesh did a little research on nulls and was kind enough to package it up for us. How many of you know or use NULLIF? Or COALESCE? Handy stuff!

Dump SQL Permissions

• by Chad Miller

• SQLServerCentral.com

• Administration

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.

Review of Programming Microsoft SQL Server 2000 with Microsoft Visual

• by James Travis

• SQLServerCentral.com

• Miscellaneous

We get books in occasionally for review and have started making them available to our existing authors. Jim was interested in this one - turns out he didn't find much to like. If you're a beginner it might be a better fit. Or maybe you've read the book and disagree?

What You Don't Know

• by Andy Warren

• SQLServerCentral.com

• Miscellaneous

A very short article that discusses how nulls can ruin your day if you don't understand how they behave when you concatenate.

Review of ApexSQL Report v4.3

• by Mike Pearson

• SQLServerCentral.com

We had Mike take a look at this product recently and he found a lot to like. He also had some suggestions about ways the product could be improved - interesting since you get free upgrades for life with this product. This is a very good walk through of the product.

Yukon Delayed Again and Named

• by Brian Knight

• SQLServerCentral.com

• News
• Uncategorized

Microsoft confirmed today that it has delayed Yukon yet again. It also announced that Yukon has an official name and will have another beta added to the development cycle. Get all the info here and share with Microsoft your thoughts about what features are important to you.

Worst Practice - Not Qualifying Objects With The Owner

• by Christoffer Hedgate

• SQLServerCentral.com

• Miscellaneous

Regular columnist Chris Hedgate follow up on Andy's recent article about Worst Practices with one of his own. This is worth passing on to your development team.

Reporting Services!

• by Mike Pearson

• SQLServerCentral.com

Mike takes a good first look at Reporting Services. We're trying to add some coverage of this interesting new product. This gives a good overview from a real user perspective.

A DTS Data Store

• by Bruce Szabo

• SQLServerCentral.com

• DTS

Looks at some basic concepts of DTS and a couple ideas for putting it to work.