THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Aaron Bertrand

Aaron is a Product Evangelist for SentryOne, makers of Plan Explorer and a performance monitoring and event management platform for the Microsoft Data Platform and VMware. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features, and also blogs at blogs.sentryone.com and SQLPerformance.com; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at major conferences, user group meetings, and SQL Saturday events worldwide.

Connect Digest : 2010-01-11

Control over procedure cache

We are still waiting for more control over procedure cache.  Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007.  It is currently closed as "won't fix" but it's been shown time and time again that in some cases we need this extra knob.

#293188 : Amount of RAM for procedure cache should be configurable


More flexibility for filtered indexes

This Connect item asks for the ability to create a filtered index on a persisted computed column, particularly when the column is deterministic.  I'm after even more simple things, like the ability to reference other columns (e.g. WHERE col1 > col2); not possible today.  Filtered indexes could be an extremely powerful solution to a lot of problems, but right now the limitations are a hindrance.

#518328 : Should be possible to create a filtered index on a deterministic persisted computed column


Books Online => PDF

A while back we half-joked about publishing a version of Books Online for mobile devices such as the iPhone or Blackberry (there is a Connect item for this).  But something that would get us much closer to that reality without a whole lot of custom application engineering would be to publish Books Online in PDF format, since just about all smart devices these days can handle the PDF format in one way or another.

#524049 : SQL Server Books Online As PDF Files


Better history for central Policy Management

Here Jorge Segarra (@SQLChicken) points out that, while history is maintained for policy evaluations made directly against a local server, there are no logs or other history records for policies evaluated using a central management server.  

#523369 : Central Management Server PBM History


UI usability testing : why aren't we doing it?

In general, all SQL Server UIs need to be tested with large fonts, at all supported resolutions (e.g. 800x600), and Windows-supplied color schemes such as High Contrast Black.  There should be a VM along the test path of all UI changes that represents the worst case scenario (high contrast black, 800x600, large fonts).  Here are four Connect items that highlight this need (I'm sure I could find plenty more if I tried):

#297955 : SSMS : All dialogs should work in all resolutions

#402978 : Setup : patch dialogs resize in wrong areas for "large fonts"

#524301 : SQL Studio 2008 - query status bar unusuable on high contrast black

#281293 : PBM : use better coloring in GUI for highlight / links

 


Published Monday, January 11, 2010 6:01 PM by AaronBertrand

Comments

 

mjswart said:

Books online as PDF for kindle would be useful.

But does the current lightweight versions of books online serve well enough for iphones and blackberries? See:

http://msdn.microsoft.com/en-us/library/ms130214(SQL.105,loband).aspx

I'm not a mobile device user, so it's not a rhetorical question.

January 11, 2010 8:49 PM
 

cinahcaM madA said:

Why not just use your mobile browser, browse over to Google, and search the online BOL that way?

January 11, 2010 9:25 PM
 

AaronBertrand said:

Michael, I haven't looked at the low-band BOL yet.  Does it scale to fit nicely on smaller screens?

Adam, for the same reasons I prefer a local copy of normal Books Online when I have a choice.

1) it's faster.

2) it doesn't require a connection.  I'm not sure how much you use the MBTA, but when I'm on the commuter rail (an hour+ of my commute in each direction), there are plenty of dead spots, and many of the "live" spots are so slow they may as well be dead.

There are also other times where I'd like to avoid having to be online, such as when I am in Canada (high roaming fees for Rogers' data network), or where I can't be online at all, such as when I am on a plane.

January 11, 2010 10:18 PM
New Comments to this post are disabled

About AaronBertrand

...about me...

This Blog

Syndication

Archives

Privacy Statement