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

Content with tag PowerShell Rss

   Items 1 to 20 of 410    Older >>
 

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

Create Azure VMs with PowerShell Part 1

Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM.  Read more...
By Additional Articles 2018/05/11 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,520 reads

Scripting Objects with PowerShell

In the third installment of this series, Steve Jones uses PowerShell to source control code.  Read more...
By Steve Jones 2018/05/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 814 reads

Powershell To Get Active Directory Users And Groups into SQL

Use Powershell to query AD for Users, Groups and GroupMembers  Read more...
By Lowell Izaguirre 2018/04/27 (first published: 2016/03/31) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 5,504 reads

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.  Read more...
By Ben Miller 2018/04/25 (first published: 2015/12/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,744 reads

dbatools is Growing Up

The dbatools project is rapidly expanding.  Read more...
By Steve Jones 2018/03/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 114 reads

Getting query text from SSMS into a CSV with PowerShell

You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.  Read more...
By Shawn Melton 2018/03/23 (first published: 2015/09/07) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 5,603 reads

Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell

Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.  Read more...
By Mike McQuillan 2018/03/07 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 243 reads

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

Validating Parameters

By Steve Jones 2018/01/30 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 708 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 | 302 reads

Mandatory Parameters

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

Getting the Create Date

By Steve Jones 2018/01/16 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 753 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,951 reads

Testing Variables

By Steve Jones 2018/01/09 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 714 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 | 504 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,638 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,690 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,965 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,480 reads
   Items 1 to 20 of 410    Older >>
 
Tags
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)    
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)    
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)    
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)    
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)