Monthly Archive: May 2011

Connect Digest : 2011-05-23

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...

We don't always need mobile or web equivalents of our Windows applications

We don't always need mobile or web equivalents of our Windows applications

At SQLRally, we brought along an iPad to demonstrate that monitoring doesn't have to be web-based to be mobile. We fielded a lot of questions about this, the most common one being, "Whoa, is...

A Change of Scenery for the PASS Summit

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...

A less shameless plug : PASS sessions I've voted as "preferred"

A less shameless plug : PASS sessions I've voted as "preferred"

Not that my preferences really mean a hill of beans to anyone else, but since I've asked for your vote on my sessions, I'd also like to share the list of sessions that I've...

Shameless Plug : Vote for my PASS submissions

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...

Cumulative Updates for SQL Server 2008 SP1 & SP2 are available

Cumulative Updates for SQL Server 2008 SP1 & SP2 are available

Today Microsoft has released cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. SQL Server 2008 Service Pack 1 KB #2527187 : Cumulative Update #14 for SQL Server 2008 Service...

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

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);...

Connect Digest : 2011-05-16

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...

SQLRally slide deck & samples

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...

Connect Digest : 2011-05-09

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,...

A little PowerShell syntax tip : dealing with SQL Server named instances

A little PowerShell syntax tip : dealing with SQL Server named instances

This afternoon I was working on a little PowerShell script to collect some PerfMon counters. I borrowed some code from myself, and had counters represented in strings like the following (this is a greatly...

Connect Digest : 2011-05-02

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...