Monthly Archive: November 2010

SQL Server v.Next (Denali) : Launch point for BI resources

SQL Server v.Next (Denali) : Launch point for BI resources

Microsoft's new data platform vision for BI is called BISM – Business Intelligence Semantic Model.  While I focus primarily on manageability, availability and database engine features, I'd like to keep tabs on who can...

SQL Server v.Next (Denali) : How has sys.databases changed?

SQL Server v.Next (Denali) : How has sys.databases changed?

Earlier, I documented the system objects that have changed in Denali.  One that caught my eye was a slew of new columns made available through sys.databases, mostly to support a feature I also blogged...

[OT] : An open blog post to bit.ly

[OT] : An open blog post to bit.ly

I am not sure when it happened, but at some point, bit.ly marked all URLs to connect.microsoft.com as dangerous.  So for example, I created this shortened link http://bit.ly/fKKQPT which just goes to http://web.archive.org/web/*/https://connect.microsoft.com/sql/.  When...

SQL Server v.Next (Denali) : Some Management Studio bugs you should vote for

SQL Server v.Next (Denali) : Some Management Studio bugs you should vote for

It's been a while since I hosted a true Connect pity party digest, trying to pimp your votes for the issues I think are worthwhile.  And okay, some of these bugs haven't been filed...

SQL Server v.Next (Denali) : New, Changed and Removed System Objects

SQL Server v.Next (Denali) : New, Changed and Removed System Objects

While it's still only the CTP1 timeframe, getting a glimpse of the changes in system objects can start preparing you for what's coming – especially when there are potential breaking changes, as you'll see...

Debugging T-SQL in SQL Server v.Next (Denali) : You can make a difference!

Debugging T-SQL in SQL Server v.Next (Denali) : You can make a difference!

This afternoon, Adam Machanic (blog | twitter) reminded me how the current T-SQL debugger in Management Studio is ineffective.  Sure, there are some enhancements coming in Denali (I mentioned them briefly yesterday), but there...

What I'm Thankful For

What I'm Thankful For

It's the day before American Thanksgiving, and Jason Strate (blog | twitter) has asked all of us to tell the SQL community what we're thankful for.  While I seem to recall doing this before,...

SQL Server v.Next (Denali) : The New SSMS

SQL Server v.Next (Denali) : The New SSMS

In SQL Server Denali, Management Studio has been entirely migrated from its earlier incarnation.  Previously SSMS had slight traces here and there that it was a distant cousin to Visual Studio; in this release,...

SQL Server v.Next (Denali) : Exploring THROW

SQL Server v.Next (Denali) : Exploring THROW

Sadly, THROW is not mentioned on the Programmability Enhancements (Database Engine) topic of Denali's "What's New" section.  So, unless you were at PASS or have been reading the various blogs from the keynotes and...

Un-SQL Friday : Building a Brand

Un-SQL Friday : Building a Brand

[This is an overly verbose and self-centered entry into @MidnightDBA's Un-SQL Friday.] I've been unintentionally building my current brand since 1996.  This was the year I learned the wonders of desktop publishing (if you...

SQL Server v.Next (Denali) : Restoring a SQL Server 2000 database

SQL Server v.Next (Denali) : Restoring a SQL Server 2000 database

I guess the title should be, "You can't restore a SQL Server 2000 database on Denali."  I had the occasion just today to recover some data from a backup I took way back in...

Cumulative Updates for SQL Server 2008 are available

Cumulative Updates for SQL Server 2008 are available

On Monday, the SQL Server Release Services team released cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2.  The cumulative update for SP2 restores the fixes that were potentially undone...

SQL Server v.Next (Denali) : Contained Databases

SQL Server v.Next (Denali) : Contained Databases

A problem that has plagued SQL Server for a long time is that a database is not very portable.  Sure, you can backup or detach a database and restore or attach it elsewhere, but...

SQL Server v.Next (Denali) : Books Online

SQL Server v.Next (Denali) : Books Online

There are posts elsewhere that go through the whole rigamarole (for example, this post from Don Gill, SQL Server's Group Content Publishing Manager).  I just wanted to highlight the key bullet points: if you...

Reflections on the 2010 PASS Summit

Reflections on the 2010 PASS Summit

It hasn't been 24 hours since I left behind a slew of new and old friends in Seattle, and I already feel – as someone else put it – that I've left summer camp...

SQL Server v.Next (Denali) : The instance is down; what happened?

SQL Server v.Next (Denali) : The instance is down; what happened?

If you come across a SQL Server that is not running, it can be troublesome to determine what happened and when.  You can run through the Windows event viewer, but this can be a...

SQL Server v.Next (Denali) : Using SEQUENCE

SQL Server v.Next (Denali) : Using SEQUENCE

SQL Server 2011 introduces a feature that Oracle professionals will certainly recognize: SEQUENCE.  SEQUENCE allows you to define a central place where SQL Server will maintain a counter of values for you.  The last-used...