Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag powershell Rss

Search for any content tagged powershell

   Items 1 to 20 of 175    Older >>
 

Data Mining: Part 13 Powershell

In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.  Read more...
By Daniel Calbimonte 2014/08/12 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 2,989 reads

Using PowerShell to Manage Windows Azure SQL Databases

Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).  Read more...
By Additional Articles 2014/07/18 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 2,394 reads

Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)

This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS.   Read more...
By Additional Articles 2014/07/16 | Source: MSSQLTips.com | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 10,951 reads

Finding Unused SQL Server Stored Procedures With PowerShell

Tim Smith describes a number of ways to tell which Stored Procedures are in use, DMVs, a SQL Server Trace, and his preferred method, the Source Code and PowerShell.  Read more...
By Additional Articles 2014/07/07 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,899 reads

PowerShell One-Liners: Accessing, Handling and Writing Data

In the grand finale to Michael Sorens' series of PowerShell one-liners, we come to the handling of data, reading it in and writing it out, whether by files; input/output streams or a database. It shows how it can be done in a variety of formats including CSV, JSON, and XML.  Read more...
By Additional Articles 2014/06/19 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,490 reads

Anything Remotely Useful

Phi Factor on how to combine PowerShell Remoting with slick Windows tools such as SQLPSX, Boxstarter and Chocolatey, to automate the development process right through to delivery.  Read more...
By Phil Factor 2014/06/09 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

Extracting data with headers using PowerShell

This article provides a short PowerShell script to extrace data from a database using PowerShell.  Read more...
By Louis Li 2014/06/03 | Source: SQLServerCentral.com | Category: extracting data
Rating: |  Discuss |   Briefcase | 3,976 reads

PowerShell One-Liners: Collections, Hashtables, Arrays and Strings

The way to learn PowerShell is to browse and nibble, rather than to sit down to a formal five-course meal. In his continuing series on PowerShell one-liners, Michael Sorens provides Fast Food for busy professionals who want results quickly and aren't too faddy. Part 3 has as its tasty confections - Collections, Hashtables, arrays and strings.  Read more...
By Additional Articles 2014/06/02 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 4,225 reads

Extract and convert all Excel worksheets into CSV files using PowerShell

Can PowerShell provide an easy way to export Excel as a CSV? Yes. Tim Smith demonstrates that whether you have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process.   Read more...
By Additional Articles 2014/05/21 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,292 reads

Validate File Properties with PowerShell Prior to Import into SQL Server

We recently faced an issue where an internal data provider began providing an incomplete or inaccurate files because it lacked the proper length (or didn't exceed a certain size). In our case, we implemented a check on the file before importing using PowerShell, here's what we did.  Read more...
By Additional Articles 2014/05/15 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,576 reads

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.  Read more...
By Ben Miller 2014/05/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,395 reads

PowerShell One-Liners: Variables, Parameters, Properties, and Objects

Michael Sorens provides the second in a series of collections of general-purpose PowerShell one-liners to cover most of what you'll need to get useful scripting done.  Read more...
By 2014/05/09 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,153 reads

Stairway to SQL PowerShell Level 6: PowerShell Modules

In this level, we will walk through creating and using modules for PowerShell. Modules are simply a collection of functions that are most likely related to each other and packaged in a way that allow you to import them as a group.  Read more...
By Ben Miller 2014/04/30 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,410 reads

PowerShell One-Liners: Help, Syntax, Display and Files

Michael Sorens aims to make PowerShell a bit easier to get going with by providing a series of collections of general-purpose one-liners to cover most of what you'll need to get useful scripting done.  Read more...
By Additional Articles 2014/04/25 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 6,329 reads

Paging Doctor Powershell

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...
By Zach Mattson 2014/04/11 (first published: 2011/04/04) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 12,080 reads

Managing SQL Server Services with PowerShell

PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.  Read more...
By Additional Articles 2014/04/10 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,538 reads

Automate Sliding Window Partition Maintenance: Part III

Part 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell  Read more...
By Hugh Scott 2014/03/21 (first published: 2010/12/28) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 6,037 reads

The PoSh DBA – Specifying and Gathering Performance Counters

If you need to keep tabs on a number of servers and applications in a Windows domain then performance counters provide the bedrock of information. It is important to identify the counters you need and gather baseline data to allow you to create alerts when abnormal conditions occur.   Read more...
By Additional Articles 2014/03/20 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,592 reads

Automate Sliding Window Partition Maintenance: Part II

Part 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.  Read more...
By Hugh Scott 2014/03/14 (first published: 2010/12/21) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 7,897 reads

SQL Server Database Connectivity Testing Using PowerShell

There are several networking issues that can prevent the user from reaching or connecting to the SQL Server database. Learn how to test your SQL Server connectivity with PowerShell.  Read more...
By Additional Articles 2014/02/07 | Source: MSSQLTips.com | Category: connectivity
Rating: (not yet rated)  Rate this |   Briefcase | 2,733 reads
   Items 1 to 20 of 175    Older >>