Monthly Archive: February 2011

SQL Server v.Next ("Denali") : How a columnstore index is not like a normal index

SQL Server v.Next ("Denali") : How a columnstore index is not like a normal index

At the end of my Denali presentation at SQL Saturday #65 in Vancouver, a member of the audience asked, "What makes a columnstore index different from a regular nonclustered index?" At the end of...

Slides and samples from SQL Saturday #65 – Vancouver

Slides and samples from SQL Saturday #65 – Vancouver

Today I presented my "What's New in SQL Server 'Denali'" deck to about 40 attendees at SQL Saturday #65 in Vancouver, British Columbia. Attached below (and here) are the slightly updated slides and samples....

New Cumulative Updates for SQL Server 2005 & SQL Server 2008 R2

New Cumulative Updates for SQL Server 2005 & SQL Server 2008 R2

Early this morning (or late last night, depending on your time zone), the SQL Server Release Services team pushed out three new cumulative updates for SQL Server. KB #2489375 – SQL Server 2005 SP3...

My first few minutes with SQL Azure

My first few minutes with SQL Azure

I've finally decided to play a little with SQL Azure. I have to say, my first few minutes have been less than fantastic. When I go to http://sql.azure.com/ this is what I see:  ...

The results are in: I'm an okay speaker.

The results are in: I'm an okay speaker.

Last weekend I spoke at SQL Saturday #60 in Cleveland, Ohio. I had a great time catching up with some existing friends and colleagues, and met a bunch of new people too. I presented...

Is SQL Server 2008 R2 a full release of SQL Server?

Is SQL Server 2008 R2 a full release of SQL Server?

This has come up in conversations more than once in the past little while – recently on twitter I made the casual comment that later this year, SQL Server 2008 will be "two versions...

T-SQL Tuesday #15 : Running T-SQL workloads remotely on multiple servers

T-SQL Tuesday #15 : Running T-SQL workloads remotely on multiple servers

This month's installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: "So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or...

Get your Master Immersion learning on!

Get your Master Immersion learning on!

Time is running out to register for the Master Immersion training events being held in Dallas, TX by SQLskills.  These particular events will be instructed by Paul Randal (blog | twitter), Kimberly Tripp (blog...

Differences in documentation for sys.dm_exec_requests

Differences in documentation for sys.dm_exec_requests

I've already complained about this on Connect (see #641790), but I just wanted to point out that if you're trying to make sense of the sys.dm_exec_requests document and what it lists as the commands...

SQL Server 2008 R2 still requires a trace flag for Lock Pages in Memory

SQL Server 2008 R2 still requires a trace flag for Lock Pages in Memory

Almost two years ago, I blogged that Lock Pages in Memory was finally available to Standard Edition customers (Enterprise Edition customers had long been deemed smart enough to not abuse this feature).  In addition...

Reflections on SQL Saturday #60 – Cleveland

Reflections on SQL Saturday #60 – Cleveland

Every time I attend a SQL Saturday, I leave with a rejuvenated and even further reinforced sense of community.  Cleveland (SQL Saturday #60) was by far no exception.  Allen White (blog | twitter), Erin...

Some new free tools enter the SQL marketplace

Some new free tools enter the SQL marketplace

A while back, I started collecting links for free SQL Server resources available to everyone in the community. I created a blog post called "Useful, free resources for SQL Server" to serve as a...

Slide decks and samples from SQL Saturday #60 – Cleveland

Slide decks and samples from SQL Saturday #60 – Cleveland

Attached are the slide decks and demos from my two presentations at SQL Saturday #60 in Cleveland: What's New in SQL Server "Denali" T-SQL : Bad Habits to Kick

Who created that user?

Who created that user?

Twitter has provided some great fodder for blog content lately. And twice this week, I've found an excuse to take advantage of the default trace. Tonight @meltondba asked: I'm trying to find who created...

A bacon- (and module-) saving PowerShell incident

A bacon- (and module-) saving PowerShell incident

Earlier today I made a big goof.  I opened a module in Notepad, intending to use it as the basis for a new module.  I was in the process of using "File > Save...