Posts

• 11 Dec 2010

  Techniques learned in SQLtopia: Look Ma, no loops!

  I have been programming in c-based languages for more than 10 years now. Lately i have spent quite a bit of time in SQLt...
• 10 Dec 2010

  Exploring window functions

  Here is a sample query that allows you to explore the behavior of various aggregate window functions: WITH [Nums1] AS ( ...
• 20 Nov 2010

  Convert AAC/M4A files to MP3 with VLC and PowerShell

  Here is a way to convert your AAC/M4A files to MP3 using VLC media player: vlc.exe -I dummy old.m4a :sout=#transcode{aco...
• 17 Nov 2010

  Configure Visual Studio 2010 environment in PowerShell

  Instead of using the “Visual Studo Command Prompt (2010)” i wanted to use PowerShell instead. I found this p...
• 17 Nov 2010

  Load all script files at PowerShell startup

  These days i have quite some scripts files that i want to be loaded each time i launch PowerShell. Windows PowerShell Pr...
• 11 Nov 2010

  Get variable value from variable with PowerShell

  Sometimes you only know at runtime in which variable a certain value is stored. Let me clarify with an example: $tim = 3...
• 11 Nov 2010

  Update ConfigurationStrings in SSIS package with PowerShell

  Here are some functions that allow you to update ConfigurationStrings in a SSIS package (dtsx) using PowerShell: functio...
• 07 Nov 2010

  Build your solution with Visual Studio from MSBuild

  Unfortunately MSBuild and BIDS Helper are not able to build an .asdatabase from our Analysis Services project (.dwproj)....
• 07 Nov 2010

  Invoke PowerShell script from MSBuild

  Here is a small MSBuild target that allows you to invoke a PowerShell script, eg: powershell.exe & ‘script.ps1...
• 07 Nov 2010

  Modify a text file with PowerShell

  A while ago i wanted to update a connection string in a configuration file. My first attempt was the following: Get-Cont...
• ← Prev page
• Next page →