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

Content with tag PowerShell Rss

   Items 1 to 20 of 431    Older >>
 

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2018/11/14 (first published: 2015/12/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,532 reads

String Replace in Stored Procedures with Powershell

Find a string in a stored procedure and replace with powershell  Read more...
By Michael D'Spain 2018/11/13 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 195 reads

Testing PowerShell Modules with Pester

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.  Read more...
By Additional Articles 2018/11/12 | Source: SimpleTalk | Category: pester
Rating: (not yet rated)  Rate this |   Briefcase | 1,586 reads

The Pesky Windows Power Plan Oh My

The below script will build a csv file for import of the servers Power Plan Setting.  Read more...
By Edward Pochinski 2018/11/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 195 reads

Azure and Windows PowerShell: Using VM Extensions

In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure Virtual Machines. Nicolas explains how to use Azure VM Extensions using the Azure PowerShell module to save time during the provisioning process.  Read more...
By Additional Articles 2018/11/05 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,779 reads

Exhuming the GDPR Bodies

Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that data in file shares  Read more...
By Additional Articles 2018/10/01 | Source: SimpleTalk | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 2,246 reads

PowerShell Tool Time: Building Help

Learn how you can customize the help for your library of scripts in this edition of PowerShell Tool Time.  Read more...
By Mike Fal 2018/09/28 (first published: 2016/01/06) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 3,691 reads

Advanced Testing of Your PowerShell Code with Pester

Testing your PowerShell scripts is just as important as testing any code. In this article, Robert Cain demonstrates how to use the testing tool, Pester, to perform unit, integration, and acceptance testing.  Read more...
By Additional Articles 2018/09/20 | Source: SimpleTalk | Category: test
Rating: (not yet rated)  Rate this |   Briefcase | 2,130 reads

Introduction to Testing Your PowerShell Code with Pester

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code.  Read more...
By Additional Articles 2018/09/06 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,512 reads

Introduction to PowerShell with SQL Server Using Invoke-SQLCMD

PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer SQL Server or even just export data. In this article, Greg Moore demonstrates how to use the PowerShell cmdlet Invoke-SQLCMD to export data from SQL Server.  Read more...
By Additional Articles 2018/08/30 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,424 reads

The Crimes of Chicago: Working with Data in MongoDB

NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important. In this article, Phil Factor demonstrates how to work with a MongoDB database and how to use PowerShell with MongoDB so that the process can be automated.  Read more...
By Additional Articles 2018/08/27 | Source: SimpleTalk | Category: mongodb
Rating: (not yet rated)  Rate this |   Briefcase | 2,946 reads

Practical PowerShell Processes with SQL Change Automation

How to use the PowerShell cmdlets of SQL Change Automation to take the source code of a database from a directory, validate it, document it and then create a NuGet package of it.  Read more...
By 2018/08/14 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,891 reads

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 | 2,983 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,914 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 | 2,061 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,300 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 | 3,173 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,686 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,581 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 | 4,196 reads
   Items 1 to 20 of 431    Older >>
 
Tags
blogs (35)    
administration (21)    
smo (21)    
stairway series (14)    
azure (13)    
editorial (13)    
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)    
objects (4)    
restore (4)    
sql agent (4)    
sql change automation (4)    
desired state configuration (3)    
management studio (ssms) (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
security (3)    
sql jobs (3)    
sql server 2012 (3)    
sqlcmd (3)    
vm (3)    
windows 2012 (3)    
availability group (ag) (2)    
c# (2)    
cluster (2)    
clustering (2)    
cmdlets (2)    
compare (2)    
csv (2)    
data lake (2)    
database (2)    
database dependencies (2)    
dba (2)    
dbatools.io (2)    
dimensions (2)    
disk space (2)    
dsc (2)    
error log (2)    
extract, transform, load (etl) (2)    
hyper-v (2)    
indexing (2)    
mongodb (2)    
nuget (2)    
perfmon (2)    
pester (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)    
stored procedures (2)    
transaction log (2)    
users (2)    
u-sql (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)    
bash (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)    
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 administration (1)    
database delivery (1)    
database mail (1)    
database space (1)    
datafile (1)    
date manipulation (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)    
gdpr (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)    
monitor (1)    
ms sql 2008 policy-based management & (1)    
msbi (1)    
multi-server management (1)    
nosql database (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)    
string manipulation (1)    
string replace (1)    
sysadmin (1)    
tabular model (1)    
test (1)    
testing (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)