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

Content with tags Blogs, powershell Rss

<< Newer    Items 21 to 34 of 34   
 

Powershell to Automate SQL Compare

A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...  Read more...
By Grant Fritchey 2011/02/02 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,929 reads

Beginning Powershell Companion PDF

Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...  Read more...
By Jen McCown 2011/01/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,343 reads

PBM and PowerShell

The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...  Read more...
By Chad Miller 2010/12/30 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,656 reads

What’s Going on with SQL Server Service Account Changes?

For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...  Read more...
By Chad Miller 2010/12/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,837 reads

Determining An Enterprise Execution Policy Setting

Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...  Read more...
By Chad Miller 2010/11/30 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,077 reads

Powershell is Really Easy… If you know what you’re doing

Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...  Read more...
By Grant Fritchey 2010/10/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,356 reads

Querying Oracle from Powershell Part 1

In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...  Read more...
By Chad Miller 2010/03/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,169 reads

Querying Oracle from Powershell Part 2

In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...  Read more...
By Chad Miller 2010/03/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,829 reads

The T-SQL Hammer

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...  Read more...
By Chad Miller 2010/02/23 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 3,278 reads

Finding Invalid SQL Logins

As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...  Read more...
By Chad Miller 2010/01/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,128 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,792 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,969 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 / restore
Rating:  Rate this |   Briefcase | 3,705 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 | 3,319 reads
<< Newer    Items 21 to 34 of 34   
 
Tags
oracle (2)    
administration (1)    
auditing (1)    
azure (1)    
backup / recovery (1)    
backup / restore (1)    
dba (1)    
error log (1)    
permissions (1)    
restore (1)    
security (1)    
smo (1)    
sql compare (1)