MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 6 of 10

Effectively Designing a Scalable and Reliable Database A Primer to Proper SQL Server Development SQL Server Mixed Workloads, Secondary Databases, Locking and Isolation, Part 6 of 10 Presented by Kimberly L. Tripp, SQLskills.com Q: Can I view a recording of this webcast?Part 6 can be replayed by clicking here. Q: Where can we get the demo scripts […]

PDC Pre-conference Workshop Resources…and what a list it is!

Brian A. Randell’s Blog: http://www.mcwtech.com/CS/blogs/brianr/default.aspxMCWTechnologies Website: http://www.mcwtech.com/ Kimberly L. Tripp’s Blog: http://www.SQLskills.com/blogs/KimberlySQLskills Website: http://www.SQLskills.com Presentation ResourcesPresentation in PDF formKimberly’s Demo ScriptsBrian’s Demo Scripts and Code Running SQL Server 2000 tools and SQL Server 2005 tools side-by-sideWe talked about re-registering all of your COM components and I didn’t have a slide for this. So, if SQL […]

Understanding TempDB, table variables v. temp tables and Improving throughput for TempDB

This is a much needed and much overdue blog entry… In 8 Steps to Better Transaction Log throughput, I mentioned a customer that was helped by TWO typical optimization problems I see. In that blog entry, I said I would write two blog entries – that one on transaction log optimization and another on common […]

MSDN Webcast Q&A: A Primer to Proper SQL Server Development, Part 5 of 10

Effectively Designing a Scalable and Reliable Database A Primer to Proper SQL Server Development New Features in Indexing and Index Maintenance Best Practices, Part 5 of 10 Presented by Kimberly L. Tripp, SQLskills.com Q: Can I view a recording of this webcast? Part 5 can be replayed by clicking here. Q: Where can we get the demo […]

Another Immersion Event ends…

Well…another custom Immersion Event ends…….. four days, 12 modules, nothing but SQL Server 2005: internals, availability and tuning. This week I delivered a four-day course titled: Building Highly Scalable, Available and Reliable Systems with SQL Server 2005. The course was delivered for the SQL Server customer team – to a few of their top TAP […]