Webcast: SQLServerPedia.com — The Definitive SQL Server Knowledge Base
Gain access to SQL Server experts and learn more about SQLServerPedia.com by attending this webcast. SQLServerPedia.com is the free reference resource created for SQL Server professionals, by SQL Server professionals. See how you can access video training, as well as sample scripts for backup and recovery, index maintenance and performance tuning. Plus, boost your SQL […]
January SoCal Code Camp Sessions Being Posted
The SoCal Code Camp website has started accepting sessions for the next Code Camp in January. I’ve put a couple of sessions up there already. I’ve got one on SQL Server Indexing for the Client Developer, and one on SQL Server Service Broker Advanced Performance Tips and Tricks. I’m open to suggestions as to what […]
Back To Basics: Creating Indexes
After you have created your tables, and stored procedures you will have a basic idea of what queries are going to be running against your database. If you haven’t already done so, its now time to start adding indexes to your database. The catch with index is that there is such a thing as to […]
How to configure storage in SQL Server DB with more writes than reads
All to often articles and presentations about storage work under the assumption that you have a typical OLTP database with mostly reads. However there are plenty of databases out there which are mostly writes and very few reads. Setting these systems up takes a different technique for best performance. In my just released article on […]