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.