olivier pieri's WebLog

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

  • olivier pieri's WebLog

    SQL Server 2012 : introduction to tabular model

    • 0 Comments
    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
  • olivier pieri's WebLog

    Retreive Analysis Services warning with powershell

    • 0 Comments
    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...
  • olivier pieri's WebLog

    Update SQL Server Statistics with Powershell

    • 0 Comments
    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...
  • olivier pieri's WebLog

    Rebuild SQL Server index with Powershell

    • 0 Comments
    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...
  • olivier pieri's WebLog

    SQL Server backup and powershell

    • 0 Comments
    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...
  • olivier pieri's WebLog

    SQL Server and powershell

    • 0 Comments
    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...
  • olivier pieri's WebLog

    Analysis Services and powershell

    • 0 Comments
    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...
  • olivier pieri's WebLog

    Usefull DMV Query

    • 0 Comments
    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...
  • olivier pieri's WebLog

    Run SSIS Package programatically

    • 0 Comments
    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...
  • olivier pieri's WebLog

    XMLA from the Command line

    • 1 Comments
    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...
  • olivier pieri's WebLog

    How to get SQL Server 2005 today

    • 0 Comments
    Just go here : GO You can get SQL Server 2005 CTP June and Visual Studio 2005 beta 2. Enjoy :)
  • olivier pieri's WebLog

    Create a stored procedure with SMO

    • 2 Comments
    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....
  • olivier pieri's WebLog

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

    • 0 Comments
    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...
  • olivier pieri's WebLog

    Create table with SMO

    • 0 Comments
    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...
  • olivier pieri's WebLog

    SMO connection

    • 0 Comments
    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...
  • olivier pieri's WebLog

    How to retreive KPI from Analysis Services 2005

    • 6 Comments
    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...
  • olivier pieri's WebLog

    First Post and presentation

    • 0 Comments
    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...
Page 1 of 1 (17 items)