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

Content with tag PowerShell Rss

   Items 1 to 20 of 419    Older >>
 

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 | 1,831 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,283 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 | 1,655 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,142 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 | 2,889 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,435 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,477 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 | 3,913 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,520 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 | 76 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,694 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 | 857 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,585 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,803 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 | 118 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,618 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 | 246 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 | 255 reads

Validating Parameters

By Steve Jones 2018/01/30 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 716 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 | 320 reads
   Items 1 to 20 of 419    Older >>
 
Tags
blogs (35)    
smo (21)    
administration (20)    
stairway series (14)    
editorial (13)    
azure (12)    
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)    
automation (5)    
database weekly (5)    
maintenance (5)    
active directory (4)    
agent jobs (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 change automation (3)    
sql jobs (3)    
sql server 2012 (3)    
windows 2012 (3)    
availability group (ag) (2)    
c# (2)    
cluster (2)    
clustering (2)    
compare (2)    
csv (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)    
bulkinsert (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)    
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)    
etl (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)    
nuget (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)