Well… 11 of 11 has completed. Friday was our last chat – until next time ;). It was a summary event where I took a slightly different spin on things focusing on grouping technologies by the amount of effort that’s needed to implement them. Simply put, we looked at the technologies in order of what gives you the biggest bang for the buck. We ended the session with a ton of great questions (as always!) and there was even a question on the origin of foo (make sure to also see fubar).
First, there were a few links that I wanted to provide from the session, I’ll start with those:
- Demo Script on SQL Injection and using QUOTENAME to prevent SOME forms of injection: SQLInjection.sql (3.59 KB)
- TempDB Optimizations referenced in other blog entries: 8 Steps to Better Transaction Log Throughput and Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB
And, we also talked about Migrations:
- SQL Server Migration Assistant for Oracle V2.0,
- Solution Guide for Migrating Oracle on Unix to SQL Server on Windows
- SQL Server Migration Assistant for Access – CTP1 released in May 2006 (read this blog entry for details)
- SQL Server Migration Assistant for Sybase – CTP1 released in May 2006 (read this blog entry for details)
- Migrate to SQL Server with a (limited time offer) discount of up to 50%
Finally, capacity planning:
- Calculate the amount of space needed for your tables (calculate this as rows per page and then required pages as MB)
- Calculate the amount of space needed for your indexes (you can use sp_spaceused to get a current ratio of index to data and then use that OR you can estimate 1-3times your current data in indexes…yes, if you have 10GB of tables – you should estimate 10-30GB for indexes)
- Calculate in your estimate on future growth
- Take your single largest table and multiply by 1.5 for free space. (Use 2.5 IF you’re going to use ONLINE index operations). So, if the single largest table is 3GB then I’d add 7-8GB for free space)
- Add a “just in case” extra 10-20%
- And, I didn’t mention this BUT you should also include alerts to help you monitor space usage and significant changes to your free space!
And that wraps up the series. Wow – I can’t believe how many of you joined in for questions as well as stayed on until the end. It’s really great that so many of you are still having fun with SQL Server as well. I look forward to another series with you…at some point! In the interim, here are a few places where I’ll be:
- DotNetRocks – Friday, May 26, 2006 – 15:00-17:00 Pacific Time
- Microsoft Tech Ed in Boston, MA – June 11-16, 2006. NOTE: The event is sold out HOWEVER, you can still attend pre-conference workshops and ours will definitely be intense, informative and fun! The abstract is lame but the content is all about designing production systems for performance, reliability, manageability and useability.
- Immersion Event “Indexing for Performance” with Trivadis in Zurich, Switzerland – June 26-27, 2006
- Microsoft Tech Ed for Developers in Barcelona, Spain in November 2006
- SQL Connections in Las Vegas, NV in November 2006
- Microsoft Tech Ed for ITProfessionals in Barcelona, Spain in November 2006
SQLskills Immersion Events – in the US… will be announced shortly. The BEST place to be when we announce the dates for these events is a subscriber on SQLskills. Subscribing is FREE and the announcements are going to be later this month. Here’s a link to directly subscribe on SQLskills: https://www.sqlskills.com/login.aspx.
Thanks again for attending the series! It was great fun. I’ll post a final blog entry with ALL of the links as well as all of the survey links. I know that they’re going to send me these so that you can get easier access to them.
See you next time,
kt