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

Content with tag PowerShell Rss

   Items 1 to 20 of 402    Older >>
 

Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell

In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.  Read more...
By Daniel Calbimonte 2018/02/15 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 172 reads

Validating Parameters

By Steve Jones 2018/01/30 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 666 reads

Insert data into a SQL Server Table using Powershell using Invoke-SQLc

How to insert data into a SQL Server Table using Powershell using Invoke-SQLcmd Commandlet  Read more...
By Vishnu Gupthan 2018/01/24 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 250 reads

Mandatory Parameters

By Steve Jones 2018/01/23 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 663 reads

Getting the Create Date

By Steve Jones 2018/01/16 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 720 reads

How to automatically provision sanitized data using SQL Clone, Data Masker, and PowerShell

This article describes a strategy, using data masking, cloned databases, and PowerShell, which will allow you to sanitize data before it is copied or moved, for example from a production environment into testing or development environments.  Read more...
By 2018/01/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,708 reads

Testing Variables

By Steve Jones 2018/01/09 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 697 reads

Powershell Script for regular DBA activities_GenerateScripts

Powershell utility for generating scripts for db tables with / without identity columns.It can also produce scripts for fixed number of rows  Read more...
By Mayank Shukla 2018/01/02 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 415 reads

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,616 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,526 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,874 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,246 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,193 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 | 441 reads

Get-DbaPowerShell

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 | 82 reads

Get SSAS Tabular Model (2016) Roles using Powershell `

Extract roles from 2016 Tabular Models using Powershell.   Read more...
By Thasigan Chetty 2017/09/14 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 113 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 | 598 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 | 192 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,410 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 | 738 reads
   Items 1 to 20 of 402    Older >>
 
Tags
blogs (35)    
smo (21)    
administration (20)    
stairway series (14)    
backup (11)    
editorial (11)    
sql server (10)    
integration services (ssis) (9)    
azure (8)    
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)    
objects (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
security (3)    
sql jobs (3)    
sql server 2012 (3)    
ssms (3)    
windows 2012 (3)    
availability group (ag) (2)    
c# (2)    
cluster (2)    
clustering (2)    
compare (2)    
database (2)    
database dependencies (2)    
dimensions (2)    
disk space (2)    
dsc (2)    
error log (2)    
extract, transform, load (etl) (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)    
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 lake (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)    
dbatools.io (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)    
hyper-v (1)    
ignore identity column (1)    
import-module (1)    
installation (1)    
interactive (1)    
introduction (1)    
linux (1)    
log shipping (1)    
logfile (1)    
management (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)    
tabular model (1)    
text (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
uml (1)    
unattended install (1)    
unit testing (1)    
u-sql (1)    
virtual chapters (1)    
virtualization (1)    
vm (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)