Share via


olivier pieri's WebLog

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

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

Date: 11/25/2011

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

Date: 09/22/2011

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

Date: 03/29/2011

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

Date: 03/28/2011

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

Date: 03/24/2011

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

Date: 03/24/2011

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

Date: 01/26/2011

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

Date: 01/14/2011

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

Date: 05/10/2007

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

Date: 11/23/2005

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

Date: 07/19/2005

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

Date: 12/16/2004

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

Date: 12/07/2004

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

Date: 12/07/2004

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

Date: 12/06/2004

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

Date: 12/06/2004

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

Date: 12/03/2004