belle’s sql musings

SQL Server Scalability etc – Free Ebooks

Posted in Ebooks, Resources/References by belle on November 7, 2008

RealTimePublishers has a whole bunch of free ebooks:


The Definitive Guide to Scaling Out SQL Server 2005
The Definitive Guide to Scaling Out SQL Server 2000
The Essentials Series: Optimizing Database Connection Performance
The Shortcut Guide to SQL Server Infrastructure Optimization


Few other ones that might be of interest:

The Administrator Shortcut Guide to VB Scripting for Windows
The Definitive Guide to Building a Windows Server 2008 Infrastructure
The Definitive Guide to Windows Server 2003 Terminal Services Updated Edition
The Shortcut Guide to Selecting the Right Virtualization Solution
The Shortcut Guide to Virtualization and Service Automation




Soaking in SQLServerPedia

Posted in DBA Toolbox / T-SQL Scripts, musings, Resources/References, Tutorials by belle on October 31, 2008

One of the bloggers I follow is Brent Ozar. I tell you I’m a fan. I like the way he writes his stuff.

Anyway, he blogged about The Problem With SQL Server Training Today, and The Answer to SQL Server Training Problems a week or so ago. And this is the answer – SQLServerPedia  – SQL Server Knowledge and Advice Straight from the Experts.

So in between giving out candies to cute little Indiana Joneses, pirates of the Caribbean, vampires and dead cheerleaders, I’ve been soaking in SQLServerPedia (geeky ‘no?). So far, so good. I’ll be a frequent flyer.


PS – and if you’re a DBA, you’ll find great laughs in this post : Somebody Created a Halloween Monster #SQLputdowns

Tagged with:

Clustering SQL Server 2005 Videos … and some hacking

Posted in Resources/References by belle on October 11, 2008

Brian Knight has posted a lot of good videos on JumpStartTV, including the following clustering videos:

Plus one video on how to hack (read: SQL Injection), and prevent hacking, SQL Server:

These are good videos, some of them almost an hour long like the Hacking video, most in the 5-15 minute duration. What’s also good about the site is  on the sidebar, the “pre-requisite” videos are mentioned.

JumpStartTV also has videos on Administration, High Availability, Performance Tuning, SMO, Data Warehousing and SSIS (Brian Knight made a whole bunch on SSIS), to name a few.

The videos are free, but JumpStartTV requires registration.

White Papers: Backup/Recovery, Performance Tuning

Posted in Issues/Troubleshooting, Resources/References by belle on October 11, 2008

SQL Server 2005 Cheat Sheet

Just came across this SQL Server Developer Fact Sheet made by Xander Zelders of DotNet4All. It’s a handy cheat sheet, with all the common stuff you need as a dev:

  • Data types, common string/system/date and time/math/cursor functions
  • SARGability
  • Concise checklist for creating indexes and fast queries
  • Execution plan icons (aptly color coded – red means no-no!)
  • … even connection strings!

Pretty handy and organized reference. Thanks Xander!

Tagged with:

What’s on your RSS Reader?

Posted in Resources/References by belle on October 7, 2008

I love Google Reader. It feels like I’ve learned so much just by reading and skimming through blogs and articles that other people put out. It is also amazing how a lot of really smart, knowledgeable people write because they want to share their experiences and knowledge.

Anyway, these are some of the SQL Server sites and blogs I read and monitor (in no particular order):

I also really like reading

Fun Stuff!

I’m using Google Reader Discovery function to help me discover some more good blogs/sites on SQL Server, but it cannot keep up with me 😉

Follow Up:

I didn’t mean to forget – I also read Brad McGehee‘s articles a lot! He is the founder of Check out these articles : Brad’s SureDBA Checklist, Professional Certification for DBAs and the rest of his articles.

Free SQL Server Ebooks/Resources

Posted in DBA Toolbox / T-SQL Scripts, Ebooks, Resources/References by belle on October 4, 2008

Free ebooks 🙂 Grab them while they’re free. (BTW, I purchased Grant Fritchey’s ebook, now RedGate is offering it for free)

SQL Server 2008 MS Press Free Ebook

How to Become an Exceptional DBA

Best of SQL Server Central

Brad’s Sure Guide to SQL Server 2008

Brad’s Sure DBA Checklist

RedGate’s SQL Server DBA Best Practices

Dissecting SQL Server Execution Plans

Tagged with:

SQL Server 2008 Jumpstart and other resources

Posted in Ebooks, Resources/References, Tutorials by belle on October 4, 2008

Just a short compilation of SQL Server 2008 resources (white papers, ebooks, videos, blogs)

Blog Posts

Upgrading to SQL Server 2008!45041418ECCAA960!1019.entry

10 Reasons Why SQL Server 2008 Is Going to Rock

The SQL Server 2008 Status Bar Custom Colors (why it’s not trivial!)

Notification Services Support in SQL Server 2008 🙂

Additional MS Training/Resources

SQL Server 2008 Jumpstart

Microsoft SQL Server 2008 – Learning Portal

Free SQL Server 2008 Ebook from MS Press

SQL Server 2008 Videos

SQL Server 2008 Virtual Labs

Webcasts: 24 Hours of SQL Server 2008 for IT Professionals

Webcasts: 24 Hours of SQL Server 2008 for Developers

Free SQL Server Video Training + Podcasts

Posted in DBA Toolbox / T-SQL Scripts, Resources/References, Tutorials by belle on September 20, 2008
Tagged with: