Connect Digest : 2011-05-23

Next week I'll be up in Alaska for SQL Cruise, so I'll be skipping at least one digest. This week I gathered a few engine-related issues, two involving what the engine does while an index is being created. The most important one, though, at least IMHO, is the first one […]

A Change of Scenery for the PASS Summit

In 2013, the PASS Summit will move from Seattle, which it has called home in 2003, 2006, 2008, 2009, 2010, 2011 and 2012, to the warmer climes of Charlotte, North Carolina. (Read the official PASS announcement.) There are a lot of big benefits to this move: folks in the eastern […]

Shameless Plug : Vote for my PASS submissions

I received a lot of grief at SQLRally when it was revealed that I have never submitted to speak at the annual PASS Summit. Well, this year, I did submit. So if you are planning on going, and you'd like to see me speak about SQL Server "Denali" or about […]

SQL Server v.Next (Denali) : When will Denali be released?

Every few days I see the following question being asked on #sqlhelp, on forums, or in person at various SQL-related events: <div style="padding: 10px 20px; background: none repeat scroll 0% 0% rgb(238, 238, 238); font-size: 12px; font-family: georgia, times; -moz-background-inline-policy: continuous;"><b><i>Q: When will Denali be released?</i></b></div></td></tr></table> A barrage of similar […]

Connect Digest : 2011-05-16

This week we're going to take a look at issues with filtered indexes. This feature was a very welcome addition in SQL Server 2008 and has enjoyed widespread usage if conversations on twitter and forums are any indication. But their implementation is not perfect – bugs in SSMS and numerous […]

SQLRally slide deck & samples

Yesterday I spoke at SQLRally in Orlando on new engine and tools features in the next version of SQL Server – codenamed Denali. We nearly filled the room with 70+ people, and I got to hand out a slew of cool giveaways from the SQL Server team – coffee decanters, […]

Connect Digest : 2011-05-09

This week we're going to look at some issues involving tempdb… Provide a tempdb per database #176241 : Eliminating TempDb By Adding Temp Filegroup to Each Database#281202 : multiple tempdb For these two requests, I am hoping that the Contained Databases feature (which I've talked about multiple times) will get […]

Connect Digest : 2011-05-02

This week, after seeing a lot of the DMV enhancements made in SQL Server 2008 R2 SP1, I thought I would take a look at some dynamic management view/function requests. Page split personality Michael Zilberstein blogged on Monday about how Extended Events and the transaction log differ in the way […]