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

Content with tag powershell Rss

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

PowerShell Time Saver: Automatic Defaults

Because PowerShell needs to be usable as an immediate scripting language by IT professionals who type in commands at a console, there have to be language devices such as aliases that can make for terseness when appropriate. There are several ways of cutting down the verbiage in a script, and being able to specify default values via $PSDefaultParameterValues is one of the more generally useful ones. Michael Sorens explains how it can save you time in your daily work.  Read more...
By Additional Articles 2017/04/05 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,774 reads

Connect to MongoDB on Remote Linux Server with Powershell

Return values from MongoDB on Linux server with Powershell  Read more...
By Michael D'Spain 2017/03/20 | Source: SQLServerCentral.com | Category: mongodb
Rating: |  Discuss |   Briefcase | 160 reads

A full and a diff

By Steve Jones 2017/03/16 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 887 reads

Move Azure SQL Databases using the Export and Import PowerShell cmdlets

John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.  Read more...
By Additional Articles 2017/03/08 | Source: MSSQLTips.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,288 reads

Detective Stories - Tracking Down the Database's Dependents Part 2

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/07 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 960 reads

Detective Stories - Tracking Down the Database's Dependents Part I

No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.  Read more...
By Brandie Tarvin 2017/03/06 | Source: SQLServerCentral.com | Category: database dependencies
Rating: |  Discuss |   Briefcase | 1,248 reads

Questions About the Use of PowerShell That you were Too Shy to Ask

Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer's latest addition to the series that answers those seemingly simple questions that you were too shy to ask in public.  Read more...
By Additional Articles 2017/02/22 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 7,261 reads

The default differential

By Steve Jones 2017/02/22 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 899 reads

Lists With, or Without, Ranges in both T-SQL and PowerShell

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.  Read more...
By Additional Articles 2017/02/16 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,632 reads

The differential PoSh backup

By Steve Jones 2017/02/07 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 771 reads

Create and Connect to an Azure SQL Database

Demonstration on how to create and connect to a Microsoft Azure SQL Database with Microsoft Management Studio (SSMS) and Powershell  Read more...
By Thomas Liddle 2017/02/06 | Source: SQLServerCentral.com | Category: azsure sql database
Rating: |  Discuss |   Briefcase | 800 reads

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.  Read more...
By Additional Articles 2017/02/03 | Source: MSSQLTips.com | Category: powershell
Rating:  Rate this |   Briefcase | 4,800 reads

Azure SQL Data Warehouse with PowerShell

We will teach how to create a new SQL Azure Data Warehouse using Powershell  Read more...
By Daniel Calbimonte 2017/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 511 reads

Hyper-V and PowerShell: The Basics

Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.  Read more...
By Additional Articles 2017/01/27 | Source: SimpleTalk | Category: hyper-v
Rating:  Rate this |   Briefcase | 6,115 reads

Powershell Script to find a SQL\Windows login in SQL Server

This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server  Read more...
By Vishnu Gupthan 2017/01/26 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 439 reads

The default PoSh backup

By Steve Jones 2017/01/24 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 866 reads

The (Former) Complexity of PowerShell

Steve Jones notes that PowerShell seems to becoming an easier to use language for SQL Server professionals.  Read more...
By Steve Jones 2017/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 166 reads

Backing Up SQL Server Databases is Easier in PowerShell than T-SQL

Learn how easy the new SQLServer module makes backups of SQL Server databases.  Read more...
By Aaron Nelson 2017/01/12 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,337 reads

Powershell Script for regular DBA activities

This script will perfrom following tasks : 1. BackUp DB 2. Restore DB from BackUp File 3. Restore DB from DB 4. Create a new DB from Existing Db It takes care of all the possible failures during these operations, while done manually.   Read more...
By Mayank Shukla 2017/01/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,230 reads
<< Newer    Items 21 to 40 of 392    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)    
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)    
registered servers (2)    
roles (2)    
script (2)    
scripting (2)    
server (2)    
size (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)    
availability groups (1)    
availability groups (ag) (1)    
aws (1)    
azsure sql database (1)    
azure iaas vm (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)    
database delivery (1)    
database mail (1)    
database space (1)    
datafile (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)    
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)    
query (1)    
quoted_identifier (1)    
r language (1)    
redgate (1)    
remote (1)    
remote servers (1)    
remoting (1)    
remove-sqllogin (1)    
replication tracking (1)    
report (1)    
resource groups (1)    
resource monitor (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 clone (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)