May 2010 - Posts

• Adding included columns to indexes using SMO

  A question came up on the SQL Down Under mailing list today about how to add an included column to an index using SMO. A quick search of the documentation didn't seem to reveal any clues but a little investigation turned up what's needed: the IndexedColumn Read More... Posted Friday, May 28, 2010 5:50 PM by Greg Low | 0 Comments

• SQL Server Maintenance Utilities Update for SQL Server 2008 R2

  Great to see that our friend Ola Hallengren has updated his maintenance utility scripts to deal with SQL Server 2008 R2. These scripts are highly regarded, particularly given the price: free ! You'll find them here: http://ola.hallengren.com/Versions.html Read More... Posted Monday, May 17, 2010 2:52 AM by Greg Low | 1 Comments

• SQL Server 2008 R2: StreamInsight changes at RTM: Event Flow Debugger and Management Interface Security

  In CTP3, I found setting up the StreamInsight Event Flow Debugger fairly easy. For RTM, a number of security changes were made. First config: To be able to connect to the management interface, your user must be added to the Performance Log Users group. Read More... Posted Saturday, May 08, 2010 8:45 PM by Greg Low | 0 Comments

• SQL Server 2008 R2: StreamInsight changes at RTM: AdvanceTimeSettings

  For those that have worked with the earlier versions of the simulator that Bill Chesnut and I constructed for the Metro content (the Highway Simulator), changes are also required to how AdvanceTimeSettings are specified. The AdapterAdvanceTimeSettings Read More... Posted Saturday, May 08, 2010 6:51 PM by Greg Low | 0 Comments

• SQL Server 2008 R2: StreamInsight - User-defined aggregates

  I'd briefly played around with user-defined aggregates in StreamInsight with CTP3 but when I started working with the new Count Windows, I found I had to have one working. I learned a few things along the way that I hope will help someone. The first thing Read More... Posted Saturday, May 08, 2010 5:02 PM by Greg Low | 1 Comments

• SQL Server 2008 R2: StreamInsight changes at RTM: Count Windows

  Another interesting change in the RTM version of StreamInsight is the addition of a new window type. Count Windows aren't time based but are based on counting a number of events. The window type provided in this release is called CountByStartTimeWindow. Read More... Posted Saturday, May 08, 2010 4:49 PM by Greg Low | 0 Comments

• SQL Server 2008 R2: StreamInsight changes at RTM: Access to grouping keys via explicit typing

  One of the problems that existed in the CTP3 edition of StreamInsight was an error that occurred if you tried to access the grouping key from within your projection expression. That was a real issue as you always need access to the key. It's a bit like Read More... Posted Saturday, May 08, 2010 3:20 PM by Greg Low | 0 Comments

• SQL Server 2008 R2: StreamInsight changes at RTM: HoppingWindow, TumblingWindow, SnapshotWindow

  We've been working on updating our demos and samples for the RTM changes of StreamInsight. I'll detail these as I come across them. The first is that there is a change to the HoppingWindow. The first two parameters are the same in the constructor but Read More... Posted Friday, May 07, 2010 2:54 PM by Greg Low | 1 Comments