Its been a busy few weeks for me and I haven’t had as much time to catch up
on my reading as I’d have liked. This is the list of things that I have been /
trying to read.
Software Development at Microsoft Observed
Microsoft Research paper on developers� typical tools and work habits and
their level of satisfaction with them. "The most notable take-away from the
data is that developers go to great lengths to create and maintain rich
mental models of code and don�t rely on external representations."
- Wild[card] thing, You make my CHAR sing
Michael Kaplan shows some unexpected behaviour of wildcards with the LIKE
predicate. If you work with multilingual data I’d highly recommend reading
- Physical Database Storage Design
Microsoft TechNet article on physical storage design for database admins on
configuring SQL Server 2005 for optimal I/O performance and space
- What do I need to know about SQL Server database engine I/O?
Bob Dorr of the SQL Escalation Services team has written two whitepapers on
the I/O system requirements of SQL Server 2000. There’s also an extensive
list of links to further articles about SQL Server I/O.
- SQL Server Compact Edition under ASP.net and IIS
By default you cannot use SQL Server Compact Edition with ASP.Net / IIS.
This page explains the reason for this and the override setting to allow
using SQLce with ASP.Net.
SQL Server Hosting Toolkit
If you publish you databases to a ISP / externally hosted SQL Server, this
new tool may be very handy.
Its always good to keep up-to-date and revise best practices recommendations
from vendors. Here’s my current review list:
- Best Practices for Replication Administration
Security Best Practices
SQL Server Storage Top 10 Best Practices
- Top SQL Server 2005 Performance Issues for OLTP Applications
- Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Reporting Applications
- Database Mirroring Best Practices and Performance Considerations
- Troubleshooting Performance Problems in SQL Server 2005
- SQL Server 2005 Waits
- TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild
As I previously mentioned the [story:sqlserver2005-sqliosim-released] earlier
this year. It was a rewrite of SQLIOStress
as Bob Dorr explains it.