Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag powershell Rss

   Items 1 to 20 of 366    Older >>
 

The default differential

By Steve Jones 2017/02/22 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 692 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 | 4,188 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 | 3,393 reads

The differential PoSh backup

By Steve Jones 2017/02/07 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 699 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 | 713 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 | 3,669 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 | 419 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 | 4,699 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 | 350 reads

The default PoSh backup

By Steve Jones 2017/01/24 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 814 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 | 135 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 | 1,945 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 | 835 reads

Using SQLite with PowerShell and SQL Server

When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfamiliar with the database, he includes a giant-sized SQLite version of the old PUBS database that the first generation of RDBMS developers cut their teeth on.  Read more...
By Additional Articles 2017/01/09 | Source: SimpleTalk | Category: sqlite
Rating: (not yet rated)  Rate this |   Briefcase | 2,886 reads

Managing Packages Using Windows PowerShell

Windows hasn't had a package manager in the style of the Advanced Packaging Tool (APT) of Linux distributions. Apt-get is a great way of installing packages and other software. We have Chocolatey, of course which has a growing library of software and even allows you to automatically update software. Now PowerShell has an 'official' way of using any system, such as NuGet, Chocolatey, GitHub or PSget. It is definitely useful and likely to mature into an indispensable tool for Windows users. Nicolas explains wh.  Read more...
By Additional Articles 2016/12/23 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 3,047 reads

Getting the version of Powershell

By Steve Jones 2016/12/12 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 854 reads

Drive Space

Combine Drive Space report for all Servers  Read more...
By Mashrur Shuvo 2016/12/06 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,308 reads

Getting Modules

By Steve Jones 2016/12/05 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 868 reads

Managing SQL Server with PowerShell

By Steve Jones 2016/11/28 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 969 reads
   Items 1 to 20 of 366    Older >>
 
Tags
blogs (35)    
smo (21)    
administration (20)    
stairway series (14)    
editorial (10)    
backup (9)    
sql server (9)    
sql server 2005 (8)    
azure (7)    
backup and restore (7)    
integration services (ssis) (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
database weekly (5)    
maintenance (5)    
sql (5)    
active directory (4)    
agent jobs (4)    
restore (4)    
sql agent (4)    
t-sql (4)    
automation (3)    
desired state configuration (3)    
logins (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
security (3)    
sql jobs (3)    
sql server 2012 (3)    
ssms (3)    
windows 2012 (3)    
cluster (2)    
clustering (2)    
database (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)    
script (2)    
scripting (2)    
server (2)    
size (2)    
sql server 2008 (2)    
sqlcmd (2)    
transaction log (2)    
webinar (2)    
windows 2008 r2 (2)    
windows azure sql database (2)    
ado (1)    
ado.net (1)    
ansi_nulls (1)    
auditing (1)    
availability groups (ag) (1)    
azsure sql database (1)    
azure iaas vm (1)    
backups (1)    
bcp (1)    
best practice (1)    
bi (1)    
binary cmdlets (1)    
c# (1)    
capacity planning (1)    
central management server (cms) (1)    
checkdb (1)    
cmdlets (1)    
command line install (1)    
compare (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)    
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)    
extracting data (1)    
extracting data with header (1)    
file system task (1)    
find stored procedures (1)    
fragmentation (1)    
free training (1)    
get-sqllogin (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)    
migration (1)    
mirroring (1)    
monitor (1)    
ms sql 2008 policy-based management & (1)    
multi-server management (1)    
objects (1)    
old files (1)    
pass (1)    
performance counters (1)    
performance monitoring (1)    
permissions (1)    
postgres (1)    
powershell tool time (1)    
profiler (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)    
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 login using powershell (1)    
sql server 7 (1)    
sql server connections (1)    
sql server service accounts (1)    
sql service accounts (1)    
sqlite (1)    
sqljob (1)    
sqljobs (1)    
sqlps (1)    
sqlpsx (1)    
sqlserver (1)    
stored procedures (1)    
string manipulation (1)    
text (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
uml (1)    
unattended install (1)    
unit testing (1)    
users (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)    
xmla (1)