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 261    Older >>
 

How to Automatically Create and Refresh Development and Test Databases

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database is big. Phil illustrates a solution by taking a set of Redgate tools to show how they can be used together, via PowerShell, to build a database from object-level source, stock it with data, document it, and then provision any number of test and development servers with the database build, taking care to save any DDL changes to the existing copies of the database.  Read more...
By Additional Articles 2017/08/08 | Source: SimpleTalk | Category: database delivery
Rating:  Rate this |   Briefcase | 3,832 reads

PowerShell Tool Time: The Tool Framework

Start learning Powershell (PoSh) for SQL Server and improve your ability to write utilities that will make your job easier.  Read more...
By Mike Fal 2017/07/07 (first published: 2015/08/19) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 8,547 reads

PowerShell Scripting to Replicate Cloud & SaaS Data to SQL Server

Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell  Read more...
By Jerod Johnson 2017/06/01 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 410 reads

Comparing and Synchronizing Two Folders with Azure

In this article, we will compare two folders using PowerShell, the command prompt and other tools.  Read more...
By Daniel Calbimonte 2017/05/30 | Source: SQLServerCentral.com | Category: compare
Rating: |  Discuss |   Briefcase | 277 reads

Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot

When you are automating a number of tasks, or performing a batch of tests, you want a way of automating the production of your plots and graphs. Nothing beats a good graphical plot for giving the indications of how the process went. If you are using PowerShell and maybe also SQL Server, it pays to use a command-line plotting tool such as Gnuplot to do all the hard work. It turns out to be handy for a range of data jobs, turning PowerShell into a handy data science tool.  Read more...
By Additional Articles 2017/05/29 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,551 reads

How to document multiple SQL Server databases using SQL Doc and PowerShell

You can use SQL Doc’s command-line parameters to automate database documentation, but when you try with a group of databases on a server, they sometimes don’t give you enough control over the job. Phil Factor provides a solution that allows both automation and flexibility.  Read more...
By Additional Articles 2017/05/23 | Source: Redgate | Category: sql doc
Rating:  Rate this |   Briefcase | 3,538 reads

Best option for working with Files in SSIS

This time we will compare different solutions to copy system folders using different SSIS tasks.  Read more...
Rating: |  Discuss |   Briefcase | 1,589 reads

Deploying Multiple SSIS Projects via PowerShell

When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky. Nat Sundar describes how he created a Deployment script that is intended to provision a Data Warehouse for System Integrated testing (SIT).  Read more...
By Additional Articles 2017/05/08 | Source: SimpleTalk | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 4,426 reads

PowerShell Time Saver: Automatic Defaults

Because PowerShell needs to be usable as an immediate scripting language by IT professionals who type in commands at a console, there have to be language devices such as aliases that can make for terseness when appropriate. There are several ways of cutting down the verbiage in a script, and being able to specify default values via $PSDefaultParameterValues is one of the more generally useful ones. Michael Sorens explains how it can save you time in your daily work.  Read more...
By Additional Articles 2017/04/05 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,485 reads

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.  Read more...
By Additional Articles 2017/03/08 | Source: MSSQLTips.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,991 reads

Detective Stories - Tracking Down the Database's Dependents Part 2

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/07 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 953 reads

Detective Stories - Tracking Down the Database's Dependents Part I

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/06 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 1,241 reads

Questions About the Use of PowerShell That you were Too Shy to Ask

Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer's latest addition to the series that answers those seemingly simple questions that you were too shy to ask in public.  Read more...
By Additional Articles 2017/02/22 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 6,717 reads

Lists With, or Without, Ranges in both T-SQL and PowerShell

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.  Read more...
By Additional Articles 2017/02/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,387 reads

Create and Connect to an Azure SQL Database

Demonstration on how to create and connect to a Microsoft Azure SQL Database with Microsoft Management Studio (SSMS) and Powershell  Read more...
By Thomas Liddle 2017/02/06 | Source: SQLServerCentral.com | Category: azsure sql database
Rating: |  Discuss |   Briefcase | 782 reads

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.  Read more...
By Additional Articles 2017/02/03 | Source: MSSQLTips.com | Category: powershell
Rating:  Rate this |   Briefcase | 4,503 reads

Azure SQL Data Warehouse with PowerShell

We will teach how to create a new SQL Azure Data Warehouse using Powershell  Read more...
By Daniel Calbimonte 2017/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 467 reads

Hyper-V and PowerShell: The Basics

Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.  Read more...
By Additional Articles 2017/01/27 | Source: SimpleTalk | Category: hyper-v
Rating:  Rate this |   Briefcase | 5,896 reads

The (Former) Complexity of PowerShell

Steve Jones notes that PowerShell seems to becoming an easier to use language for SQL Server professionals.  Read more...
By Steve Jones 2017/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 166 reads

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

Learn how easy the new SQLServer module makes backups of SQL Server databases.  Read more...
By Aaron Nelson 2017/01/12 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,242 reads
   Items 1 to 20 of 261    Older >>