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...
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...
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,...
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...
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...
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...
Date: 03/24/2011
Analysis Services and powershell
It is usefull to be able to see analysis services configuration and browsing cube structure with...
Date: 01/26/2011
Usefull DMV Query
What are DMV : (Dynamic Management View) View of internals informations. DMV are basically SQL Views...
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...
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...
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 :)
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...
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...
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...
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...
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...
Date: 12/06/2004
First Post and presentation
Hi, I am Olivier PIERI, a Microsoft consultant specialized in database technologies. The goals of...
Date: 12/03/2004