When Power View appeared, one of the big outcries was “but what about connecting to existing cubes!”.
Great to see that the SQL Server team have addressed that. A tool that allows connecting Power View to SSAS Multidimensional cubes is now available.
(NOTE: CTP no longer available)
Help the team get this out the door by trying it and providing feedback.
2012-11-30
Good to see the Visual Studio 2012 team get update 1 out the door. I’m using it now and am pretty happy with it.
I like the way that the tools are now being updated out of band. Hopefully, the SQL BI folk will get their templates updated to VS2012 soon too.
You can get it here: http://www.microsoft.com/visualstudio/eng/downloads#d-visual-studio-2012-update
2012-11-28
We as an industry have a lot to answer for. One thing is the level of support provided for users. Here’s the conversation I’m having with Skype right now. It feels like being in a Monty Python skit. I was really hoping that when Microsoft purchased Skype that things might improve.
8:33:44 PM greglow
Initial Question/Comment: Subscriptions (Unlimited Country, Unlimited Europe, Unlimited Region, Unlimited World)
8:33:44 PM System
Thank you for contacting Skype Customer Support!
2012-11-21
ScottGu announced the Azure Conference today at BUILD. Have to say that I’m looking forward to it. If you want a bunch of Azure content, online and free, you can register for more info.
2012-11-01
The default action when performing a backup is to append to the backup file yet the default action when restoring a backup is to restore just the first file.
I constantly come across customer situations where they are puzzled that they seem to have lost data after they have completed a restore. Invariably, it’s just that they haven’t restored all the backups contained within a single OS file. This happens most commonly with log backups but also happens when they have not restored the most recent database backup file.
2012-10-31
Ola has produced another update of his database management scripts. If you haven’t taken a look at them, you should. At the very least, they’ll give you good ideas about what to implement and how others have done so. The latest update allows targeting multiple devices during backup. This is available in native SQL Server backup and can be helpful with very large databases. Ola’s scripts now support it as well.
2012-09-17
One thing you get to do as you get older, or have been around the industry for a long time, is to pontificate. My pet topic today is passwords. I think that they are, as a concept, now completely broken and have been for a long time.
We tell users:
1. Pick something really complex
2. Don’t write it down
3. Change it regularly
4. Use a different password for each site, and often each role that you hold in each site
2012-08-22
Late last night I got to record an interview with Conor Cunningham.
Most people that know Conor have come across him as the product team wizard that knows so much about query processing and optimization in SQL Server. Conor is currently spending quite a lot of time working on Windows Azure SQL Database, which we used to know as SQL Azure.
I’m still trying to think of a good way to say “WASD”. I suppose I’ll pronounce it like “wassid”. Windows Azure SQL Reporting is easier. I think it just needs to be pronounced like “wazza” with a very Australian accent.
2012-08-22
Hi Folks,
I’ve recorded an interview today with SQL Server MVP Louis Davidson. In it, Louis discusses some of his thoughts on database design and his latest book.
You’ll find the podcast here: http://www.sqldownunder.com/Resources/Podcast.aspx
And you’ll find his latest book (Pro SQL Server 2012 Relational Database Design and Implementation) here: http://www.amazon.com/Server-Relational-Database-Implementation-Professional/dp/1430236957/ref=sr _1_2?ie=UTF8&qid=1344997477&sr=8-2&keywords=louis+davidson
Enjoy!
2012-08-15
The query performance tuning class has been a popular class but we’ve only been running it in local cities. We’re now running it in a fully-interactive instructor-led online class, complete with hosted hands-on labs. Later this year it will also be available amongst our upcoming on-demand training offerings.
If you’re keen to spend some time in a query performance tuning class, let us know.
For the online offering, we’ve spread it over 4 x 1/2 days to make it easier to attend. We’ve got the same hands-on-labs and course content as the in-person class. The labs are hosted so you don’t need to provide equipment but we have a lower cost attendance option if you don’t need the hosted labs.
2012-08-13
