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

Content with tag powershell Rss

<< Newer    Items 21 to 40 of 414    Older >>

PowerShell Tool Time: Controlling Our Tools

The next installment of the Powershell Tool Time series shows you how to manage backup files by   Read more...
By Mike Fal 2018/01/01 (first published: 2015/09/16) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 4,642 reads

An Introduction to PowerShell for a DBA

An introduction to PowerShell that covers basics alone with some more advanced features. It will walk you through from the very beginning to the writing of a few useful scripts.  Read more...
By Alex Chamchourine 2017/12/21 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,717 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2017/12/06 (first published: 2012/10/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,970 reads

Backup SQL Server Databases in Parallel with PowerShell

I have a need to decrease the time my SQL Server database backups are taking to run. I thought about trying to run multiple backups at the same time to see if that would work. I could have created multiple SQL Server Agent Jobs to run at the same time, but I wanted a more dynamic way to handle this, so I created a PowerShell script that allows processes to run in parallel.  Read more...
By Additional Articles 2017/10/30 | Source: MSSQLTips.com | Category: parallel processing
Rating: (not yet rated)  Rate this |   Briefcase | 3,543 reads

8 Ways to Export SQL Results To a Text File

This tip will show eight ways to export the results of a query to a text file.  Read more...
By Daniel Calbimonte 2017/10/06 (first published: 2016/10/26) | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 6,608 reads

Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell

Learn how PowerShell can be used to manage files and folders in your Data Lake.  Read more...
By Mike McQuillan 2017/10/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 473 reads


Steve Jones talks PowerShell and how it is a skill that you might find useful.  Read more...
By Steve Jones 2017/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 83 reads

Get SSAS Tabular Model (2016) Roles using Powershell `

Extract roles from 2016 Tabular Models using Powershell.  
By Thasigan Chetty 2017/09/14 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 127 reads

Automate MSBI deployments Using PowerShell

There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.  Read more...
By Kunal Rathi 2017/09/14 | Source: SQLServerCentral.com | Category: msbi
Rating: |  Discuss |   Briefcase | 642 reads

Add new Databases to a AG Setup with PowerShell

Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 206 reads

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is a good choice when your organisation uses AWS. RDS deals with maintenance and monitoring, and supports the use of PowerShell to automate routine tasks. What if a script needs to be triggered by an unscheduled event? Even in this case, RDS can be configured to run scripts to react when something like a failover happens. Laerte Junior shows how easy it is to set up Lambda functions and some PowerShell scripts to automatically synchronise agent jobs after a failover.  Read more...
By Additional Articles 2017/08/30 | Source: SimpleTalk | Category: aws
Rating: (not yet rated)  Rate this |   Briefcase | 2,650 reads

Load Extended Events via Powershell

Learn how you can load Extended Events with PowerShell, nice and fast.  Read more...
By Aakash Patel 2017/08/22 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 755 reads

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 | 4,800 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,689 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 | 424 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 | 287 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 | 3,179 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 | 4,143 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,665 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 | 5,626 reads
<< Newer    Items 21 to 40 of 414    Older >>
blogs (35)    
smo (21)    
administration (20)    
stairway series (14)    
editorial (13)    
azure (11)    
backup (11)    
sql server (10)    
integration services (ssis) (9)    
sql server 2005 (8)    
backup and restore (7)    
monitoring (6)    
sql (6)    
t-sql (6)    
amo (5)    
analysis services (ssas) (5)    
database weekly (5)    
maintenance (5)    
active directory (4)    
agent jobs (4)    
automation (4)    
logins (4)    
restore (4)    
sql agent (4)    
desired state configuration (3)    
management studio (ssms) (3)    
objects (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
security (3)    
sql jobs (3)    
sql server 2012 (3)    
windows 2012 (3)    
availability group (ag) (2)    
c# (2)    
cluster (2)    
clustering (2)    
compare (2)    
data lake (2)    
database (2)    
database dependencies (2)    
dbatools.io (2)    
dimensions (2)    
disk space (2)    
dsc (2)    
error log (2)    
extract, transform, load (etl) (2)    
hyper-v (2)    
indexing (2)    
perfmon (2)    
policy based management (pbm) (2)    
recovery model (2)    
redgate (2)    
registered servers (2)    
roles (2)    
script (2)    
scripting (2)    
server (2)    
size (2)    
sql clone (2)    
sql server 2008 (2)    
sqlcmd (2)    
transaction log (2)    
users (2)    
u-sql (2)    
vm (2)    
webinar (2)    
windows 2008 r2 (2)    
windows azure sql database (2)    
ado (1)    
ado.net (1)    
amazon rds (1)    
ansi_nulls (1)    
auditing (1)    
aws (1)    
azsure sql database (1)    
azure iaas vm (1)    
azure sql data warehouse (asdw) (1)    
azure sql database (1)    
backups (1)    
bcp (1)    
best practice (1)    
bi (1)    
big data (1)    
binary cmdlets (1)    
capacity planning (1)    
central management server (cms) (1)    
checkdb (1)    
cmdlets (1)    
command line install (1)    
compare windows hotfix (1)    
connectivity (1)    
copy (1)    
create (1)    
creation (1)    
csv (1)    
cube (1)    
daily dba task (1)    
data (1)    
data flow (1)    
data gathering (1)    
data mining (1)    
data script with fixed rows (1)    
data scripts (1)    
database delivery (1)    
database mail (1)    
database space (1)    
datafile (1)    
date manipulation (1)    
dba (1)    
dbcc checkdb (1)    
diagrams (1)    
dmv (1)    
document environment (1)    
documentation (1)    
documenting (1)    
domain (1)    
drive space (1)    
email (1)    
enterprise manager (1)    
epm (1)    
error handling (1)    
event log (1)    
events (1)    
export (1)    
extended events (xe) (1)    
extracting data (1)    
extracting data with header (1)    
file system task (1)    
find stored procedures (1)    
folders (1)    
fragmentation (1)    
free training (1)    
get-sqllogin (1)    
gnuplot (1)    
google (1)    
healthcheck (1)    
html (1)    
ignore identity column (1)    
import-module (1)    
installation (1)    
interactive (1)    
introduction (1)    
linux (1)    
log shipping (1)    
logfile (1)    
management (1)    
metadata (1)    
microsoft bi (1)    
migration (1)    
mirroring (1)    
mongodb (1)    
monitor (1)    
ms sql 2008 policy-based management & (1)    
msbi (1)    
multi-server management (1)    
object/database level permissions (1)    
old files (1)    
parallel processing (1)    
pass (1)    
performance counters (1)    
performance monitoring (1)    
permissions (1)    
postgres (1)    
powershell to generate server level permissions (1)    
powershell tool time (1)    
profiler (1)    
provisioning (1)    
query (1)    
quoted_identifier (1)    
r language (1)    
remote (1)    
remote servers (1)    
remoting (1)    
remove-sqllogin (1)    
replication tracking (1)    
report (1)    
resource groups (1)    
resource monitor (1)    
schema scripts (1)    
schemas (1)    
script jobs (1)    
scripting jobs (1)    
service restart (1)    
services (1)    
silent install (1)    
simple-talk series (1)    
sliding windows (1)    
sliding windows technique (1)    
slipstream (1)    
sql alerts (1)    
sql aliases (1)    
sql azure (1)    
sql compare (1)    
sql discovery (1)    
sql doc (1)    
sql login using powershell (1)    
sql server 7 (1)    
sql server connections (1)    
sql server service accounts (1)    
sql service accounts (1)    
sql toolbelt (1)    
sqlite (1)    
sqljob (1)    
sqljobs (1)    
sqlps (1)    
sqlpsx (1)    
sqlserver (1)    
ssas (1)    
stored procedures (1)    
string manipulation (1)    
sysadmin (1)    
tabular model (1)    
text (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
uml (1)    
unattended install (1)    
unit testing (1)    
version control systems (vcs) (1)    
virtual chapters (1)    
virtual machine (1)    
virtualization (1)    
warehouse (1)    
windows cluster (1)    
windows login (1)    
windows management framework (1)    
wmi (1)    
wmi events queries (1)    
wql (1)    
xe (1)    
xmla (1)