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 […]
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 […]
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, […]
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 in the Denali time frame – but those are still in Denali's version of SSMS. And […]
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 below. Sure, a few of these things can change (and hopefully be fixed!) as the product […]
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 are some real key elements missing. One of the most glaring omissions is the ability to […]
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 […]
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, […]
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 […]
[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 […]
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 2008 (!) for a colleague who was still on 2000 at that time (again, !). When […]
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, […]