Browse By Category

November 13, 2008 01:13 PM

Accessing SQL Server Data from PowerShell, Part 1

Leverage the .NET object model

Rating:

(0)

Windows IT Pro

InstantDoc ID #100458

Because Windows PowerShell is integrated with the Microsoft .NET framework, you can leverage the .NET object model within PowerShell scripts. An important advantage is the ability to use ADO.NET to access various types of data sources, including SQL Server. Building ADO.NET objects within a script lets you retrieve data from a SQL Server database, update that data, insert new data, or delete existing data.

Bec...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

Monthly

Annual

Compare Member Benefits

Add a Comment

There are no comments to display. Be the first one!

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Articles

Basics of the .NET Framework: ADO.NET

Learning Path

Basics of the .NET Framework: ADO.NET

Related Articles

Cool New Features in ADO.NET 2.0

Learning Path

Cool New Features in ADO.NET 2.0

Related Articles

PowerShell 101, Lesson 1

Learning Path

PowerShell 101, Lesson 1

Related Resources

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Papers by Confio

A Business Case for Lowering Enterprise Total Cost of Ownership - Microsoft SQL Server for SAP on HP Integrity Servers
A White Papers by Hewlett-Packard

Check Out the Industry-Leading CA Erwin Data Modeler—Free 15-Day Trial
A Downloads by CA/ERwin

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guides by EMC

IP and MAC addresses

I am looking for a way to read the IP and MAC addresses of my servers through T-SQL. Can someone point me in the right direction? Thank you...

More Posts

Default database
MonthEnd
Backups

Essential Guides

Choose the Right Storage Architecture for your SQL Server Environment | Overwhelmed by the many different storage platforms available in today’s SQL Server market? Wendy Henry discusses how choosing the right storage for your environment does not have to be a confusing process.

Web Seminars

Database Schemas: Getting it Right the First Time | Database modeling and design are at the core of a healthy database management and performance foundation. Getting it right the first time will enhance the bottom line in a variety of ways.View this on demand web seminar

eBooks

Playbook for a Virtualized Datacenter | Organizations are looking to extend virtualization to encompass the entire datacenter. This playbook provides you with a step-by-step overview of the benefits, challenges, technology options and best practices for datacenter virtualization.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.