Here, you can find a good article for you in order to introduce a sql server analysis services 2012 new functionality : tabular model : http://msdn.microsoft.com/en-us/library/hh231691(SQL.110).aspx enjoy

One great feature of Analysis Services is to give warning about your cube design during the design of your cube. These warning can be retreive after you have deployed your cube on the Analysis Services Server. here is a sample script to retreive...

It can be usefull to have a script to update statistics with powershell. this script is very simple, you just have to connect to you database and call the updatestatistics () method for all your tables : [System.Reflection.Assembly]::LoadWithPartialName...

let continue to explore what we can achieve with powershell for SQL Server management. The goal of this post is to rebuild fragmented index with power shell. To achieve that we need to use the invoke-sqlcmd cmdlet. try to use this command, if...

In my previous post, I give some basic sample on how to use powershell for SQL Server. Here we are going to build a sample script to backup database. 1) Perfom a full backup for a specified database : [System.Reflection.Assembly]::LoadWithPartialName...

Here is some sample of what you can achieve to manager SQL Server with powershell, let start with system script : 1) is the SQL Service running ? Get-WmiObject win32_service | Where-Object {$_.name -match "^*SQL*"} | select SystemName, Name, StartName...

It is usefull to be able to see analysis services configuration and browsing cube structure with powershell. to achieve that, you first need to load the AMO assembly in Powershell : [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices...

What are DMV : (Dynamic Management View) View of internals informations. DMV are basically SQL Views on some pretty important internal memory structures. DMV informations include metrics about : indexes query execution operating...

here is a small sample that show how to run an existing package from a .Net program. This sample show how to replace target and source connection string and give a value to a package variable. It show too how to register package event. using...

I was very suprise to don't find a tool to execute XMLA Script from the command line. Then I have decided to write it and it have been simple. Let do it ! 1) Use the useful namespace using Microsoft.AnalysisServices.AdomdClient; using System...

Just go here : GO You can get SQL Server 2005 CTP June and Visual Studio 2005 beta 2. Enjoy :)

Once you are connected to SQL Server 2005 with a SMO connection, you can start manage and create object. Here is an example on how you can create a stored procedure, we imagine that we have the code of a stored procedure in an embeded resources file....

When you have an SMO connection, it is very easy to make an ADO.Net connection as the connection string is exactly the same. Then you just have to reuse it. Here is a sample that supposed that the object ServerConn is an SMO ServerConnection. SqlConnection...

Once you are connected to SQL Server 2005 with a SMO connection, you can start manage and create object. Here is an example on how you can create a table with a promary key (this sample is written in C# and use a beta version of SQL Server 2005 and of...

This sample is written in C# and use SQL Server 2005 beta 2 and a beta version of the .Net Framework 2.0. It show how, with SMO you can Connect to SQL Server 2005 In order to connect to SQL Server using SMO you have to reference the following namespace...

This sample is written in C# and use SQL Server 2005 beta 2 and a beta version of the .Net Framework 2.0. It show how, with ADOMD.Net, you can retreive KPI that are defined in Analysis Services 2005. 1) reference the namespace for ADOMD: using Microsoft...

Hi, I am Olivier PIERI, a Microsoft consultant specialized in database technologies. The goals of this blog is discuss about database and Data access technologies offered by Microsoft.Net Framwork such as ADO.Net, ADOMD.Net and SMO. I will put some sample...