Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag powershell Rss

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

PowerShell script to check last backup date for Databases

PowerShell script to check last full backup, transaction log backup date for SQL Server databases.  Read more...
By shuvo 2014/09/02 | Source: SQLServerCentral.com | Category: daily dba task
Rating: |  Discuss |   Briefcase | 1,208 reads

Database size trending with powershell

a script to import all database sizes from a list of servers into a table using powershell for trending purposes YOU MUST DOWNLOAD CODEPLEX SQL SERVER MODULE FOR THIS TO WORK.  Read more...
By Gene Hunter 2014/08/29 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,772 reads

Powershell - Export Stored Proc results to CSV file

This Powershell script calls a stored procedure and exports the results to a CSV file  Read more...
By Mandeep Dulai 2014/08/28 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,110 reads

PowerShell to SlipStream SQL 2008

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.  Read more...
By Fahim Ahmad 2014/08/27 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 954 reads

Check SQL Error Logs using Powershell

Dynamically check your SQL Error Logs and filter using Powershell.  Read more...
By Jim Breffni 2014/08/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,870 reads

Powershell script to read Windows 2012 R2 Failover cluster log for Sql

I was having a hard time to reading the Windows 2012 R2 Failover cluster log from my live server. That is why I just wrote a simple PowerShell script to get the job done for me.  Read more...
By shuvo 2014/08/21 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 641 reads

Data Mining: Part 13 Powershell

In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.  Read more...
By Daniel Calbimonte 2014/08/12 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 5,260 reads

Using PowerShell to Manage Windows Azure SQL Databases

Marcin Policht provides a comprehensive overview of Windows PowerShell’s capabilities in regard to managing SQL Databases (or, in general, cloud-resident resources).  Read more...
By Additional Articles 2014/07/18 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 2,566 reads

Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)

This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS.   Read more...
By Additional Articles 2014/07/16 | Source: MSSQLTips.com | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 11,172 reads

What is the true value?

By Gary Varga 2014/07/14 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 1,819 reads

Finding Unused SQL Server Stored Procedures With PowerShell

Tim Smith describes a number of ways to tell which Stored Procedures are in use, DMVs, a SQL Server Trace, and his preferred method, the Source Code and PowerShell.  Read more...
By Additional Articles 2014/07/07 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 4,070 reads

PowerShell One-Liners: Accessing, Handling and Writing Data

In the grand finale to Michael Sorens' series of PowerShell one-liners, we come to the handling of data, reading it in and writing it out, whether by files; input/output streams or a database. It shows how it can be done in a variety of formats including CSV, JSON, and XML.  Read more...
By Additional Articles 2014/06/19 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,802 reads

Anything Remotely Useful

Phi Factor on how to combine PowerShell Remoting with slick Windows tools such as SQLPSX, Boxstarter and Chocolatey, to automate the development process right through to delivery.  Read more...
By Phil Factor 2014/06/09 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 66 reads

Start a job at a defined step on another sql instance

this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.  Read more...
By az352001 2014/06/04 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 695 reads

Extracting data with headers using PowerShell

This article provides a short PowerShell script to extrace data from a database using PowerShell.  Read more...
By Louis Li 2014/06/03 | Source: SQLServerCentral.com | Category: extracting data
Rating: |  Discuss |   Briefcase | 4,079 reads

PowerShell One-Liners: Collections, Hashtables, Arrays and Strings

The way to learn PowerShell is to browse and nibble, rather than to sit down to a formal five-course meal. In his continuing series on PowerShell one-liners, Michael Sorens provides Fast Food for busy professionals who want results quickly and aren't too faddy. Part 3 has as its tasty confections - Collections, Hashtables, arrays and strings.  Read more...
By Additional Articles 2014/06/02 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 4,376 reads

Powershell script to report old backup files

Get a report of backups older than 60 days.  Read more...
By Rolando Hernandez 2014/05/30 | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 893 reads

Extract and convert all Excel worksheets into CSV files using PowerShell

Can PowerShell provide an easy way to export Excel as a CSV? Yes. Tim Smith demonstrates that whether you have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process.   Read more...
By Additional Articles 2014/05/21 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,445 reads

Validate File Properties with PowerShell Prior to Import into SQL Server

We recently faced an issue where an internal data provider began providing an incomplete or inaccurate files because it lacked the proper length (or didn't exceed a certain size). In our case, we implemented a check on the file before importing using PowerShell, here's what we did.  Read more...
By Additional Articles 2014/05/15 | Source: MSSQLTips.com | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,720 reads

Stairway to SQL PowerShell Level 7: SQL Server PowerShell and the Basics of SMO

In this level we begin our journey into the SQL Server SMO space. SMO stands for Shared Management Objects and is a library written in .NET for use with SQL Server. The SMO library is available when you install SQL Server Management Tools or you install it separately.  Read more...
By Ben Miller 2014/05/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,288 reads
<< Newer    Items 21 to 40 of 256    Older >>
 
Tags
blogs (34)    
smo (18)    
administration (16)    
stairway series (10)    
sql server 2005 (8)    
backup / restore (6)    
editorial (6)    
integration services (ssis) (6)    
monitoring (6)    
amo (5)    
analysis services (ssas) (5)    
sql server (5)    
azure (4)    
backup (4)    
database weekly (4)    
jobs (4)    
sql agent (4)    
active directory (3)    
oracle (3)    
partitioning (3)    
reporting services (ssrs) (3)    
restore (3)    
sql server 2012 (3)    
windows 2012 (3)    
automation (2)    
cluster (2)    
database (2)    
dimensions (2)    
disk space (2)    
extract, transform, load (etl) (2)    
maintenance (2)    
perfmon (2)    
policy based management (pbm) (2)    
recovery model (2)    
script (2)    
scripting (2)    
security (2)    
sql server 2008 (2)    
transaction logs (2)    
t-sql (2)    
webinar (2)    
windows 2008 r2 (2)    
windows azure sql database (2)    
ansi_nulls (1)    
auditing (1)    
availability groups (1)    
backup / recovery (1)    
backups (1)    
bi (1)    
capacity planning (1)    
central management server (cms) (1)    
checkdb (1)    
command line install (1)    
connectivity (1)    
creation (1)    
csv (1)    
cube (1)    
daily dba task (1)    
data flow (1)    
data gathering (1)    
data mining (1)    
database mail (1)    
database space (1)    
dba (1)    
dbcc checkdb (1)    
document environment (1)    
documentation (1)    
domain (1)    
enterprise manager (1)    
epm (1)    
error handling (1)    
error log (1)    
errorlogs (1)    
event log (1)    
events (1)    
extracting data (1)    
extracting data with header (1)    
failover cluster (1)    
file system task (1)    
find stored procedures (1)    
fragmentation (1)    
free training (1)    
html (1)    
indexing (1)    
interactive (1)    
introduction (1)    
log shipping (1)    
logins (1)    
management (1)    
migration (1)    
mirroring (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)    
powershell modules (1)    
powershell objects (1)    
profiler (1)    
quoted_identifier (1)    
registered servers (1)    
remote servers (1)    
remoting (1)    
report (1)    
resource groups (1)    
schemas (1)    
script jobs (1)    
scripting jobs (1)    
service restart (1)    
services (1)    
silent install (1)    
simple-talk series (1)    
size (1)    
sliding windows (1)    
sliding windows technique (1)    
slipstream (1)    
sql alerts (1)    
sql aliases (1)    
sql compare (1)    
sql discovery (1)    
sql job (1)    
sql jobs (1)    
sql server 7 (1)    
sql server cluster (1)    
sqlcmd (1)    
sqljob (1)    
sqljobs (1)    
sqlpsx (1)    
sqlserver (1)    
ssms (1)    
string manipulation (1)    
textmode (1)    
trending (1)    
troubleshooting (1)    
twitter (1)    
unattended install (1)    
unit testing (1)    
users (1)    
virtualization (1)    
vm (1)    
windows cluster (1)    
wmi (1)    
wmi events queries (1)    
wql (1)    
xmla (1)