InfoQ

InfoQ

InfoQ

En | 中文 | 日本語 | Br

562,907 Jan unique visitors

News

My Bookmarks

Login or Register to enable bookmarks for unlimited time.

The content has been bookmarked!

There was an error bookmarking this content! Please retry.

PowerShell Scripting Added to SQL Server 2008

Posted by Jonathan Allen on Nov 20, 2007

Sections
Development
Topics
Scripting ,
.NET
Tags
SQL Server 2008 ,
PowerShell

After years of listening to complaints about Windows not being scriptable, Microsoft has finally taken action. PowerShell is being pushed into server products such as the next Windows Server and Exchange Server.

PowerShell is Microsoft's replacement for VBScript and batch-file based scripting. It is a fully object-orientated, meaning streams of objects flow from command to command instead of traditional text streams.

Francois Ajenstat has recently announced that SQL Server is the next to pick up PowerShell scripting in the next CTP. While CTP features are not guaranteed to be in the final product, they usually are.

RelatedVendorContent

A Guide to Branching and Merging Patterns

Using Drools? See what you're missing! Get the Power of Drools with the Assurance of Red Hat

Five Key Practices to Agile ALM

Spring Data Neo4j Tutorial

Kanban for Agile Teams

1 comment

Watch Thread Reply

SQL Server w/ PowerShell by Geoffrey Wiseman Posted

  1. Back to top

    SQL Server w/ PowerShell

    by Geoffrey Wiseman

    Would be curious to see what that means in more detail. A quick poke around the SQL Server 2008 site wasn't enlightening.

    Reply

Educational Content

New-age Transactional Systems - Not Your Grandpa's OLTP

John Hugg discusses high volume transaction processing applications with high and low frequency profiles, and how VoltDB can be used for that purpose.

Cool Code

Kevlin Henney examines code samples to see what can be learned from them starting from the premise that one won’t write great code unless he knows how to read it.

Collaboration: At the Extremities of Extreme

Jason Ayers share the observations he made watching a team of developers collaborating in real time on the same code base, pushing XP, pair programming and continuous integration to their extremes.

Yesod Web Framework

Michael Snoyman presents Yesod, a web framework written in Haskell and containing a web server, templating, ORM, libraries (templating, gravatar, etc.).

Transactions without Transactions

Richard Kreuter and Kyle Banker on how to avoid classical RDBMS transactional systems by using compensation mechanisms, transactional messaging or transactional procedures.

Attila Szegedi on JVM and GC Performance Tuning at Twitter

Attila Szegedi talks about performance tuning Java and Scala programs at Twitter: how to approach GC problems, the importance of asynchronous I/O, when to use MySQL/Cassandra/Redis, and much more.

10 tips on how to prevent business value risk

One category of risk that project teams need to ensure they address is business value failure – delivering a product that fails to provide value for the business investor.

Interview: Software Systems Architecture: Working With Stakeholders Using Viewpoints and Perspectives

InfoQ spoke to the authors of Software Systems Architecture on a couple of new topics, the System Context viewpoint and Agile, which have been added to the second edition.