January 2010 Entries

SQL Azure - Execution Plans

Quick note on SQL Azure... While I was performing a demo of SQL Azure at the last SQL Saturday in Tampa, I tried to pull an execution plan to see if that worked. I was happily surprised to find out that you can actually get actual execution plans back. This is really cool considering that there is no current support for server-side traces. At least we can tell whether indexes are actually being used in the cloud. Just be ready to wait a little - execution plans are 'heavy' on packet transfers - so ......

Designing an application to work with SQL Azure

Using SQL Azure for your applications is relatively straightforward. All you need is... a connection string... and since SQL Azure uses TDS as its underlying communication protocol, just like SQL Server, it may seem natural that you don't need to change much in your application design approach when connecting a SQL Azure database. However, this may not necessarily be true. SQL Azure was designed for ease of deployment and scalability; and as such you may need to take certain things into consideration ......

SQL Saturday in Tampa - January 23rd

Just in case you are around... please come to the SQL Saturday in Tampa, FL on Saturday January 23rd. I will be there!!! And many other SQL Server speakers. Visit http://www.sqlsaturday.com/32/eventhome.aspx for more information...

Many topics will be covered including SSIS, ELT, Powershell, SQL Azure,  CTEs, Dashboards, Service Broker and many more!

 

Twitter