SQLServerCentral: Scripts tagged powershell

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch. Read more...

By Fahim Ahmad 2013/05/03 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 440 reads

PowerShell to search for domain Computer objects

Query Active Directory Computer objects to verify existence Read more...

By Fahim Ahmad 2013/05/01 | Source: SQLServerCentral.com | Category: powershell

Rating: (not yet rated) |

Discuss |

Briefcase | 473 reads

PowerShell to Pre-Create domain objects for SQL Server Cluster

Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster Read more...

By Fahim Ahmad 2013/04/30 | Source: SQLServerCentral.com | Category: powershell

Rating: (not yet rated) |

Discuss |

Briefcase | 252 reads

Restore Latest Backup with Powershell

Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed. Read more...

By Luke Losli 2013/04/16 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 658 reads

Powershell - Document your environment

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details". Read more...

By Justin Manning 2013/03/22 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,271 reads

Powershell - Query SQL Servers Operating system details

The script works through the CMS you have set up to manage your environment and gathers various server information. Read more...

By Justin Manning 2013/02/26 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,153 reads

Powershell - Export Stored Proc results to CSV file

This Powershell script calls a stored procedure and exports the results to a CSV file Read more...

By Mandeep Dulai 2013/02/05 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,047 reads

Unattended Install with PowerShell

A PowerShell script which will guide you through an interview and produce the configuration file(s) necessary for an unattended installation of SQL Server 2008/2008R2. Read more...

By Derik Hammer 2012/08/15 | Source: SQLServerCentral.com | Category: powershell

Rating: (not yet rated) |

Discuss |

Briefcase | 799 reads

Create Normalised Databases with Powershell

Database creation with powershell SMO objects Read more...

By Patrick Viennot 2012/07/06 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 849 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK. Read more...

By Gene Hunter 2012/06/13 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,234 reads

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files. Read more...

By Premjit Das 2012/05/03 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,589 reads

Check_Mirroring_Status.ps1

Check mirroring database status using PowerShell. Read more...

By Eric SIMBOZEL 2012/03/19 | Source: SQLServerCentral.com | Category: powershell

Rating: (not yet rated) |

Discuss |

Briefcase | 761 reads

PowerShell - Restart Services

A PowerShell script which restarts any service running on a server. Read more...

By Rik Thwaites 2012/02/14 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,175 reads

Powershell - Modify Server Name in SQL 2005 SSIS Connections

This powershell script updates the server name specified in connections within a SQL 2005 SSIS package Read more...

By Mandeep Dulai 2011/06/24 | Source: SQLServerCentral.com | Category: powershell

Rating: (not yet rated) |

Discuss |

Briefcase | 547 reads

Automate Range Right Partition Management with Powershell (Part II)

In the last script, we covered removing the trailing partition in a Range Right, date valued partition. This script adds a new (empty) partition to the partition scheme. Read more...

By Hugh Scott 2010/11/12 | Source: SQLServerCentral.com | Category: powershell

Rating: (not yet rated) |

Discuss |

Briefcase | 802 reads

Automate Range Right Partition Management with PowerShell

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition. Read more...

By Hugh Scott 2010/11/11 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,368 reads