olivier pieri's WebLog

SQL, SQL Server, ADO.NET and other data topics

SQL Server 2012 : introduction to tabular model

Here, you can find a good article for you in order to introduce a sql server analysis services 2012...

Author: olivier pieri Date: 11/25/2011

Retreive Analysis Services warning with powershell

One great feature of Analysis Services is to give warning about your cube design during the design...

Author: olivier pieri Date: 09/22/2011

Update SQL Server Statistics with Powershell

It can be usefull to have a script to update statistics with powershell. this script is very simple,...

Author: olivier pieri Date: 03/29/2011

Rebuild SQL Server index with Powershell

let continue to explore what we can achieve with powershell for SQL Server management. The goal of...

Author: olivier pieri Date: 03/28/2011

SQL Server backup and powershell

In my previous post, I give some basic sample on how to use powershell for SQL Server. Here we are...

Author: olivier pieri Date: 03/24/2011

SQL Server and powershell

Here is some sample of what you can achieve to manager SQL Server with powershell, let start with...

Author: olivier pieri Date: 03/24/2011

Analysis Services and powershell

It is usefull to be able to see analysis services configuration and browsing cube structure with...

Author: olivier pieri Date: 01/26/2011

Usefull DMV Query

What are DMV : (Dynamic Management View) View of internals informations. DMV are basically SQL Views...

Author: olivier pieri Date: 01/14/2011

Run SSIS Package programatically

here is a small sample that show how to run an existing package from a .Net program. This sample...

Author: olivier pieri Date: 05/10/2007

XMLA from the Command line

I was very suprise to don't find a tool to execute XMLA Script from the command line. Then I have...

Author: olivier pieri Date: 11/23/2005

How to get SQL Server 2005 today

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

Author: olivier pieri Date: 07/19/2005

Create a stored procedure with SMO

Once you are connected to SQL Server 2005 with a SMO connection, you can start manage and create...

Author: olivier pieri Date: 12/16/2004

Make an ADO.Net connection when you have an SMO connection

When you have an SMO connection, it is very easy to make an ADO.Net connection as the connection...

Author: olivier pieri Date: 12/07/2004

Create table with SMO

Once you are connected to SQL Server 2005 with a SMO connection, you can start manage and create...

Author: olivier pieri Date: 12/07/2004

SMO connection

This sample is written in C# and use SQL Server 2005 beta 2 and a beta version of the .Net Framework...

Author: olivier pieri Date: 12/06/2004

How to retreive KPI from Analysis Services 2005

This sample is written in C# and use SQL Server 2005 beta 2 and a beta version of the .Net Framework...

Author: olivier pieri Date: 12/06/2004

First Post and presentation

Hi, I am Olivier PIERI, a Microsoft consultant specialized in database technologies. The goals of...

Author: olivier pieri Date: 12/03/2004