|
|
April 2008 - Posts
-
-
About RunAs Radio RunAs Radio is a weekly Internet Audio Talk Show for IT Professionals working with Microsoft products. The full range of IT topics is covered from a Microsoft-centric viewpoint. RunAs Radio was launched on April 11, 2007 with a nod from its sister show, .NET Rocks!, which started as a weekly downloadable mp3 in August, 2002! Coincidentally, the first RunAs Radio show featured Patrick Hynds, who was also the first guest on .NET Rocks! Richard Campbell, the third co-host of .NET Rocks!, hosts RunAs Radio along with Greg Hughes. Each show promises to be about 30 minutes long and focused on a single topic. A full range of audio formats and feed options are offered. Rory McCaw on MOM 2007 Rory McCaw talks with Richard and Greg around Microsoft Operations Manager 2007.
http://www.runasradio.com/default.aspx?showNum=7 Mitch Garvis Gets Us Using Microsoft Business Desktop Deployment! Mitch Garvis talks to Richard and Greg about Microsoft Business Desktop Deployment (BDD). BDD is the evolution of earlier versions, along side products like SMS, Vista and Office to do zero touch and light touch deployments of operating systems and applications.
http://www.runasradio.com/default.aspx?showNum=26 Jeff Sigman Gives Us Network Access Protection! The final installment of interviews from Microsoft Tech Ed US 2007 in Orlando, Richard and Greg talk to Jeff Sigman, the Release Manager for Network Access Protection (NAP). Jeff digs into exactly what NAP is all about, how it interact with Windows Server 2008, Vista and Windows XP http://www.runasradio.com/default.aspx?showNum=13 Stephen Rose on the State of Server Virtualization Richard and Greg chat with Stephen Rose about Server Virtualization, including Microsoft's Virtual Server and VMWare's products. Stephen digs into the advantages (and disadvantages) of server virtualization, talks about migrating existing servers and getting the maximum use out of your hardware http://www.runasradio.com/default.aspx?showNum=17 Joel Frauenheim and Martin Booth on the Windows System Center Mobile Device Manager! While at Tech Ed Europe IT Forum in Barcelona, Richard and Greg talked to Joel Frauenheim and Martin Booth about Microsoft's new Windows System Center Mobile Device Manager http://www.runasradio.com/default.aspx?showNum=39 Bob Roudebush on Disaster Recovery for Virtualization! Bob Roudebush talks to us about how disaster recovery works when Microsoft Virtual Server and/or VMWare is involved. We dig into the details around backing up within the guest VM and via the host.
http://www.runasradio.com/default.aspx?showNum=19 
|
-
Richard and Greg talk to Garth Jones about SMS 2003 and its new version, System Center Configuration Manager 2007. Configuration Manager takes over where SMS left off, handling software distribution, updates, asset management, even working with Windows Deployment Services to do bare metal installations! http://www.runasradio.com/default.aspx?ShowNum=54
|
-
I have been so busy that I haven't had time to do things like read blog post. However very late today I was cleaning up my Inbox before heading to MMS on Sunday morning. While up my inbox I found this Blog post from Todd. http://todds.typepad.com/posts/2008/04/garth-jones-fea.html The funny thing is that I forgot that I did this! It was back in March! 
|
-
-
While at the MVP summit I tracked down all 4 hockey pucks... I know that a few other MVPs did too. Did you get any pucks? 
and the hardest one to track down was! 
|
-
I received this note from MS Canada, asking me to help promote this, my only questions are: Want to achieve the Microsoft Small Business Specialist (SBSC) Designation, Take the first step, Register Today! http://www.nexientlearning.com/SBS70-631 Overview: Nexient is offering a unique format for the delivery of 5060 – Implementing Microsoft Windows SharePoint Services 3.0. We heard your feedback and Nexient has condensed the course from 2 days in the classroom to being offered as 2 evening sessions. These sessions will help participants gain the level of competency to write exam 70-631 “Configuring Windows® SharePoint® Services 3.0.” This program includes: - Microsoft Official Curriculum for course 5060 – Implementing Microsoft Windows SharePoint Services 3.0
- MeasureUp test preparation for Microsoft exam 70-631
- Follow up Exam Preparation Live Meeting session with live instructor
- **Exam voucher included for the 70-631 exam (valid until June 30, 2008)
Microsoft has arranged for you to receive the training for only $349.00 CAD. + Applicable taxes (That’s savings for you of over $850.00 CDN.) Act Today! ONLY 12 spots per city About the Training: In this condensed course, the instructor will review the following subject areas: - How the Windows SharePoint Services 3.0-based platform helps address collaboration challenges
- Planning the Windows SharePoint Services 3.0-based Environment
- Installing Windows SharePoint Services 3.0
- Identifying the most appropriate method to upgrade Windows SharePoint Services from 2.0 to 3.0 in a given scenario
- Managing Windows SharePoint Services 3.0
This course is meant to help prepare students for exam 70-631 by performing a review of topics that will be covered on the exam. This course is not intended as complete training to pass the exam, rather it is a review or culmination of experiences that refine the student’s knowledge as final preparation for the exam. When & Where: Vancouver – May 6 & 8, 2008 Calgary – May 6 & 8, 2008 Montreal – May 6 & 8, 2008 Mississauga – May 6 & 8, 2008 Toronto – May 6 & 8, 2008 NOTE: Evening sessions will be conducted from 6:30 – 9:30 p.m. on Tuesdays and Thursdays in the same week. Who should attend: The audience is expected to have at least two years of experience in implementing, managing, and supporting Microsoft Windows Server 2003, including Internet Information Services (IIS). Registration: Register today with Nexient for only $349.00 CAD + applicable taxes http://www.nexientlearning.com/SBS70-631 
|
-
SQL Server 2008 Certification
In this 45 minute live meeting with the certification planners, we will introduce the certifications available to help you show off your skills on SQL Server 2008 Business Intelligence, Database Development, and Database Administration – to help you stand out with employers looking to make the most of their SQL Server 2008 investment. We will walk through the exam roadmaps so you understand your path to certification, and provide pointers to the training and resources that will help you pass your exams and certify on SQL Server 2008. We will also explain the upgrade paths from SQL Server 2005 certification. This meeting will be offered twice to accommodate worldwide calendars, to register for: 
|
-
System Center and Virtualization Certifications
In this 45 minute live meeting with the certification planners, we will introduce the certifications available to help you show off your skills on System Center—and introduce our plans for certification supporting your virtualization skill set. We will walk through the exam roadmaps so you understand your path to certification, and provide pointers to the training and resources that will help you pass your exams and certify on System Center technologies and the latest in virtualization from Microsoft. This meeting will be offered twice to accommodate worldwide calendars, to register for: 
|
-
I tracked this down for someone else and though this would interest may of you. Performance Considerations Typically, performance is better if the Configuration Manager 2007 site server and the site database are installed on the same computer. However, if the intervening network connection is a high-availability, high-bandwidth network connection you might be able to install SQL Server on a remote server from the Configuration Manager 2007 site server. You might also consider installing a second network adapter in both the site server and the computer running SQL Server and then dedicating this second card for communications between the site server and the computer running SQL Server. http://technet.microsoft.com/en-ca/library/bb632649.aspx 
|
-
-
Did you know that? - More than a thousand of your colleagues throughout Ottawa and the surrounding area belong to one or more of the Local IT Pro Groups listed below!
- All Ottawa IT Pro Groups are not-for-profit organizations that focus on all aspects of technology from software to hardware.
- Each IT Pro group is a group of peers, who meet on a monthly basis to learn and discuss new and existing technologies with industry leaders.
Why should YOU join IT Pro group? - We are committed to bringing you seminars and lessons on topics of interest that our members request;
- We offer special programs such as study groups and more to come;
- By helping our efforts you will be making a difference in the community; and
- It’s absolutely free so WHY NOT!?
- The Ottawa Windows Server User Group holds monthly meeting on various topics and has an associated study group
- To find out more visit www.owsug.ca or contact info@owsug.ca.
- OttawaSQL.net is a group of Ottawa area IT professionals that share an interest in exploring the data perspective of Microsoft business solutions, products and technologies.
- The technical focus of the group is on Microsoft SQL Server but also includes: SharePoint Server, Performance Point Server, Windows Workflow Foundations, LINQ and ADO.NET and more!
- To find out more visit www.OttawaSQL.net .
- We are a community of developers in Canada’s Ottawa/Gatineau region with a keen interest in Microsoft's .NET development platform.
- To find out more visit www.ottawacommunity.net .
Up Coming Events: April 22nd, 2008 (Lunchtime) ODNC Lunch & Learn: Effective N-Layering in ASP.NET This presentation will focus on tools and techniques associated with the rapid development of ASP.NET applications. It will begin by introducing the concept of N-Layering as explained by Martin Fowler in his book “Patterns of Enterprise Application Architecture”. It will then demonstrate the creation of an N-Layered ASP.Net application with specific focus on 3 real-world scenarios; 1) ASP to ASP.NET migration where the client does not want the back end (Database) to change 2) ASP.NET Spaghetti Code refactoring using the existing stored procedures 3) ASP.NET's effective use of the ObjectDataSource or LINQ with the Microsoft Entity Framework You can register for this event by sending an email to events@OttawaCommunity.Net. April 24th, 2008 OttawaSQL.net and ODNC Present
Topic 1: “Business Intelligence Foundations with SQL Server
Integration Services” Presented by Christian Cote
Topic 2: "Architecting an ETL Framework with SQL Server Integration
Services" Presented by Christian Cote
You can register for this event by sending an email to events@OttawaCommunity.Net. May 29th, 2008 OttawaSQL.net and OWSUG Present
Topic 1: "SQL Server 2008 & Windows Server 2008 High Availability
Technologies" Presented by David E. Myers and Todd Lamothe
Topic 2: "SQL Server 2008 Spatial Data & Microsoft Virtual Earth"
Presented by Lynda Rab and Steve Syfuhs For more information, please contact info@owsug.ca . 
|
-
select
ENV.VariableValue0 AS 'Val'
, ENV.ResourceID as 'ResourceID'
into #Var
from
v_GS_ENVIRONMENT ENV
where
ENV.Name0 = 'QTJava' select distinct
CS.Name0 AS 'Computer Name'
, CS.UserName0 AS 'Last Logged on User'
, CS.Domain0 AS 'Domain'
, OS.Caption0 AS 'Operating System'
, OS.csdversion0 AS 'Service Pack Level'
, BIOS.serialnumber0 AS 'Serial Number'
, CS.manufacturer0 AS 'Manufacturer'
, CS.model0 AS 'Model'
, RAM.totalphysicalmemory0 AS 'Memory (KBytes)'
, CPU.maxclockspeed0 AS 'Processor (GHz)'
, HD.size0 AS 'Disk Space (MB)'
, HD.FreeSpace0 AS 'Free Disk Space (MB)'
, #var.Val AS 'Image Version'
from
v_GS_Computer_System CS
inner join v_GS_Operating_system OS on (OS.resourceid = CS.ResourceID)
inner join v_gs_PC_bios BIOS on (BIOS.resourceid = CS.ResourceID)
inner join v_gs_system_enclosure on (v_gs_system_enclosure.resourceid = CS.ResourceID)
inner join v_GS_x86_PC_memory RAM on (RAM.resourceid = CS.ResourceID)
inner join v_GS_processor CPU on (CPU.resourceid = CS.ResourceID)
inner join v_GS_LOGICAL_DISK HD on (HD.resourceid = CS.ResourceID)
left outer join #var on (#var.resourceid = CS.ResourceID)
where
HD.deviceID0 = 'C:'
Order by
CS.Name0 Drop table #var 
|
-
SELECT distinct
CS.name0 as 'Computer Name',
CS.domain0 as 'Domain',
CS.UserName0 as 'User',
BIOS.SerialNumber0 as 'Bios serial',
SE.SerialNumber0 as 'System Enclosure serial',
CS.Manufacturer0 as 'Manufacturer',
CS.Model0 as 'model',
OS.Caption0 as 'OS',
RAA.SMS_Assigned_Sites0 as 'Site',
RAM.TotalPhysicalMemory0 as 'Total Memory',
sum(isnull(LDisk.Size0,'0')) as 'Hardrive Size',
sum(isnull(LDisk.FreeSpace0,'0')) AS 'Free Space',
CPU.CurrentClockSpeed0 as 'CPU Speed',
FCM.SiteCode,
OPSYS.Caption0,
OPSYS.Version0,
OPSYS.CSDVersion0,
OPSYS.InstallDate0,
OPSYS.LastBootUpTime0,
OPSYS.WindowsDirectory0,
OPSYS.Description0
from
v_GS_COMPUTER_SYSTEM CS right join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID
right join v_GS_SYSTEM SYS on SYS.ResourceID = CS.ResourceID
right join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID
right join v_RA_System_SMSAssignedSites RAA on RAA.ResourceID = CS.ResourceID
right join V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceID
right join v_GS_Logical_Disk LDisk on LDisk.ResourceID = CS.ResourceID
right join v_GS_Processor CPU on CPU.ResourceID = CS.ResourceID
right join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID
right JOIN v_GS_OPERATING_SYSTEM OPSYS on OPSYS.ResourceID = CS.ResourceID
right JOIN v_FullCollectionMembership FCM on FCM.ResourceID = CS.ResourceID
where
LDisk.DriveType0 =3
and SYS.SystemRole0 = 'Server'
group by
CS.Name0,
CS.domain0,
CS.Username0,
BIOS.SerialNumber0,
SE.SerialNumber0,
CS.Manufacturer0,
CS.Model0,
OS.Caption0,
RAA.SMS_Assigned_Sites0,
RAM.TotalPhysicalMemory0,
CPU.CurrentClockSpeed0,
FCM.SiteCode,
OPSYS.Caption0,
OPSYS.Version0,
OPSYS.CSDVersion0,
OPSYS.InstallDate0,
OPSYS.LastBootUpTime0,
OPSYS.WindowsDirectory0,
OPSYS.Description0 
|
-
select distinct
CS.Name0 AS 'Computer Name'
, CS.UserName0 AS 'Last Logged on User'
, CS.Domain0 AS 'Domain'
, OS.Caption0 AS 'Operating System'
, OS.csdversion0 AS 'Service Pack Level'
, BIOS.serialnumber0 AS 'Serial Number'
, CS.manufacturer0 AS 'Manufacturer'
, CS.model0 AS 'Model'
, RAM.totalphysicalmemory0 AS 'Memory (KBytes)'
, CPU.maxclockspeed0 AS 'Processor (GHz)'
, HD.size0 AS 'Disk Space (MB)'
, HD.FreeSpace0 AS 'Free Disk Space (MB)'
, ENV.Name0 AS 'Image Version'
from
v_GS_Computer_System CS
inner join v_GS_Operating_system OS on (OS.resourceid = CS.ResourceID)
inner join v_gs_PC_bios BIOS on (BIOS.resourceid = CS.ResourceID)
inner join v_gs_system_enclosure on (v_gs_system_enclosure.resourceid = CS.ResourceID)
inner join v_GS_x86_PC_memory RAM on (RAM.resourceid = CS.ResourceID)
inner join v_GS_processor CPU on (CPU.resourceid = CS.ResourceID)
inner join v_GS_LOGICAL_DISK HD on (HD.resourceid = CS.ResourceID)
inner join v_GS_ENVIRONMENT ENV on (ENV.resourceid = CS.ResourceID)
where
HD.deviceID0 = 'C:'
and ENV.Name0 = 'Version'
Order by
CS.Name0 
|
-
-
SELECT E.Name0, E.UserName0, E.VariableValue0
FROM dbo.v_GS_ENVIRONMENT E
WHERE (E.Name0='TMP')
ORDER BY E.Name0 
|
-
WMRCplus have been update to handle Windows Server 2008. VMRCplus is a tool for both configuration management of Virtual Server and remote control of virtual machines. It allows for local and remote management of Virtual Server and supports simultaneous management of up to 32 Virtual Server hosts.
Remote control sessions of virtual machines are grouped in a single window using Tab pages. The interface enables sorting virtual machines based on various properties like name, status and description. Multi-select of virtual machines enable you to perform actions to change their status or open remote control sessions all at once.
http://www.microsoft.com/downloads/details.aspx?FamilyID=80adc08c-bfc6-4c3a-b4f1-772f550ae791&displaylang=en 
|
-
-
AB 16
BC 30
MB 13
NB 7
NL 2
NS 4
ON 75
QC 28
SK 4 
|
|
|
|