SQL Server Sessions at TechEd

Over the past couple of days, I’ve been attending many of the SQL Server sessions which have mostly been very interesting.

I’ve attended a couple of Bob Beauchemin’s sessions which were excellent. The first one was a 1hr 15min session covering everying about the SQL Server FileStream data type. This included details on converting existing columns to FileStream and a good tip on creating a persisted computed column on a FileStream column. The example given involved saving gif images in the database. Since certain parts of the gif header contain information about the colours used in the image, a persisted computed column can be ceated to allow you to quickly search for all images matching a certain background colour.

The second talk that Bob gave was an in depth session about the SQL Server performance that included details about execution plans, viewing items in the query cache and parameter sniffing.

Another good session that I attended was Ward Pond’s SQL Tricks session. This included a useful tip on using ‘openrowset’ to execute a stored procedure, thus enabling you to join the output columns to anther view or column.

Other sessions that I attended included talks on SQL Server Report Builder 2008 which featured the use of the tablix control and gauges. I also attended a session on SQL Server Security which gave a good explaination of how to implement encryption in SQL 2008.


About dotnettim

Tim Leung is a Microsoft .Net / SQL Server developer based in England.
This entry was posted in TechEd 2008. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s