SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag PowerShell Rss

Search for any content tagged powershell

   Items 1 to 20 of 300    Older >>
 

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2018/11/14 (first published: 2015/12/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,522 reads

Testing PowerShell Modules with Pester

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.  Read more...
By Additional Articles 2018/11/12 | Source: SimpleTalk | Category: pester
Rating: (not yet rated)  Rate this |   Briefcase | 1,532 reads

Azure and Windows PowerShell: Using VM Extensions

In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.  Read more...
By Additional Articles 2018/11/05 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,750 reads

Exhuming the GDPR Bodies

Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that data in file shares  Read more...
By Additional Articles 2018/10/01 | Source: SimpleTalk | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,242 reads

PowerShell Tool Time: Building Help

Learn how you can customize the help for your library of scripts in this edition of PowerShell Tool Time.  Read more...
By Mike Fal 2018/09/28 (first published: 2016/01/06) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 3,691 reads

Advanced Testing of Your PowerShell Code with Pester

Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.  Read more...
By Additional Articles 2018/09/20 | Source: SimpleTalk | Category: test
Rating: (not yet rated)  Rate this |   Briefcase | 2,125 reads

Introduction to Testing Your PowerShell Code with Pester

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.  Read more...
By Additional Articles 2018/09/06 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,507 reads

Introduction to PowerShell with SQL Server Using Invoke-SQLCMD

PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer SQL Server or even just export data. In this article, Greg Moore demonstrates how to use the PowerShell cmdlet Invoke-SQLCMD to export data from SQL Server.  Read more...
By Additional Articles 2018/08/30 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,419 reads

The Crimes of Chicago: Working with Data in MongoDB

NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important. In this article, Phil Factor demonstrates how to work with a MongoDB database and how to use PowerShell with MongoDB so that the process can be automated.  Read more...
By Additional Articles 2018/08/27 | Source: SimpleTalk | Category: mongodb
Rating: (not yet rated)  Rate this |   Briefcase | 2,943 reads

Practical PowerShell Processes with SQL Change Automation

How to use the PowerShell cmdlets of SQL Change Automation to take the source code of a database from a directory, validate it, document it and then create a NuGet package of it.  Read more...
By 2018/08/14 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,888 reads

Deploying Multiple Databases from Source Control using SQL Change Automation

Phil Factor demonstrate how to use SQL Change Automation, to take the contents of a source control directory for a database, check that it is possible to build from it, document it and then create a NuGet package and place the code in it  Read more...
By 2018/07/16 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,979 reads

SQL Change Automation with PowerShell Scripts: getting up-and-running

In this article, Phil Factor demonstrates how to use SQL Change Automation, a PowerShell script, to take the contents of a source control directory for a database, check that it is possible to build from it, document it and then create a NuGet package and place the code in it, along with the documentation.   Read more...
By 2018/07/12 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,910 reads

Azure and Windows PowerShell: Getting Information

In the second part of his series, Nicolas Prigent describes in detail how to automate the login process using PowerShell and Azure CLI. Nicolas also explains how to retrieve information about your Azure subscription.  Read more...
By Additional Articles 2018/07/09 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,058 reads

Importing Tricky CSV Files with PowerShell

A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell  Read more...
By Stewart Campbell 2018/07/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,300 reads

What is SQL Change Automation?

William Brewer explores the features of Redgate's SQL Change Automation  Read more...
By 2018/07/03 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 3,168 reads

Hyper-V and PowerShell: Shielded Virtual Machines

In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved in the Windows Server 2019 release. In the second part of this series, Nicolas describes what Shielded Virtual Machines are and how to configure them using PowerShell.  Read more...
By Additional Articles 2018/06/18 | Source: SimpleTalk | Category: hyper-v
Rating: (not yet rated)  Rate this |   Briefcase | 2,683 reads

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2018/05/30 (first published: 2016/05/11) | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 3,580 reads

PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard

Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. In this article, Nicolas Prigent describes PoshUD, and how to use it to monitor your infrastructure using PowerShell.  Read more...
By Additional Articles 2018/05/30 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 4,192 reads

Create Azure VMs with PowerShell Part 2

In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module.  Read more...
By Additional Articles 2018/05/28 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,910 reads

A Great Case for Powershell

PowerShell can be very useful for SQL Server professionals.  Read more...
By Steve Jones 2018/05/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads
   Items 1 to 20 of 300    Older >>