Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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