belle’s sql musings

SQL Server Scalability etc – Free Ebooks

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

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
  • Basic SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER syntax
  • 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 SQLServerPerformance.com. 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
http://csna01.libredigital.com/?urss1q2we6

How to Become an Exceptional DBA
http://www.red-gate.com/products/sql_backup/offers/brad_exceptional_dba_ebook.htm

Best of SQL Server Central
https://www.red-gate.com/Dynamic/Downloads/DownloadForm.aspx?download=ebook1

Brad’s Sure Guide to SQL Server 2008
http://www.red-gate.com/specials/ToolbeltBradsure.htm?utm_source=ssc&utm_medium=email&utm_content=Bradsure-080925&utm_campaign=sqltoolbelt

Brad’s Sure DBA Checklist
http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/

RedGate’s SQL Server DBA Best Practices
http://www.simple-talk.com/content/file.ashx?file=1208

Dissecting SQL Server Execution Plans
http://www.red-gate.com/specials/Grant.htm

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
http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!1019.entry

10 Reasons Why SQL Server 2008 Is Going to Rock
http://angryhacker.com/blog/archive/2008/06/20/10-reasons-why-sql-server-2008-is-going-to-rock.aspx

The SQL Server 2008 Status Bar Custom Colors (why it’s not trivial!)
http://blog.jemm.net/2008/08/12/sql-server-2008-management-studio-tip-status-bar-custom-colors/

Notification Services Support in SQL Server 2008 🙂
http://weblogs.sqlteam.com/joew/archive/2008/09/10/60708.aspx

Additional MS Training/Resources

SQL Server 2008 Jumpstart
http://sqlserver2008jumpstart.microsofttraining.com

Microsoft SQL Server 2008 – Learning Portal
http://www.microsoft.com/learning/sql/2008/default.mspx

Free SQL Server 2008 Ebook from MS Press
http://csna01.libredigital.com/?urss1q2we6

SQL Server 2008 Videos
http://go.microsoft.com/?linkid=9333556

SQL Server 2008 Virtual Labs
http://www.microsoft.com/sqlserver/2008/en/us/virtual-labs.aspx

Webcasts: 24 Hours of SQL Server 2008 for IT Professionals
http://go.microsoft.com/?linkid=9333557

Webcasts: 24 Hours of SQL Server 2008 for Developers
http://go.microsoft.com/?linkid=9333558

Free SQL Server Video Training + Podcasts

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