Archive for Codename DENALI

Microsoft Techdays’12 Webcasts

Recently i blogged here on the Microsoft Techdays’12 event that took place in Paris a few weeks ago.

If you missed it or could not attend all your sessions of interest, you can now watch them all on the event’s website.

That’s great material for us to learn a little bit more on the MS products and to gather real life feedbacks on them.

Finally, just a little bit of ad for the session I made back then 🙂 : it’s on MDS and  you can watch the video right here.

Advertisements

Leave a Comment

[Master Data Services] “The http service located at xxx is too busy”

During the installation process of SQL Server 2012 RC0 / Master Data Services, you are asked to provide an administrator user account.

When connecting for the first time to the MDS web service via the new MDS Excel Add in for example, you may experience the following error : “The http service located at http://xxx is too busy”

The user account you entered earlier is used, among other things, to configure the default application pool that belongs to MDS. In particular, you may have noticed that you weren’t asked for the password. That’s exactly what’s missing.

Follow the following steps (from left to right) :

  1. Right click on you Computer icon on your desktop, choose “Manage”.
  2. Under “Services and Applications”, click on “Internet Information Services (IIS) Manager”.
  3. In the appearing pane, select “Application Pools”. Here you’ll find the “MDS Application Pool” application. Right click on it, and select “Advanced Settings”.
  4. Under “Process Model”, find the “Identity” property, click in the field and click on the “…” button. Choose “Set”. There you can enter the password.

Having spent 20 minutes to find out what was wrong, I thought it might help someone else to share my findings.

 

Leave a Comment

Pass Summit 2011 Announcements : SQLServer Denali Official names

Finally back from Seattle where I was attending the Pass Summit 2011 conference last week.

As always, we have seen some announcements relating to SQL Server made by Microsoft during the key notes, among which a few official namings was revealed :

  • SQL Server codename Denali has now officially become SQL Server 2012 and will be released in the first half of next year.
  • SQL Server codename Crescent will be named Power Viewer
  • SQL Server codename Project Juneau will become SQL Server Data Tools

 

Leave a Comment

[Denali CTP3] No extensibility support, still we can have fun

Today, Mark Pryce-Maher left a comment on my post reporting the lack of support for SSMS extensibility in Denali.

Mark just started a series of posts on how to build extensions for Management Studio in Denali by leveraging the isolated shell it is built on.

Basically, you can build Visual Studio extensions and then targeting the isolated shell of Management Studio, making it a little bit easier to write add ins now than it was in the past.

You can read Mark first post on the topic here.

Update 1 : Mark has published the part 2 of his article here.

 

Leave a Comment

[Denali CTP3] Product guide just released

Just in case you haven’t noticed yet, Microsoft has released the product guide for SQL Server Denali at this address :

http://www.microsoft.com/download/en/details.aspx?id=27069

This product guide provide us with product data sheets, Powerpoint presentations, technical white paper, hands on labs, self running demos, links and videos from the 2011 edition of the north america TechEd.

The content itself is divided into four modules :

  • Denali overview,
  • Mission critical confidence,
  • Breakthrough insights (aka. business intelligence)
  • and cloud on your terms

The whole thing take almost half a gigabytes and seems to be very handful.

Leave a Comment

[SQLServer 2012] Analysis Services New Feature : Scalable String Storage

As you may know, both dimension’s attributes and distinct count measures can be of string data type. During processing, Analysis Services reads data and put them into individual stores organized by attributes in case of dimensions or by measures groups/partitions for cubes.

The file format of those stores differ to adapt to the type of the data located inside. By default, until now, string stores couldn’t exceed the 4GB file size limit.

Starting with the CTP3, a new feature names “Scalable String Storage” allow to go beyond this limit. A new property named “StringStoresCompatibilityLevel” is available at different places to activate it.

I’ll review in this post how to set up this new feature in your SSAS solution and what we can expect from it…

Read the rest of this entry »

Comments (5)

[Denali CTP3] Management Studio : No support for extensibility

So it’s official now, there won’t be support for SSMS extensibility in the next version of SQL server.

It does not mean it will not be technically possible, it is “just” not supported by MS, including no forward/backward compatibility support, no documentation, etc…

Having developed myself several tools to enhance my SSAS experience, I must say that this was on top of my most anticipated feature for years now.

You can find the official info in the BOL here : http://msdn.microsoft.com/en-us/library/ms174219(v=SQL.110).aspx

You can also review the feature suggestion on connect here : https://connect.microsoft.com/SQLServer/feedback/details/265567/ssms-allow-support-for-addins-as-in-visual-studio.

This one was opened back in 2007, I’ve voted for it last year and it was finally classified “Will not be solved” today…

Considering the great expectations a lot of us had for this one, I just didn’t anticipated it would end this way…

Comments (1)

Older Posts »