Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>As a developer, I can tell you I no longer have a bunch of ConsoleApplication42 projects laying around in a folder.</p> <p>As a developer at a small company where I pretty much do all things IT (DBA, manipulate routers, pull call detail records from the switch, monitor and graph bandwidth for customers, etc...) I can tell you that PowerShell fills a sorely needed gap in Windows and the fact that it's built on .NET provides a seamless upgrade path when the PowerShell pipeline is too slow to handle millions of iterations or a more permanent, strongly typed implementation is needed.</p> <p>Anyway, I guess the question is why are you switching to PowerShell if you don't have a pressing need? I mean it's good to learn it now since it's basically the new management interface for all things Microsoft. But if that doesn't affect you then don't bother if you don't think you're gaining anything.</p> <p><strong>EDIT (In response to comments below)</strong></p> <p>It sounds like you're trying to use the .NET Process class to launch an exe and redirect it's stdout so it can be read by the caller. I agree that is a pain in .NET but fortunately PowerShell does all this for you pretty simply. As for capturing the result and still writing it to the display, that's pretty simple too though the command isn't a very well-known one because it isn't used that often. Here's an example:</p> <pre><code># I always find it easier to use aliases for external commands Set-Alias csc C:\Windows\Microsoft.NET\Framework64\v3.5\csc.exe # Create some source file Set-Content test.cs @" class Program { static void Main() { System.Console.WriteLine("Hello World"); } } "@ # Call CSC.EXE # the output of csc.exe is written to results.txt and piped # to the host (or select-string if you prefer) csc test.cs | Tee-Object -file results.txt # Check for errors if ($LASTEXITCODE) { # this is where community extensions would come in # handy. powershell 2.0 also has a command to send # mail but in 1.0 you can grab one from poshcode.org } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POWhat problem did MS solve by creating PowerShell?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJosh
    1. USJosh
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI'm involved in a project and it's getting to the point where automated builds, schema updating, deployment, etc needs to be done. I had chosen PowerShell because of my perception that it would be good at the task. My decisions are going to end up being company wide w/i the next year or two and it seems like PowerShell is being pushed heavily by MS. After having experienced some pain with PS, I'm toying with using Ruby or Perl instead (I *really* don't want to use cygwin).
      singulars
      1. PO
      1. USFred
    2. COCould you use MSBuild for that? I'm not too familiar with MSBuild other than the hand tweaking of csproj files that I've done to hook in ILMerg and what not. But it seems like any scripting language is going to be just as general as the rest. If it's build automation you're after there's plenty of tools that specialize in that.
      singulars
      1. PO
      1. USJosh
    3. COOut of curiosity though, what pains have you run into. Perhaps I can help. I'm fairly active in the PowerShell newsgroup and on my blog so I try to help when I can. I found a lot of things frustrating about PowerShell at first but particularly with 2.0 CTP 3 I have pretty much decided that if it ever went away I would sit in my garage with the car running and let the engine purr me to sleep.
      singulars
      1. PO
      1. USJosh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload