SQLServerCentral.com Content tagged powershell, Blogs

PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers

Fri, 17 May 2013 06:00:00 UT

We came across a scenario where database bak files being created from long time which are no more in use...

Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

Wed, 24 Apr 2013 06:00:00 UT

We all know that we should document our SQL Servers, right? RIGHT? So let's say you had some time on...

PowerShell Usage in DBA Work – Case Study 7/7

Fri, 29 Mar 2013 06:00:00 UT

Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots...

PowerShell Usage in DBA Work – Case Study 6/7

Wed, 27 Mar 2013 06:00:00 UT

SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...

A Month of PowerShell – Day 27 (Scripting SQL Objects)

Mon, 11 Mar 2013 06:00:00 UT

Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Month of PowerShell – Day 25 (Integrity Checks)

Thu, 07 Mar 2013 07:00:00 UT

Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Month of PowerShell – Day 22 (Restores)

Mon, 04 Mar 2013 07:00:00 UT

Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Month of PowerShell – Day 21 (Backups)

Thu, 28 Feb 2013 07:00:00 UT

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)

Wed, 20 Feb 2013 07:00:00 UT

Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...

A Month of PowerShell – Day 10 (Navigating SMO collections)

Wed, 13 Feb 2013 07:00:00 UT

Welcome to Day 10 of my “A Month of PowerShell” series. This series will use the series landing page on...

Invitation for T-SQL Tuesday #39 – Can you shell what the PoSH is Cooking?

Fri, 08 Feb 2013 07:00:00 UT

T-SQL Tuesday Party History In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...

PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it

Wed, 29 Aug 2012 06:00:00 UT

I recently had the need to script the execution of a command-line utility and thought it would be a good...

SQL Audit 301 – Using Powershell to Manage Audits

Mon, 20 Aug 2012 06:00:00 UT

Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...

Powershell, SMO, and Add-Member - Not Always BFF

Wed, 04 Jul 2012 06:00:00 UT

Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...

PowerShell and T-SQL: Implementing UNION, INTERSECT, and EXCEPT

Mon, 16 Apr 2012 06:00:00 UT

I’ve been thoroughly enjoying my experience this year with the Scripting Games. This is the first year I've competed and...

Restore and Relocate Database Files Using PowerShell

Wed, 16 Mar 2011 06:00:00 UT

I was recently asked a question on restoring a database using PowerShell with the following requirements Take a database backup file...

Emailing tempdb Query Results to Paul Randal with PowerShell

Mon, 28 Feb 2011 07:00:00 UT

I was referred to someone on twitter today who wants to email query results without setting up database mail. I...

Importing and Exporting SSIS Packages Using PowerShell

Mon, 07 Feb 2011 07:00:00 UT

SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...

Powershell to Automate SQL Compare

Wed, 02 Feb 2011 07:00:00 UT

A question came up on the SQL Server Central Forums, how could you use Red Gate SQL Compare to automate...

Beginning Powershell Companion PDF

Thu, 06 Jan 2011 07:00:00 UT

Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...

PBM and PowerShell

Thu, 30 Dec 2010 07:00:00 UT

The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...

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

Mon, 13 Dec 2010 07:00:00 UT

For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Determining An Enterprise Execution Policy Setting

Tue, 30 Nov 2010 07:00:00 UT

Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...

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

Wed, 20 Oct 2010 06:00:00 UT

Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...

Querying Oracle from Powershell Part 1

Thu, 04 Mar 2010 07:00:00 UT

In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...

Querying Oracle from Powershell Part 2

Thu, 04 Mar 2010 07:00:00 UT

In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...

The T-SQL Hammer

Tue, 23 Feb 2010 07:00:00 UT

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...

Finding Invalid SQL Logins

Tue, 19 Jan 2010 07:00:00 UT

As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...

PowerShell 101 for the DBA: Querying Your Servers with PowerShell

Tue, 22 Sep 2009 06:00:00 UT

In my last blog post, I discussed how to get PowerShell and SQLPS up and running on your machine(s). And...

PowerShell 101 for the DBA – Installing PowerShell

Tue, 15 Sep 2009 06:00:00 UT

Many DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You...