Browse by Tags

• SQL Server

• Performance-Driven Development

  I was reading a blog yesterday about the evils of SELECT * . The author pointed out that it's almost always a bad idea to use SELECT * for a query, but in the case of SQL Azure (or any cloud database, for that matter) it's especially bad, since you're Read More... Posted Tuesday, May 11, 2010 7:36 AM by BuckWoody | 3 Comments Filed under: Developer, Development, Performance Tuning, SQL Azure, SQL Server

• Monitoring SQL Azure For Performance

  In SQL Server Azure, there are no Dynamic Management Views (DMVs) or Performance Monitor Objects and Counters that you can access, so you can’t run your standard performance monitoring that way. I suspect that as time goes on, SQL Azure will have some Read More... Posted Tuesday, December 22, 2009 7:33 AM by BuckWoody | 3 Comments Filed under: Developer, Development, Performance Tuning, SQL Azure, SQL Server