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 […]
Month: November 2008
SELECT CS.Name0, CS.Model0FROM dbo.v_GS_COMPUTER_SYSTEM CSWHERE CS.Model0=’PowerEdge 2850′
SELECT CS.Name0, RA_SIS.SMS_Installed_Sites0, S.ServerNameFROM dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_RA_System_SMSInstalledSites RA_SIS, dbo.v_Site SWHERE 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 […]
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 (v-anhow@microsoft.com) will personally […]
How to fix the font issue with CHM files!!!! This has been bugging me for a while so much so that I begged one of the docs team member to help me fix the issue!!! Notice that the text above is unreadable!!!! Fix:1. From the CHM Menu click Options2. Click Internet Options3. From Internet […]
Last night I was at the Ottawa SQL Group event helping out and I found out an interesting tidbit. This tidbit is only for production environments only, in Dev or in test labs, anything goes. SQL 2000 are NOT supported under at virtualization product! Now some people are going to asked about SQL 2005 & […]
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 […]
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. Select * from v_R_System where AMTStatus0=3
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 […]