|
|
September 2008 - Posts
-
Use this query to find all PCs that don't have any data within the v_GS_* views. Right John... :-) select
R.Netbios_Name0,
R.*
from
v_R_System r
where
R.ResourceID not in (select
cs.resourceId
from
v_gs_computer_system cs)
Order by
R.Netbios_Name0 
|
-
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
| Buy your ticket to our first Tech·Days training event in your city | |
| |
| | Tech·Days: The rich learning experience of Tech·Ed, without the travel.
You've probably heard of Tech·Ed, the annual technology education and networking conference on Microsoft-based technologies. Perhaps you've even attended.
Now, we're happy to help save you the time and expense of travel by bringing the Tech·Ed experience to your city with Tech·Days 2008. Check out the sessions.
With Birds-of-a-Feather lunches, and a customizable schedule from up to forty 200+ level sessions, you can connect with Microsoft experts, consultants and your peers while strengthening highly specific skills such as: - planning for Server Virtualization;
- applying Workload Resource Governance on SQL Server® 2008;
- building rich Internet applications using the Silverlight™-based platform; and a lot more.
PLUS, put your knowledge to work after the event with a FREE Tech·Days Learning Kit—with an approximate value of $1,000, plus bonus offers!
» BUY A TICKET TO THE EVENT IN YOUR CITY NOW. | | | | | |
| | 
| | Save up to $250 when you register before October 15, 2008.
Don't miss out | | 
| |
| |
| | All attendees will receive a Tech·Days Learning Kit with an approximate value of | $1,000, | PLUS BONUS OFFERS |
 | |
| | » LEARN MORE ABOUT THE KIT | |
| |
| |
| | Who should attend: | | • | Software Developers | | • | Web Developers | | • | IT Professionals | | • | Consultants | | • | Project Managers | | • | Testers | | • | IT Generalists | | • | Network Infrastructure Specialists | | | | Highlighted technologies: | | • | Virtualization and Windows Server® 2008 | | • | Microsoft® SQL Server® 2008 | | • | Microsoft® System Center Virtual Machine Manager | | • | Microsoft® Visual Studio® 2008 | | • | Microsoft® BizTalk® 2008 | | |
| | |
| |
| |
| 
|
-
This weeks reading for the self study group is: | 15.2 Configuring and Using Directory Certificate Services | 28 | 55 | | 16.1 Understanding and Installing Active Directory Rights | 27 | | 
|
-
What is CRL? 
|
-
SELECT
CS.Name0,
CS.UserName0,
BIOS.Manufacturer0,
BIOS.SerialNumber0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_PC_BIOS BIOS
WHERE
CS.ResourceID = BIOS.ResourceID
AND BIOS.SerialNumber0=<Enter Serial Number here> 
|
-
What versions of Windows 2008 can be used to publish PKI certs to AD? - Windows 2008 Web
- Windows 2008 Web Core
- Windows 2008 Standard
- Windows 2008 Standard Core
- Windows 2008 Enterprise
- Windows 2008 Enterprise Core
- Windows 2008 Datacenter
- Windows 2008 Datacenter Core
Answer - Windows 2008 Enterprise
- Windows 2008 Datacenter
|
-
SELECT
ARP.DisplayName0,
ARP.ProdID0,
ARP.Publisher0,
ARP.Version0,
Count(ARP.ProdID0) AS 'Count'
FROM
dbo.v_Add_Remove_Programs ARP
GROUP BY
ARP.DisplayName0,
ARP.ProdID0,
ARP.Publisher0,
ARP.Version0
ORDER BY
ARP.DisplayName0 
|
-
-
You can fake maintenance windows in SMS 2003 by setting the reoccurrence option and the advert expiry options. understand, this will NOT stop an advert from going over its allot time! 
|
-
SELECT
CS.Name0,
CS.UserName0,
ISW.ProductName0,
ISW.VersionMajor0,
ISW.VersionMinor0,
ISW.Publisher0,
ISW.RegisteredUser0,
ISW.InstallDate0,
ISW.InstallSource0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_INSTALLED_SOFTWARE ISW
WHERE
ISW.ResourceID = CS.ResourceID
ORDER BY
ISW.InstallDate0 DESC,
CS.Name0,
CS.UserName0,
ISW.ProductName0 
|
-
select distinct
SMS_R_System.Name,
SMS_G_System_LOGICAL_DISK.*
from
SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId
where
SMS_G_System_LOGICAL_DISK.FreeSpace > 2048
and SMS_G_System_LOGICAL_DISK.DeviceID = "C:"
order by
SMS_R_System.Name 
|
-
SELECT
CS.Name0,
HNAC.TimeStamp,
HNAC.DefaultIPGateway0,
HNAC.DHCPServer0,
HNAC.DNSDomain0,
HNAC.DNSHostName0,
HNAC.IPAddress0,
HNAC.IPSubnet0,
HNAC.MACAddress0,
HNAC.ServiceName0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_HS_NETWORK_ADAPTER_CONFIGUR HNAC
WHERE
HNAC.ResourceID = CS.ResourceID
and HNAC.DHCPEnabled0 = 1
and HNAC.IPAddress0 != 'NULL'
and HNAC.IPAddress0 != '0.0.0.0'
Order by
CS.Name0,
HNAC.TimeStamp 
|
-
Well, this morning I passed this exam 70-652 and this put me one step closer to becoming a "Microsoft Certified Non-Professional in AOS: Server Virtualization"! I hope they change the title of that certification! Well I have set a personal target of passing 15 exams by Dec 10th 2008, that date will be 1 year from when I started to updating my certifications to Win2k3 and Win2k8. So with one more to go to meet that target now the question is which exam of my remaining exams should I write? 70-400, 646, 647, I’m toying with 70-656 exam too, 402 (if released), and 403 (when). I am leaning towards 70-400 or 70-646. Why 70-400 because I need to update my lab from MOM 2k5 to OpsMgr 2k7, this is a good excuse to do so. Why 70-646 because I already have the MS press book and I have started to read it a bit. So what do you think? And yes the 15 exam goal was not the original goal, the goals were: - ConfigMgr Exam and the TS: Windows Vista, Configuring exam (70-401 & 70-620)
- Add the Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support Technicians (70-622) to get MCITP: Enterprise Support Technician which allowed me to get my MCT
- But then I need to upgrade to MCSE so that I could teach the one class I wanted to teach Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 (6451A aka 70-401 exam) (70-290, 291, 293, 294 and 298) I got my MCSA Win2k3 at this point.
- Before completing Goal 3, I was asked to pass TS: Deploying and Maintaining Windows Vista Client and 2007 Microsoft Office System Desktops (70-624) for some contract work so I put 624 before 298
- Back to Goal 3 (70-298) and my MCSE for Win2k3
- After goal 3 was done it make seen to work on TS: Upgrading Your MCSE on Windows Server 2003 to Windows Server 2008, Technology Specialist (70-649)
- Since I bought a new server (new to me that is, I’m not that rich) I decide to do the TS: Windows Server Virtualization, Configuring (70-652) next
- Should it be 70-400, 70-646 or other and why?
|
-
Take Microsoft E-Learning Collection 6333: Exploring Microsoft Virtualization Technologies for free! Collection 6333 includes the following: 
|
-
lol sure I wouldn't mind becoming a How would you like to become a Microsoft Certified Non-Professional in AOS: Server Virtualization! 
|
-
This weeks reading for the self study group is: | 14.2 Configruing and Using AD LDS | 22 | 52 | | 15.1 Understanding and Installing Active Directory Certificate Services | 30 | | 
|
-
What versions of Windows 2008 can be used to publish PKI certs to AD? - Windows 2008 Web
- Windows 2008 Web Core
- Windows 2008 Standard
- Windows 2008 Standard Core
- Windows 2008 Enterprise
- Windows 2008 Enterprise Core
- Windows 2008 Datacenter
- Windows 2008 Datacenter Core
|
-
Name the 5 Authentication Methods for IIS. Answer: - Anonymous
- Integrated
- Digest
- Basic
- .NET passport
|
-
Name the 5 Authentication Methods for IIS. 
|
-
In additional to traditional system backups what other items should be included for IIS? Answer: - Backup web pages
- Backup any databases
- Backup metabase
|
-
When does WSRM polices kicks in? Answer: 70% of CPU utilization is when WSRM kicks in. 
|
-
In additional to traditional system backups what other items should be included for IIS? 
|
-
Where is the GPO policy for Wireless networks located? Answer: The GPO policy for Wireless networks is located under Computer Configuration / Windows settings / Security Settings / Wireless Network (IEEE 802.11) Policies/ 
|
-
Where is the GPO policy for Wireless networks located? 
|
-
SELECT
COL.CollectionID,
COL.Name,
COL.Comment,
MW.Name,
MW.Description,
MW.StartTime,
MW.Duration,
MW.UseGMTTimes
FROM
dbo.v_Collection COL,
dbo.vMWS_ServiceWindow MW
WHERE
COL.CollID = MW.CollectionID 
|
-
What is 802.11? Answer: A Standard for Wireless networks. 
|
-
Another questions that comes up in every study group session is, “What type of question can I expect?” I never been able to true explain what type of questions someone should expect on the exam. I finally found a way to explain what type of questions you can expect on the exam. Here is a simulation of all the exam question types. Hot area questions - This kind of question asks you to indicate the correct answer by selecting one or more elements within a graphic. Active screen questions - This kind of question asks you to configure a dialog box by changing one or more elements. Drag-and-drop questions - This kind of question asks you to drag source objects to appropriate targets within a work area. Build list and reorder questions - This kind of question asks you to indicate the correct answer by building an answer list. In a build list and reorder question, you need to build a list by dragging the appropriate source objects to the answer list and then placing them in the correct order based on criteria defined in the question. Create a tree questions - This kind of question asks you to create a tree structure. You indicate the correct answer by dragging source nodes to the correct locations in the answer tree. Nodes consist of text and a small icon. Testlet exam format - The MCP program has developed types of questions for Microsoft Certification exams that are very different from other exam formats currently being used. We strongly urge MCP candidates to download the demo and try the testlet exam format to become familiar with this new exam format. Simulation questions - This kind of question asks you to indicate the correct answer by performing specific tasks such as configuring and installing network adapters or drivers, configuring and controlling access to files, and managing hardware devices. Many of the tasks that systems administrators and systems engineers perform can be presented more accurately in simulations than in most traditional exam question types. To try them out for yourself, check out this demo! http://www.microsoft.com/learning/mcpexams/policies/innovations.mspx BTW This simulation seem to be missing one type of exam question, “Multiple select check boxes” however this is one of the easiest questions to handle mostly because as part of the question (on the exam) MS tells you how many answers to select. 
|
-
What is 802.11? 
|
-
This weeks reading for the self study group is: | 13.2 Proactive Directory Preformance Management | 25 | 41 | | 14.1 Understanding and Installing AD LDS | 16 | | 
|
-
When does WSRM polices kicks in? 
|
-
What remote access products are managed by the Administrative template settings? Answer: - NetMeeting
- Windows Messenger
- Terminal Services
- Remote Assistance
|
-
What remote access products are managed by the Administrative template settings? 
|
-
What is IEAK? Answer: Internet Explorer Administration Kit 
|
-
Round 2 of Speakers Announced!
You won’t believe who’s coming to SecTor 08 Check out the schedule now Save 10% today registering with Discount Code "OWSUG08" - click here World class IT Security Training sessions, the most innovative and industry leading speakers, the opportunity to network with the best from Canada and abroad, an elite selection of vendors, and new to this year, a lock-picking village and Renderman’s WiFi Clinic . Security Education Conference Toronto is the event that no serious IT professional can afford to miss. New to SecTor in 2008 is one-day training sessions running on Monday, October 6th, before the conference. SecTor is bringing Johnny Long, Dino Covotsos, SANS Institute and H D Moore to Canada to deliver leading-edge training through interactive sessions. Learn first-hand about the latest IT security threats and defences so that you can properly build, manage and defend your corporate networks. Click to register today!
SecTor Management - management@sector.ca
New Keynote and Sessions Announced - click here for all the keynotes and sessions > Keynote: "Baggage: What I took with me when I "left" Computer Security" - Stephen Toulouse > Keynote: "No-Tech Hacking" - Johnny Long > "Metasploit Prime" - H D Moore > “Network Security Trends for 2009 (aka ‘not the NAC’)” – Jennifer Jabbusch > "Advanced Spear Phishing Attack Framework" - Joshua Perrymon > "Owning the Users with The Middler" - Jay Beale > "RFID Unplugged" - Eric Johanson > "Double Trouble: SQL Rootkits and Encryption" - Kevvie Fowler ... view all the sessions here Look who we're flying up to deliver exceptional training (before the conference): > No-Tech Hacking with Johnny Long – GO > Bluetooth and Wireless Hacking with Dino Covotsos – GO > Cutting Edge Hacking Techniques with SANS Institute's John Strand – GO > Powersploiting: Leveraging the Metasploit Framework with H D Moore – GO Attendance is limited, so don't miss out - click here to register today! Security Industry-Leading Sponsors 
|
-
This is another tool that found out about by studying for 70-640/649 Recovering Deleted Objects in Active Directory Restoring deleted objects and information in Active Directory can be a manual and time-consuming task. Native backup and recovery utilities require intense involvement by the administrator, knowledge of what objects were deleted or affected, and require a Domain Controller to be rebooted. As a result, it is difficult for organizations to meet reasonable service levels for restoring deleted information in Active Directory, and avoid recovery pitfalls such as lost productivity and system downtime. http://www.quest.com/object-restore-for-active-directory/ Object Restore for Active Directory Freeware Restoring single, deleted objects in Active Directory can be a manual and time-consuming process requiring system downtime. Object Restore for Active Directory is a free, graphical utility that allows you to instantly recover deleted objects in a Windows Server 2003 environment without rebooting a Domain Controller. The freeware utility allows viewing Tombstoned objects in Active Directory and reanimating deleted items using Microsoft’s new Tombstone Reanimation interfaces for Windows Server 2003. When you download the Freeware, a 6-month key is built in. You will be prompted to re-register on our site at the end of each 6-month period. 
|
-
Where, how can you find the tombstone container? What is it used for?
The tombstone container is used to store AD objects for a period of time before they are removed from AD.
The tombstone container is found at cn=deleted objects, dc=<domainname>, dc=<network name net, com, ca, etc>
You need to use LDP.exe or a 3rd party tool to access this container. 
|
-
Well I'm going to be at the Ottawa Event on Nov 27th, see you there! www.Techdays.ca 
|
-
What is IEAK? 
|
-
Topic: Cross Platform Monitoring with OpsMgr 2007
Description:
Monitoring with Operations Manger 2007 is not limited to Windows Computers. The capabilities of Operations Manager extend far beyond. For the first time as an agent based solution native to Operations Manager, Unix systems can be monitored. Local resources like CPU, memory, disk can be monitored. Like the Windows Event Logs the syslog can also be monitored. Integration with Operations Manager even includes tasks which are performed locally on the agent managed systems. There is even integration with the reporting subsystem. See what is new with Cross platform monitoring in System Center Operations Manager!
About the Speaker: Brad Bird
An IT Professional of 12 years experience. Currently working as an independent consultant associated with Infront Consulting. Brad has more than 8 years under his belt specifically in Windows Networking Administration. Among his specialties are: Windows security, forensics, intrusion prevention and detection, Active Directory implementation, System Center Operations Manager implementation and consulting. Brad has specifically been focusing his efforts in the non-Windows space with Operations Manager. His certifications include MCT, MCITP, MCTS, MCSE, MCSA, A+ and Network+.
Location:
Microsoft Canada Co.
100 Queen Street Suite 500
Ottawa, Ontario
K1P 1J9
Agenda:
5:00 p.m. Event registration
5:30 p.m. Presentation
7:30 p.m. Q & A
8:00 p.m. Door Prizes
Notes: Pizza and Pop will be served, Please RSVP to help us order enough of both.
RSVP: http://www.clicktoattend.com/?id=131483 
|
-
Which is the best setup for user OUs? - OUs based on user rules, Example IT Admin, HR, Marketing
- OUs based on Geographic location
Answer: This is a trick question, neither is better than the other each has its place. 
|
-
SELECT
CS.Name0,
NA.Name0,
NAC.IPAddress0,
NAC.DefaultIPGateway0,
NAC.IPSubnet0,
NAC.DNSHostName0
FROM
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_NETWORK_ADAPTER NA,
dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
WHERE
NAC.ResourceID = CS.ResourceID
AND NA.ResourceID = CS.ResourceID
AND NA.ServiceName0 = NAC.ServiceName0
AND NAC.DHCPEnabled0<>1
AND NAC.IPAddress0<>'NULL'
ORDER BY
CS.Name0,
NA.Name0,
NAC.IPAddress0 
|
-
Which is the best setup for user OUs? - OUs based on user rules, Example IT Admin, HR, Marketing
- OUs based on Geographic location
|
-
What are the guidelines for designed client access to internal resource? Answer: - Consideration for design managed client configuration
- Consideration for Connection Manager profiles
- Client configuration
- Client roaming
|
-
This weeks reading for the self study group is: | 13.1 Proactive Directory Maintenance and Data store Protection | 53 | 53 | 
|
-
Where, how can you find the tombstone container? What is it used for? 
|
-
This question is one that comes up from anyone who has never booked an exam before. So I will provide a step by step with screen shots on how to book your exam. Note: In some cases I have removed personal details. Go to http://www.prometric.com/microsoft/default.htm 
Click the Schedule, Reschedule, Cancel, or Confirm an Exam link 
Click Schedule an Appointment 
Select your Country and Province then Click Next 
Click Next 
Read details and click Next 
Select the exam you want to take, in my case the 70-649 exam Select the Language and Currencies of how you are going to pay for this exam then click Next Note Exam centres are filtered by Country and Province and then sorted by City name, after that they are randomly sorted. 
Find the Exam centre that you plan on taking the exam at and then click Schedule Appointment. 
If you are a new user click the appropriate link, else logon using your email address and password. 
Select date and time for your exam, click Next 
If you are using a voucher to pay or using the 2nd shot voucher code click the YES link 
:-) Click Validate Pet Peeve: There is no message telling you that your voucher code is correct! This is particularly annoying when you are using the 2nd shot voucher codes as there will be NO indication that the code has been accepted! In my case I am using a fully paid for exam voucher. 
Note: I’m only showing part of the screen, there is just to much info on this screen plus I am removing all the personal data too. Make sure your email address is correct. 
Read the data privacy notice and select I agree Click Commit Registration 
Review the final Confirmation screen. Feel free to print this page. 
You will receive an email confirmation within the hour or so. Ensure the following are correct. (They are marked with arrows above) - Address
- Both Telephone numbers
- Site Name and address
- Date and Time
If any of these are incorrect call Prometric right away and get them correct it. If you don’t receive the email with a reasonable period of time you can confirm your registration via the web site or you can call Prometric and confirm the exam. Congratulations on booking your first exam! 
|
-
What are the guidelines for designed client access to internal resource? 
|
-
Select
RASIP.IP_addresses0,
RASR.System_roles0
from
dbo.v_RA_System_IPAddresses RASIP,
dbo.v_RA_System_SystemRoles RASR
where
RASR.ResourceID = RASIP.ResourceID
and RASR.System_Roles0 = 'Router' 
|
-
What are the guidelines for analyzing the authentication requirements for Mobile and other non-traditional commuting devices? Answer: - Device authentication
- Data synchronization
- Authentication to the network
|
-
Well I passed it, this morning!!! Man that was nice, 3 exams done in one shot!!! I think that I am the first one for the study group to pass all three exams! I know that Todd was close because he took and passed two of the beta exams! Even better I got a score of 1000 on the 70-640 exam section too! 850+ on the others. All this studying will help me led the study group sessions that starting on Monday! Hope to see you there! For those of you keeping track, I have passed 70-401, 620 , 622, 431, 290, 291, 293, 294, 624, 298, 640, 642, and 643 since Dec 11th 2007. I plan to pick up at least one more exam before Dec 10th 2008. The only question is which exam. 70-089, 400, 646, 647, 652, and I’m toying with 70-656 exam too. 
|
-
Which tool provide a wizard that can perform object and security translations tasks? Answer: Active Directory Migration Tool 
|
-
What are the guidelines for analyzing the authentication requirements for Mobile and other non-traditional commuting devices? 
|
-
SELECT
ISC.NormalizedPublisher,
ISC.NormalizedName,
ISC.NormalizedVersion,
ISC.CategoryName,
count(*) as 'count'
FROM
dbo.v_GS_Installed_Software_Categorized ISC
WHERE
ISC.FamilyName In ('Unidentified','Uncategorized')
group by
ISC.NormalizedPublisher,
ISC.NormalizedName,
ISC.NormalizedVersion,
ISC.CategoryName
order by
ISC.NormalizedPublisher,
ISC.NormalizedName,
ISC.NormalizedVersion,
ISC.CategoryName 
|
-
What account is the recovery agent for EFS on a Windows 2003 Stand-alone server? Answer: There is not recovery agent on stand-along servers or Windows XP workgroup PCs. 
|
-
Get a $50 discount to SQL Teach! Our user group has been give a discount code that will give you $50 off of the conference, use the code ON00NEPEAN to get your discount to SQLTeach / DevTeach! 
|
-
What account is the recovery agent for EFS on a Windows 2003 Stand-alone server? 
|
-
By default, can a normal user and owner of a file restore it using shadow copy? Answer: Yes, they can restore a file using shadow copy if they are the owner of that file. 
|
-
By default, can a normal user and owner of a file restore it using shadow copy? 
|
-
Which tool provide a wizard that can perform object and security translations tasks? 
|
|
|
|