Dalle & DXter

PowerShell + msSQL – Last backup date

By Fredrik Wall

A simple PowerShell script to get some basic information from msSQL.
Last Backup Date and Status

$myserver = "localhost"
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
$Server = new-object ("Microsoft.SqlServer.Management.Smo.Server") $myserver
$server.Databases | Select-Object @{Name = ‘Server’;Expression = {$myserver}}, name, lastbackupdate, status

Output:

Server          : localhost
Name           : mydb01
LastBackupDate : 5/14/2009 12:20:15 AM
Status         : Offline, AutoClosed

Server         : localhost
Name           : mydb02
LastBackupDate : 5/14/2009 12:18:56 AM
Status         : Normal

Server      : localhost
Name           : mydb03
LastBackupDate : 1/1/0001 12:00:00 AM
Status         : Normal

And if we want to just show the database that didn’t backup in the
last 2 days we just use Where-Object 

$myserver = "localhost"
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
$Server = new-object ("Microsoft.SqlServer.Management.Smo.Server") $myserver
$server.Databases | Where-Object -filter {$_.LastBackupDate -lt (get-date).AddDays(-2)} | Select-Object name, lastbackupdate

Output:

Name           : mydb03
LastBackupDate : 1/1/0001 12:00:00 AM

Being Smart at Windows Deployment

By Fredrik Wall

This video are from Tech Ed US.

Do you feel like you’re reinventing the wheel
every time you’re doing a deployment?

With Microsoft’s Deployment Solution Accelerator
you don’t need to. Hear Johan Arwidmark share
his advice and expertise on how to be smart in
your future deployments.

 

If you like this video and likes deployment.
Then take a look at http://www.deploymentcd.com

A free deployment CD from Johan Arwidmark with
documents, tips and trix.

 

BranchCache Early Adopter’s Guide

By Fredrik Wall

Introduces BranchCache, a new feature in Windows 7
and Windows Server 2008 R2 that reduces WAN link utilization
and improves application responsiveness.

Download it here.

 

Windows SharePoint Services 3.0

By Fredrik Wall

Windows SharePoint Services 3.0 Technical Library in Compiled Help format

Downloadable CHM version of Windows SharePoint Services 3.0 content on TechNet.

Pretty nice to have all the good information in a Help file.
Little bit easier to access it and search it.

 

You can download It here.

A tip!
If you download it and start it you may not see any information at all.
So before you start the help file you need to right click it, properties and then click Unblock.

 

Windows Vista Application Compatibility List for IT Professionals

By Fredrik Wall

Brief Description

The Window Vista Application Compatibility List for IT Professionals is a
Microsoft Office Excel-based spreadsheet containing software applications
which have support statements from the application manufacturer or which
have earned the status of “Certified for Windows Vista” or
“Works with Windows Vista”.

Download it here.

 

The focus on the blog

By Fredrik Wall

Hi,

I got the question about the focus on this blog earlier today.

The focus today is Windows News, Windows Technology
and Windows PowerShell.

In about a week or so the focus will be more on PowerShell,
Windows Administration and news.

And I’m on my way to do some more changes in my life.
In a month I will change company and then work as
a consultant again.

 

Before and after Fences

By Fredrik Wall

Fences have a function when you start it for the first time, that helps you organize
your desktop in 5 sec.

Before:

After:

 

Read more about Fences in my first post about Fences.

The Office 2010 team blog

By Fredrik Wall

The Microsoft Office 2010 team have started a blog.
Take a look at it,
http://blogs.technet.com/office2010/default.aspx.

 

Fences

By Fredrik Wall

I came across this cool desktop application yesterday.
It’s called fences and will help in the spring cleaning of your desktop.

It will help you to do groups with labels.

Take a look at the picture above to se my desktop.

Or look at this post for more information.

 

This week – What to do, what to post

By Fredrik Wall

Hi,

It’s early Monday morning here in Sweden and the first day of the week.
Now It’s time to think of what to do and what to post this week.

 

• News
  Of course
• PowerShell
  
  The Scandinavian PowerShell UG
  We are working on:
  A New Site.
  2 PDF books in Swedish.
  2 meetings.
  Lots of scripts and lots of other things.
  More information later this week.
  
  Windows Server 2008 R2 AD Series
  My first post will come in about 24 hours.
  On Monday morning Swedish time.

  Windows 7
  Some time next week I will post scripts for Windows 7.

  Installation Script
  I have been reinstalling my lab computer lots of times
  the last couple of months.
  And It’s not just fun, I need all of my programs to be able to
  do my blog postings.

  So I have been working on a installation script in PowerShell.
  More about this later on.