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 help you out with their input on the other aspects I rarely touch – Analysis Services […]

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 about recently, contained databases.  Consider the following simple query: SELECT * FROM sys.databases; Yes, this comes […]

[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 you click on the shortened link, you get the following warning (click to embiggen):   Unfortunately, […]

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, I have gone through a lot of life changes in the past year, so I believe […]

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, it is a full-fledged immediate family member.  There are some great things that come of this, […]

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 other Denali sessions, the presence of this keyword may be news to you.  I wanted to […]

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 can call Corel Draw desktop publishing) and Internet publishing (a.k.a. HTML).  Microsoft pushed out Internet Explorer […]

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 by applying SP2 (or the SP2 CTP) after applying CU9 or CU10 to SP1.  Confusing, yes, […]