Part 2 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.

Migrating Microsoft Access Databases to SQL Server 2008

by Additional Articles

Database Journal

Access

Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.

How to create a CLR assembly on a remote server with limited permissions

by Pavel Sinkevich

SQLServerCentral.com

SQLCLR

How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available

Patches for SQL 10 and Techniques for SQL 11

by Steve Jones

SQLServerCentral.com

Editorial

Steve rounds up the patch news for SQL Server this week along with a look forward to the next version of the platform.

SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process

by Site Owners

SQLServerCentral.com

The answers to questions from our webinar on Sandbox development.

TSQL Challenge 61 - Generate an HTML calendar in TSQL

by Jacob Sebastian

SQLServerCentral.com

T-SQL Challenges

This challenge is to generate an HTML calendar based on the data stored in a table.

Migrating SQL Server Databases – The DBA’s Checklist (Part 2)

by Additional Articles

SQL Server Performance

Migration

Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated