Browse Blog Posts by Tags

All Tags » PowerShell (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Add Access record

We’ve seen how to create a database and a table. Now we need to know how to add a record to that table. 001 002 003 004 005 006 007 008 function Add-AccessRecord { param ( [string] $sql , [System.Data.OleDb.OleDbConnection] $connection ) ...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 23 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010
Adding a Table to an Access database

After reviewing the function I produced in the last post I realised i had made it over complicated. I’m working with Office 2010 and 2007 predominantly so I should have the 2007 format as my default. If I do that and change the switch parameter so it is used to create an Access 2003...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 23 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010
Creating an Access database

I’ve blogged a bit about using SQL Server with PowerShell, and using Word and Excel through PowerShell. I realised that I hadn’t seen much about using Access. Access is part of the Office suite and is present on many desktops. It forms a handy data store for using with PowerShell. In this series...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Nov 22 2009
Filed under: Filed under: Powershell, PowerShell V2, Office 2010
Excel 2010 beta

The beta still allows those of us that aren’t in the USA to use the simple method of creating a new spreadsheet using PowerShell. 001 002 003 $xl = New-Object -comobject "excel.application" $xl . visible = $true $xlbooks = $xl ...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Nov 19 2009
Filed under: Filed under: Powershell, Office 2010
Reminders via WPF

If I am working on my home machine I don’t necessarily have Outlook or any other application that gives me calendaring capability open. There are times when I need a simple reminder to do something. For some reason I always seem to have PowerShell open so I thought of using the eventing system to give...

Posted to Richard Siddaway's Blog by RichardSiddaway on Wed, Nov 18 2009
Filed under: Filed under: Powershell, PowerShell V2
Сравнения списка объектов SQL Server в Powershell на примере сравнения логинов на двух серверах

В данном примере я покажу как с помощью Powershell можно сравнивать списки объектов на двух серверах на примере сравнения логинов: поиск одинаковых, поиск разницы. Для этого сначала выполним подключение к серверам. В данном примере первый сервер - локальный. К нему будем подключаться с использованием...

Posted to Alexander Gladchenko by gladchenko on Wed, Nov 18 2009
Filed under: Filed under: SQL Server, PowerShell, Tips for DBA
Сравнения списка объектов SQL Server в PowerShell на примере сравнения логинов на двух серверах

В данном примере я покажу как с помощью PowerShell можно сравнивать списки объектов на двух серверах на примере сравнения логинов: поиск одинаковых, поиск разницы. Для этого сначала выполним подключение к серверам. В данном примере первый сервер - локальный. К нему будем подключаться с использованием...

Posted to Irina Naumova by Ирина Наумова on Wed, Nov 18 2009
Filed under: Filed under: SQL Server, PowerShell
WMI CookBook: WMI Presentation

As with other PowerShell objects there is a default format for the display of WMI objetcs. If we look at the NetworkAdapter class PS> Get-WmiObject -Class Win32_NetworkAdapter -Filter "DeviceId='11'" ServiceName : athr MACAddress ...

Posted to Richard Siddaway's Blog by RichardSiddaway on Tue, Nov 17 2009
Filed under: Filed under: Powershell, PowerShell and WMI
Patch Tuesday

Patch Tuesday – the second Tuesday in the month – is the day Microsoft (and other vendors) release their patches. If you want to be able to plan ahead for these dates ( like arranging holiday or sick leave ) these two functions will supply the dates to look out for. 001 002 003 004 005 006 007 008 009...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sat, Nov 14 2009
Filed under: Filed under: Powershell
Scheduled Tasks

Keeping on the theme of Scheduled Tasks I wanted to dig into the tasks that exist on my system. I did a fresh install of Windows 7 in August and haven’t created any scheduled tasks – so what I see should be close to the system defaults. This machine isn’t in a domain. I can load the task...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Nov 13 2009
Filed under: Filed under: Powershell, PowerShell V2, Windows 7
Cleaning the Temp folder - Scheduling

When I posted about cleaning the temp folder http://msmvps.com/blogs/richardsiddaway/archive/2009/11/04/cleaning-temp-folder.aspx I said I would look at scheduling the task. I had intended to use the TaskScheduler module in the new PowerShell pack which can be downloaded from http://code.msdn.microsoft...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Nov 12 2009
Filed under: Filed under: Powershell, PowerShell V2
Extension for temporary files

When I did the post on creating temporary files http://msmvps.com/blogs/richardsiddaway/archive/2009/11/05/creating-temporary-files.aspx I said I’d modify it so the file would be created with a given extension. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023...

Posted to Richard Siddaway's Blog by RichardSiddaway on Wed, Nov 11 2009
Filed under: Filed under: Powershell, PowerShell V2, Modules
Finding the Microsoft File Transfer Manager

This is really just a reminder blog post for me. Way too often I find that I have closed the Microsoft File Transfer Manager for one reason or another, and I want to start it up again to resume some download from my MSDN Subscription. Like today, I need to grab the latest version of SQL Server 2008 R2...

Posted to Rob Farley by Rob Farley on Tue, Nov 10 2009
Filed under: Filed under: powershell, windows
Management Shell Quick Reference for Exchange 2010

A great document that should be used a lot: Exchange Management Shell Quick Reference for Exchange 2010 . Brief Description This download contains a quick reference sheet that can be used to access frequently used Exchange Management Shell cmdlets and syntax in Microsoft Exchange Server 2010. Overview...

Posted to subject: exchange by Rui Silva on Tue, Nov 10 2009
Filed under: Filed under: Cool reading, PowerShell
Getting Change Events

I wasn’t particularly happy with the script for getting change events on the filesystemwatcher we discussed last time. As a quick recap we ended up with this 001 002 003 004 Get-Event -SourceIdentifier "File System Changed" | where { ( $_ . EventIdentifier...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 9 2009
Filed under: Filed under: Powershell, PowerShell V2
Watching the file system

We saw how to watch for WMI events http://msmvps.com/blogs/richardsiddaway/archive/2009/11/07/powershell-wmi-events.aspx . In this post we will look at watching the file system. This time we will use the .NET System.IO.FileSystemWatcher object which means we use Register-ObjectEvent instead of Register...

Posted to Richard Siddaway's Blog by RichardSiddaway on Mon, Nov 9 2009
Filed under: Filed under: Powershell, PowerShell V2
Multiple test files

Back here http://msmvps.com/blogs/richardsiddaway/archive/2009/11/05/creating-temporary-files.aspx or http://richardsiddaway.spaces.live.com/blog/cns!43CFA46A74CF3E96!2595.entry I showed how to create temporary test files. We can simply create multiple test files like this 1..10 | foreach {new-tempfile...

Posted to Richard Siddaway's Blog by RichardSiddaway on Sun, Nov 8 2009
Filed under: Filed under: Powershell, PowerShell V2
Removing empty folders

I blogged about this a long time back. As part of my tidy up program (me? tidy up? - - stop laughing!) I’ve been moving scripts into PowerShell v2 modules. I’ve added these three functions to my FileFunctions module. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020...

Posted to Richard Siddaway's Blog by RichardSiddaway on Fri, Nov 6 2009
Filed under: Filed under: Powershell
Creating Temporary files

One thing I need to do when testing file system scripts is generate a bunch of temporary files for experimenting with. In the past I have just copied in whatever I could find to use as test data. It is possible to easily generate test data of this sort using the New-TempFile function below...

Posted to Richard Siddaway's Blog by RichardSiddaway on Thu, Nov 5 2009
Filed under: Filed under: Powershell
Cleaning Temp folder

Windows uses a temporary folder as a scratch pad and dumping ground for all sorts of temporary files. There are a couple of issues with the temporary folder. Firstly by default its part your profile and each user has their own. Secondly there isn’t any real clean up performed on it. The first issue...

Posted to Richard Siddaway's Blog by RichardSiddaway on Wed, Nov 4 2009
Filed under: Filed under: Powershell

Page 1 of 14 (276 items) 1 2 3 4 5 Next > ... Last »

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags