SQLServerPedia

This post is coming to you through our new and improved web server.  I’m not saying we’re Digg-proof, but we’re in pretty good shape, and we’re making more infrastructure improvements as we speak.  That stuff is mostly invisible to you, dear reader, so let’s cut to the stuff you’re interested in:

New Wiki Articles

We’ve added several new articles recently:

• Find Tables Without Primary Keys – a T-SQL script by Jason Strate.
• Indexing Partitioned Tables – Michelle Ufford talks about what a partitioned index is and when you should use one.
• Killing Sessions with SQL Server Integration Services – learn how Chris Webb uses SSIS to make database administration easier.
• Moving SQL Server Logins Between Servers – Greg Low explains why logins fail after a database is restored to another server.
• SQL Server Troubleshooting Tips and Tricks – Michelle Ufford shares some of her favorite SSMS shortcuts.
• Using Checksum to Load Data into Slowly Changing Dimensions – Steve Novoselac shows why the SCD wizard isn’t always the fastest way to load data.
• Using the Right Indexes for Optimal Performance – Pinal Dave shows query plans of clustered and nonclustered indexes.

I’d like to thank these bloggers for working with us to get the articles through editing and into the wiki.

Upcoming “Best of SQLServerPedia” Publications

This may come as a bit of a shock to you, so you might want to sit down.

It turns out that not everyone on the planet has been to SQLServerPedia yet.

I know – it’s crazy.  Fortunately, I work in the marketing department, so I can fix that problem.  (How often do you hear SQL guys say that, huh?)  PASS Summit attendees in Seattle get a handout bag with session schedules, attendee information and ads from vendors.  We’re putting together a “Best of SQLServerPedia” publication to include in the handout bag.  It’ll have some of the best wiki articles contributed by you folks.

If you’d like to see your name in print and have thousands of DBAs carrying it around with them, think about contributing an article to the wiki.  Read our article on How to Contribute New Articles, and if you’re stumped for topics, read our Article Requests.  We can also repurpose your older blog entries into an article too: I’m working with Gail Shaw and Jason Massie to turn several of their related posts into long wiki articles.

Top Blog Posts in the Last 30 Days

Here’s what’s been popular lately:

1. Data Mining the StackOverflow Database by Brent Ozar (whoa, that’s the first time I’ve come out on top in forever)
2. SSMS 2008 Saving Changes Not Permitted by Pinal Dave
3. Implementing Real Analysis Services Drilldown in a Reporting Services Report by Chris Webb
4. Grant Truncate Table Permissions in SQL Server by Bob Horkay
5. Grant Execute Permissions on All Stored Procedures to a Single User by Jeremiah Peschka
6. String Concatenation on a Text Column by Colin Stasiuk
7. How to Check Existence of a Temp Table Before Dropping by Pinal Dave
8. My Top 5 SQL Server Indexing Best Practices by Tim Ford
9. What TCP Port is SQL Server Running Under? by Colin Stasiuk
10. MySQL Dump File to SQL Server by Bob Horkay

Next time around, I’ll include the top 10 wiki articles too.