Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
powershell
Refine your search with one of the following additional tags (with number of items):
SMO
(9)
Extract, Transform, Load (ETL)
(2)
Database Space
(1)
SQL Server
(1)
SQL Server 2005
(8)
SQL Agent
(2)
DBA
(1)
SQL Server 2008
(1)
AMO
(5)
Administration
(1)
disk space
(1)
SQL Server 7, 2000
(1)
Analysis Services (SSAS)
(5)
Backup / Restore
(1)
Enterprise Manager
(1)
SQL Server Reporting Services
(1)
Blogs
(4)
Backup and Recovery
(1)
Monitoring
(1)
SSRS
(1)
Backup
(2)
Capacity planning
(1)
Registered Servers
(1)
Twitter
(1)
Dimensions
(2)
Cube
(1)
Reporting Services (SSRS)
(1)
XMLA
(1)
Items 1 to 20 of 43
Next 20 >>
Backup SQL Server Databases with a Windows PowerShell Script
In a previous tip on Backup and Restore SQL Server databases programmatically with SMO, you've seen how you can use Windows PowerShell to backup and restore SQL Server databases. In this tip, I will cover how to use Windows PowerShell to generate SQL Server backups
Read more...
By
Additional Articles
2009/10/29
|
Source:
MSSQLTips.com
|
Category:
Backup and Recovery
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,146 reads
Database Space Capacity Planning
Describes a process to create a consolidated space forecasting report, which focuses on a "days remaining" metric.
Read more...
By
Chad Miller
2009/10/13
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
5,622 reads
Generating SQL Scripts using Windows PowerShell
In a previous tip on SQL Script Generation Programmatically with SMO, you've seen how you can use SMO to generate SQL scripts programmatically. In this tip I will cover how to generate scripts using Windows PowerShell.
Read more...
By
Additional Articles
2009/10/01
|
Source:
MSSQLTips.com
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,155 reads
PowerShell 101 for the DBA: Querying Your Servers with PowerShell
In my last blog post, I discussed how to get PowerShell and SQLPS up and running on your machine(s). And...
Read more...
By
Joshua Jones
2009/09/22
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
Rate this
|
Briefcase
|
1,251 reads
PowerShell 101 for the DBA – Installing PowerShell
Many DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You...
Read more...
By
Joshua Jones
2009/09/15
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,319 reads
Using Twitter and PowerShell to Find Technical Information and Join a Community
Using PowerShell and a little bit of .NET Framework and XML knowledge, it is possible to delve a little deeper into the information which is potentially available to you from Twitter. Jonathan explains about Twitter and shows how to use Powershell to access twitter automatically.
Read more...
By
Additional Articles
2009/08/14
|
Source:
SimpleTalk
|
Category:
Twitter
Rating:
Rate this
|
Briefcase
|
1,892 reads
Checking SQL Server Agent jobs using Windows PowerShell
Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?
Read more...
By
Additional Articles
2009/07/28
|
Source:
MSSQLTips.com
|
Category:
SQL Agent
Rating:
Rate this
|
Briefcase
|
1,937 reads
Retrieve List of Databases and their Properties using PowerShell
I would like to translate some of the Transact-SQL scripts that I use every day, starting with the simple ones like retrieving a list of databases and their properties for auditing purposes.
Read more...
By
Additional Articles
2009/06/11
|
Source:
MSSQLTips.com
|
Category:
powershell
Rating:
Rate this
|
Briefcase
|
2,880 reads
Backup Monitoring and Reporting
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.
Read more...
By
Chad Miller
2009/06/04
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
|
Discuss
|
Briefcase
|
8,071 reads
Using PowerShell with SQL Server Management Objects (SMO)
I want to know how Windows PowerShell can help me as a SQL Server DBA.
Read more...
By
Additional Articles
2009/05/18
|
Source:
MSSQLTips.com
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,758 reads
Script a cube using Windows PowerShell and AMO
This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file.
Read more...
By
Additional Articles
2009/05/12
|
Source:
Database Journal
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
969 reads
Script dimensions using Windows PowerShell and AMO
Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.
Read more...
By
Additional Articles
2009/05/01
|
Source:
Database Journal
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
886 reads
I Need a Backup and I Need It Now
Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...
Read more...
By
Robert Davis
2009/04/29
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
Rate this
|
Briefcase
|
2,360 reads
What's my (fully qualified domain) name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring automation scripts in powershell was that there is no simple way to get the SQL Server's fully qualified domain name. I didn't want to...
Read more...
By
Robert Davis
2009/04/16
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,470 reads
Monitoring SQL Server Agent with Powershell
This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.
Read more...
By
Additional Articles
2009/03/31
|
Source:
SQLTeam.com
|
Category:
SQL Agent
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,688 reads
Introduction to Windows PowerShell for the SQL Server DBA Part 2
To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.
Read more...
By
Additional Articles
2009/03/23
|
Source:
MSSQLTips.com
|
Category:
powershell
Rating:
Rate this
|
Briefcase
|
2,827 reads
Process Dimensions in an Analysis Service database
Continuing our series on our "Microsoft Windows PowerShell and SQL Server 2008 AMO," Part 8 covers how to process a dimension in an Analysis Service database using Windows PowerShell and SQL Server 2008 AMO.
Read more...
By
Additional Articles
2009/03/11
|
Source:
Database Journal
|
Category:
Analysis Services (SSAS)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,022 reads
Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.
Read more...
By
Additional Articles
2009/02/24
|
Source:
Database Journal
|
Category:
powershell
Rating:
(not yet rated)
Rate this
|
Briefcase
|
803 reads
Introduction to Windows PowerShell for the SQL Server DBA Part 1
I have been hearing about Microsoft's scripting language called Windows PowerShell which is extensively used nowdays for administering and managing Windows servers and workstations. Exchange Server 2007 and Windows Server 2008 are just two of the Microsoft server products that have included this as part of their administrative tools. I want to know how Windows PowerShell can help me as a SQL Server DBA.
Read more...
By
Additional Articles
2009/02/20
|
Source:
MSSQLTips.com
|
Category:
powershell
Rating:
Rate this
|
Briefcase
|
3,987 reads
Get SSAS Database Properties with PowerShell and AMO
Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.
Read more...
By
Additional Articles
2009/01/05
|
Source:
Database Journal
|
Category:
AMO
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,029 reads
Items 1 to 20 of 43
Next 20 >>
Most popular
Database Space Capacity Planning
Describes a process to create a consolidated space forecasting report, which focuses on a "days remaining" metric.
Read more...
By
Chad Miller
2009/10/13
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
5,622 reads
Backup Monitoring and Reporting
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.
Read more...
By
Chad Miller
2009/06/04
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
|
Discuss
|
Briefcase
|
8,071 reads
Loading Data With Powershell
Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.
Read more...
By
Chad Miller
2008/12/16
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
8,689 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use