November 2008 - Posts
Topic: SQL Server 101 for the IT Pro & SQL Server Chalk Talk
SQL What?!? What every IT Pro needs to know about SQL Server
More and more products require a SQL Server database. Are you an IT Pro installing SQL Server but not sure how to support it? Do you work at a place where you are the IT department? Well this event is for you!
The OWSUG and OttawaSQL.net user groups are teaming up to bring you a special session dedicated to SQL Server for the non-DBAs.
We will cover important topics that are often overlooked until it is too late, and talk about ways to simplify SQL Server administration.
· Backup and Restore
· Checking for data corruption
· Creating Maintenance plans
· Sending alerts
· Setting up email for notifications
· Security Basics
· Tips and Tricks, and time saving tools
… and much more!
After the presentations we will have a panel of local DBAs, SQL Server veterans and Microsoft MVPs ready to answer your questions in an informal SQL Server Chalk Talk
Product Showcase (15 minutes): SQL Response - Red Gate Software, David E. Myers
No flashing lights. No repetitive emails. No complicated configuration required. Only the intelligent alerts and diagnostic data you need to resolve problems on your SQL Servers sooner. All from a single, intuitive interface. SQL Response monitors the health and activity of your SQL Servers, so you can work proactively to resolve the problems that matter most. See how no-nonsense monitoring from Red Gate's new SQL Response™ can help you make the most of your office hours.
Microsoft Canada Co.
100 Queen Street Suite 500
Date: December 11th, 2008
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.
SELECT CS.Name0, RA_SIS.SMS_Installed_Sites0, S.ServerName
FROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_RA_System_SMSInstalledSites RA_SIS, dbo.v_Site S
WHERE CS.ResourceID = RA_SIS.ResourceID AND RA_SIS.SMS_Installed_Sites0 = S.SiteCode
Microsoft Canada is conducting a brief 10-15 minute online survey to better gauge and understand where and how you as a Technical Professional (IT Professional, Developer, Architect or IT Manager for example), find IT? With these learning’s, we can ensure we are driving and delivering information to the right location that is the highest value to you. With your participation, we’ll also be able to better understand how Technical Professionals like yourself consume various types of technical information so we can ensure resources you need are readily available.
Upon completion of the survey, you will have the opportunity to opt-in to receive a summary of the results,
if it is of interest to you. Look for more details at the end of the online survey.
As a token of our appreciation by completing the survey, your name will be entered into a random draw to win* one of five Microsoft Zunes® 4GB.
http://survey.openvenue.com/msstudy?ex1=5 . If you have any difficulties completing the survey,
please e-mail MStechhelp@researchnow.ca for assistance.
SURVEY CLOSE DATE IS: December 5, 2008 @ 4pm EST.
SURVEY LENGTH: 10-15 minutes
Thank you for your participation. We look forward to hearing from you.
In anticipation of the upcoming Tech•Days 2008 tour date in Ottawa on November 27th, I’m writing to inform you of an EXCLUSIVE HOLIDAY OFFER that Microsoft Canada is extending to user group members in Ottawa.
The first 300 user group members to forward their confirmation e-mail for full-price registration to Andrew Howell (email@example.com) will personally receive a copy of Fable 2 for XBOX 360 at the event on November 27th, 2008.
The confirmation e-mail must pertain to a full-price registration and the recipient should reference the user group(s) to which they belong. Their notification must be forwarded to Andrew Howell no later than November 25th, 2008 at 5:00pm EST.
The XBOX title will be available for pick-up at a designated time at the event. Specific details will be communicated directly to each individual recipient in advance of the Ottawa event.
We sincerely hope that you’ll take advantage of this exclusive offer and look forward to seeing you on November 27th, 2008!
DevTeach Montreal is less than a month away but it's not too late to register. This is a great conference with sessions covering .NET FX, Future, SQL Server, VSTS/Team System, Silverlight, Agile Development, Software Architecture, ASP.NET. Aside from the great content, build up your professional network by rubbing shoulders with the speakers in an intimate conference. The list of speakers is particularly impressive this year. From MS you'll get to see Elisa Flasko and Carl Perry from the Data Programmability Team, Beth Massi and Yair Alan Griver. Of course .NET Rockers Carl Franklin & Richard Campbell will be there with fellow MS Regional Directors Tim Huckaby, Joel Semeniuk, Stephen Forte, Jim Duffy, Guy Barrette and Barry Gervin.
But wait, there's more...
- Every attendee to DevTeach Montreal will get Visual Studio 2008 Pro, Expression Web 2 and Tech-Ed Developer DVD set in their bag. That represents over $1,000 worth of software!
- The TechDays/DevTeach rebate coupon will get you a $350 discount if you use it for the December Montreal event. That's $250 more than its original value!
- The user group discount has been increased from $50 to $100 for the December Montreal event. Just use rebate code OT00NETUGC
Are you wanting to know how to determine which PCs within your environment have vPro? Well you will need to turn on Network Discovery to add this information to your db. http://technet.microsoft.com/en-ca/library/cc431387.aspx
Here is the SQL query to tell you.
So Brian posted a blog about ConfigMgr Range training, this goes alone the same lines as System Center Configuration Manager Enterprise Administrator and System Center Operation Manager Enterprise Administrator
Configuration Manager needs an MCITP and so does OpsMgr!
Microsoft last suggestion that the System Center MCITP (70-402) would included both 70-400 and 70-401 (Sorry Trika et al), just does not make sense, hence why I did my blog post about Enterprise Administrators!
Personally, I would go for the both options in a heartbeat, if the option was available to me! But to become a ranger you don’t just study and pass and exams, you must truly understand the product, be invited to take the training, (which cost gig bucks) and be reviewed by both MS & your peers.
So what I’m I doing to work towards this? Well first step is to continue working on study for exams to get my “System Center Configuration Manager Enterprise Administrator” (SCCMEA) :-)
And I think that for the licensing component of SCCMEA that Planning, Implementing, and Maintaining a Software Asset Management (SAM) Program should qualify.
After all of the exams that I have done recently I still don’t have neither the SCCMEA or SCOMEA yet! However I am still working on trying to “Put my money where my month is”! I might regret putting the MSI certification in there but...
Since I am really busy and can't write a study guide, I want to try something new for this exam, I created a WIKI page on MyITForum to help everyone review for this exam.
So let see what the community can do to prepare everyone for this exam.
· I have started by posting the Microsoft Preparation guide,
· Each topic item need to be expanded to provide details (with screenshots)
· New sub-topic need to be added to list locations of:
o VHD – to create test labs
o Virtual Server Software
o Review software – NO BRAIN DUMPS!!!! (Measure up and Transender)
o List of any KB or other MS links.
· Post the Beta exam code when it is available.
Get ready for a new Exam
About this Exam
This exam validates the skills necessary for IT professionals to create and maintain deployment infrastructures and images for Windows Vista, Windows Server 2008, and Office 2007
Candidates for this exam should have one year of on-the-job experience deploying Windows operating system or application images. Including creating and maintaining deployment infrastructures and images for Windows Vista, Windows Server 2008, and Office 2007. Candidates should have a minimum of one year of experience deploying Windows operating systems and applications and troubleshooting day-to-day issues that involve deployments and their related tools.
Candidates should be proficient with Microsoft Deployment Toolkit (MDT) 2008 or Microsoft Business Desktop Deployment (BDD) 2007 and have a basic understanding of a Windows-based network. In addition candidates should be familiar with Active Directory Domain Services (AD DS) in Windows Server 2008, DNS, DHCP, file sharing, and share security. Candidates should will have a basic understanding of the technologies underlying operating systems and applications being deployed, for example, Unattended Windows setup process, Windows Pre-Installation Environment (Windows PE), User State Migration Tool [USMT], System Center Configuration Manager [ConfigMgr 2007], and Application Compatibility Toolkit [ACT]).
Credit Toward Certification
When you pass Exam 70-635: TS: Microsoft Deployment Toolkit 2008, Desktop Deployment, you complete the requirements for the following certification(s):MCTS: Microsoft Deployment Toolkit 2008, Desktop Deployment
Skills Being Measured
This exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.
Preparing a Deployment Infrastructure (20 percent)
- Prepare a deployment environment to meet the recommended system requirements.
- This objective may include but is not limited to: preparing the infrastructure servers to ensure that hardware requirements are met, ensuring that the network environment is functional
- Install and configure servers, roles, and products.
- This objective may include but is not limited to: installing and configuring Windows Server 2008, AD DS, DHCP Server, IIS 7.0, and ConfigMgr 2007
- Install and configure MDT.
- This objective may include but is not limited to: installing the Microsoft Development Toolkit, enabling Configuration Manager Console integration, configuring the Network Access Account, updating live data in Information Center
- Install and configure additional tools.
- This objective may include but is not limited to: Windows Automated Installation Kit (Windows AIK), USMT, ACT, Windows Deployment Services (Windows DS)
Configuring Images, Applications, and Scripts (22 percent)
- Populate distribution shares.
- This objective may include but is not limited to: importing source files for operating systems, applications, service packs, language packs, drivers, and security updates
- Create driver groups.
- This objective may include but is not limited to: create an inventory of hardware and peripherals and their corresponding drivers, distinguish between in-box and out-of-box drivers
- Configure task sequences.
- This objective may include but is not limited to: configuring Zero Touch Installation (ZTI) task sequences, configuring Lite Touch Installation (LTI) task sequences, adding server roles, distinguishing among task sequence templates
- Create and configure deployment points.
- This objective may include but is not limited to: creating and configuring lab deployment points, media deployment points, network deployment points, and Windows PE; configuring application lists, image captures, network shares, and product keys; editing rules, for example, customsettings.ini and bootstrap.ini; adding tools to a deployment point, for example, USMT
- Select an activation method.
- This objective may include but is not limited to: selecting Key Management Services (KMS) or Multiple Activation Key (MAK) as the most appropriate activation method
- Configure Office settings and components.
- This objective may include but is not limited to: placing the custom.xml file in a source directory, detecting file issues by using Office Migration and Planning Manager (OMPM), adding language packs, configuring Office applications in multiple language environments, configuring the Local Installation Source (LIS)
Building Custom Images (19 percent)
- Customize operating system images.
- This objective may include but is not limited to: customize Windows Server 2008 and Windows Vista by using Windows System Image Manager (Windows SIM) and processes, distinguish between online and offline customization tools and processes
- Install and configure Office 2007.
- This objective includes but is not limited to: create a network installation point, create application packages for Office 2007, configure Office applications to install automatically
- Install and configure other applications.
- This objective may include but is not limited to: installing Microsoft or third-party applications such as anti-virus software, VPN software, and backup software
- Capture images.
- This objective may include but is not limited to: capturing images by using SysPrep, ImageX, and Windows PE
- Localize images.
- This objective may include but is not limited to: importing language packs, changing regional settings, changing time zones
- Import custom images.
- This objective may include but is not limited to: importing custom images to Windows DS, importing custom images to MDT
- Conduct build verification tests (BVTs).
- This objective may include but is not limited to: testing deployment of operating systems packages or images, testing deployment of applications, testing installation of drivers, patches, anti-virus software, security updates, and service packs
Deploying to Production (21 percent)
- Select an MDT deployment method.
- This objective may include but is not limited to: selecting an appropriate deployment method (LTI or ZTI with System Center Configuration Manager)
- Select a deployment medium.
- This objective may include but is not limited to: selecting an appropriate deployment medium, for example, Windows DS, DVD, USB, and CD
- Deploy images by using the Using ZTI deployment method.
- This objective may include but is not limited to: creating packages, importing and advertising task sequences in ConfigMgr 2007
- Deploy Office 2007 with ConfigMgr 2007.
- This objective may include but is not limited to: creating an Office package and program for deployment, adding the package to a task sequence
Monitoring and Troubleshooting Deployments (18 percent)
- Locate and analyze logs.
- This objective may include but is not limited to: locating and analyzing BDD.log, SMSTS.log, and Panther logs
- Monitor deployment status by using the MDT Management Pack (MP) for System Center Operations Manager 2007.
- This objective may include but is not limited to: installing, configuring, and using the MP to monitor deployment success or failure
- Report deployment status by using System Center Configuration Manager Reporting.
- This objective may include but is not limited to: using reporting to create status reports on deployments
- Troubleshoot security configurations.
- This objective may include but is not limited to: troubleshooting the configuration of shares, accounts, permissions, security groups, and database connectivity
I passed this exam this morning, the only exam left to take is 70-400, So Rory and Brad, I will work on that one once I get back from holidays!
So Pete hurry up an finished this study guide for me to use. :-) maybe I will help him complete it.
I took one of the free certification that Brainbench is offering and I earned a Master Microsoft Security, time to add this to my resume.
BTW I ranked 29th in the world and 2nd within Canada, with my score! Not too bad..
That right, I say free Certifications! BrianBench is giving away lots of free certification, here are just a few of them! so what are you waiting for?
count(*) as 'Count'
dbo.v_GS_WORKSTATION_STATUS as WS,
dbo.v_R_System as SYS,
dbo.v_RA_System_SystemOUName as OU
SYS.ResourceID = OU.ResourceID
and SYS.ResourceID = WS.ResourceID
and Datediff(dd,WS.LastHWScan, getdate()) > 1