OWSUG.ca

Symantec av software to a query

SMSUG.ca — Fri, 03 Feb 2012 18:47:15 GMT

Adding symantec av software to a query, see here for full details.http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/7c6b65be-cdfc-414f-a78d-f198f5e6a323 SELECT Sys.Netbios_Name0 as ' Computer Name ', Sys.User_Domain0 as ' User Domain ', Sys.User_Name0 as ' UserName ', Comp.Manufacturer0 as ' Make ', Comp.Model0 as ' Model ', Process.Name0 as ' Processor ', BIOS.SerialNumber0 as ' Serial# ', Memory.TotalPhysicalMemory0/1000...(read more)

IT Virtualization Boot Camp

SMSUG.ca — Fri, 03 Feb 2012 14:26:46 GMT

Did you know that the OWSUG is putting on the IT Virtualization Boot Camp? This boot camp is designed to help you pass the 70-659 exam… What do you need to know. the boot camp cost ~$27, there are two date for this boot camp Feb 17 & 18. Spots are going fast soo, book now! http://www.eventbrite.ca/event/2892520607...(read more)

OWSUG and Microsoft sponsored IT Virtualization Boot Camp in Ottawa

Brad Bird — Thu, 02 Feb 2012 19:49:59 GMT

These events are live and they’re HOT. 40 seats per event but they’re not free. The event cost is $25/person and registration is NOT optional.

40 seats is a HARD limit because that is the number of computers. Payments are collected via Paypal. Please register below. I hope to see you there!

http://www.eventbrite.ca/event/2892520607

Regards,

Brad Bird

President OWSUG

Busting the Myth: You cannot cluster Windows Small Business Server

Canadian IT Professionals — Thu, 02 Feb 2012 14:30:00 GMT

The following article is written by Mitch Garvis ( @MGarvis ) and also appears on The World According to Mitch . Microsoft created Windows Small Business Server as a one-box solution for companies that did not need more. It has always been a hobbled product, based on Windows Server Standard, but limited in things like domain trusts, FSMO roles , and more. Of course even if it were based on Windows Server Enterprise, the idea of creating a failover cluster for a product designed to be a single-server...(read more)

“The SQL Guy” Post #14: The Myth Behind Stored Procedure Behaviour

Canadian IT Professionals — Wed, 01 Feb 2012 14:30:00 GMT

You are a trusted database developer for your company. You developed a Stored Procedure that will perform some important functions on the database. You tested the Stored Procedure and everything looks great. The Stored Procedure runs the way you expected and within the anticipated timeframe. Everything looks great and now you are ready to deploy the code to the production environment. The production environment has same hardware as development/test environment therefore, you are confident that your...(read more)

SCCM Query for Memory & CPU

SMSUG.ca — Wed, 01 Feb 2012 02:18:43 GMT

See Forum post for fill details. select distinct SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_G_System_PROCESSOR.NormSpeed from SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_PROCESSOR on SMS_G_System_PROCESSOR.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID...(read more)

One of the Many Reasons Why We Support Communities!

Canadian IT Professionals — Tue, 31 Jan 2012 23:28:16 GMT

The following article is written by Mitch Garvis ( @MGarvis ), who wanted to share the story of an individual who spoke of the value of getting involved with user groups and community and the benefits of doing so. It is also a great example of why my team here at Microsoft Canada is so passionate about working with your local user group and community association. Check it out! Last week I met a man at the Microsoft Virtualization Boot Camp who nearly made me cry. His name is Andrew...(read more)

STEP Event from January OWSUG meeting Deploying Windows 7 for Enterprises of ANY size–Still waiting?

Brad Bird — Tue, 31 Jan 2012 03:18:00 GMT

This presentation was popular and very well received. Members asked me to post the slides so here they are!

Right Click link and Choose Save As to download Windows 7 for Enterprises of ANY size–Still waiting?

You Only Need One Tool to Get System Center 2012 RC Installed!!

Canadian IT Professionals — Mon, 30 Jan 2012 20:42:18 GMT

Talking to individuals who downloaded the System Center 2012 RC from the TechNet Eval Center in December or early January, one of the pieces of feedback I received is that in order to get everything running you needed to install each component individually and that just took too long and also meant that you were potentially responding to over 450 screens of information. I get it. That’s a lot of work to test out a Pruvate Cloud solution and its components. Looks like the product...(read more)

Free Learning Resources for Microsoft Virtualization & Private Cloud

Canadian IT Professionals — Fri, 27 Jan 2012 14:30:00 GMT

In the last little while as we have started to deliver the IT Virtualization Boot Camps as well as go out to various user groups and talk about the Microsoft Virtualization and Private Cloud offerings, I have often been asked where IT Pros can find resources to learn about how our products work, especially by those individuals who are familiar with VMware but not so much with Hyper-V and System Center. Here are some that I would recommend: Microsoft Virtual Academy Microsoft Virtual Academy...(read more)

Virtualization Infrastructure: Which platform is right for you?

Canadian IT Professionals — Thu, 26 Jan 2012 15:00:00 GMT

The following article is written by Mitch Garvis ( @MGarvis ) and also appears on The World According to Mitch . Over the past year as a Virtual Partner Technology Advisor for Microsoft Canada I have heard a lot of people say a lot of things about Hyper-V, and not all of it has been from people who work for (or are otherwise strongly invested in) VMware. Some of those arguments are reasoned, others emotional, but there are still a lot of people who argue that because Hyper-V is free, it cannot be...(read more)

Hey Vancouver IT Pros!!! IT Virtualization Boot Camps Are Coming to Your City Feb 10 & 11!!

Canadian IT Professionals — Thu, 26 Jan 2012 05:03:28 GMT

Wow! When we announced the IT Virtualization Boot Camps in the TechNet eNewsletter last week, the response from you has been overwhelming. Many of you emailed me saying you wanted an IT Virtualization Boot Camp in your city. The folks on the West Coast, were especially vocal. Well, I am happy to announce that we will be holding IT Virtualization Boot Camps in Vancouver on Friday, February 10th and Saturday, February 11th . IT Virtualization Boot Camps are brought...(read more)

PowerSE 2.7 KB: PowerShell profile does not load on startup

Poshoholic — Wed, 25 Jan 2012 19:01:59 GMT

With the release we published yesterday, both PowerSE and PowerWF received a new feature: product-specific profiles. This feature allows you to have profile scripts that you only want run in PowerSE or PowerWF run there so that you don’t have to use if statements to check the host name in your profile scripts. With this [...]...(read more)

“The SQL Guy” Post # 13: Changes to Location of Startup Options in SQL Server 2012

Canadian IT Professionals — Wed, 25 Jan 2012 15:00:00 GMT

Many users have hated the way SQL Server supported configuring startup parameters in previous versions. It was confusing and buried in a single text box under the Advanced Tab of SQL Server services in Configuration Manager. The only way you could separate different options is by using a semicolon(;) between the options. With the introduction of SQL Server 2012, this is no longer an issue. The Startup Parameter option has been relocated to its own tab and can be easily accessed from SQL Server...(read more)

Lots of Learning & Team Spirit at IT Virtualization Boot Camps in Mississauga

Canadian IT Professionals — Wed, 25 Jan 2012 03:09:56 GMT

Yesterday, we wrapped up the second IT Virtualization Boot Camp brought to you by Microsoft TechDays Canada and your local user group - IT Pro Toronto . Both on Saturday and on Monday, we had a full house with 40+ attendees taking part in a hands-on journey to a highly-available virtualization infrastructure on the Microsoft platform . On top of that, all proceeds from registration fees for the event went to benefit IT Pro Toronto and allow it to continue to serve IT professionals in...(read more)

PowerWF and PowerSE 2.7 are now available

Poshoholic — Tue, 24 Jan 2012 17:44:30 GMT

This morning PowerWF and PowerSE 2.7 were released to the web and they can now be downloaded from http://www.powerwf.com. These releases offer a lot of new value to PowerWF and PowerSE users, as follows: PowerWF 2.7 Highlights New Start Page with New Workflows The start page in PowerWF has been completely redesigned to provide immediate [...]...(read more)

Licensing software in the cloud

Canadian IT Professionals — Mon, 23 Jan 2012 19:03:00 GMT

A girlfriend of mine called me up this weekend looking for a DVD copy of an older piece of software. She was rebuilding a computer for a family member who had the product key but no installation media. I’m sure many of you have similar stories trying to fix or repair computers for your family and friends. One of the nice things about using software online or “in the cloud” so to speak is that if your computer goes belly up and you need to rebuild it, the software will be there waiting...(read more)

What’s a Layer 1 or Layer 2 Hypervisor and Where Does Hyper-V Fit In?

Canadian IT Professionals — Mon, 23 Jan 2012 14:15:00 GMT

The following article is written by Mitch Garvis ( @MGarvis ) and also appears on The World According to Mitch . Expect to see more articles from Mitch in the future. In the world of Server Virtualization, there are two types of hypervisors: Layer 2 hypervisors are installed as an application (or service) on an existing operating system (such as Microsoft Windows). Layer 1 hypervisors are in and of themselves operating systems that are installed on the ‘bare metal’ – directly on the hardware....(read more)

Microsoft Online learning opportunities: February 2012

Canadian IT Professionals — Wed, 18 Jan 2012 15:48:25 GMT

Hello folks, This is my compilation of some of the online resource available to you in February 2012 . This list featuring both live and on-demand content including webcasts, videos, virtual labs, and podcasts by product and topic. this is not the WHOLE list of the available content. but these are the ones i thought were relevant to customers and IT pros. Microsoft webcasts are 30-90 minutes in length and feature interactive presentations, product demonstrations, and question-and-answer sessions....(read more)

“The SQL Guy” Post # 12: Understanding Data Hashing Techniques in SQL Server

Canadian IT Professionals — Wed, 18 Jan 2012 14:30:00 GMT

I don’t often deal a lot with the business intelligence side of SQL Server preferring to spend most of my time on the relational side of the house. However, once in a while topics about optimizing a data warehouse or helping to secure BI data peak my interest. I ran across this article by Don Pinto, a SQL Server Security Product Manager at Microsoft and thought it was worth sharing. Enjoy!! A common scenario in data warehousing applications is knowing what source system records...(read more)

Custom Windows 7 report - workstation manufacturer & model & client version

SMSUG.ca — Tue, 17 Jan 2012 01:21:40 GMT

SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Client.Version0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID JOIN v_GS_OPERATING_SYSTEM OPSYS ON COMSYS.ResourceID = OPSYS.ResourceID JOIN v_GS_LOGICAL_DISK LDISK ON COMSYS.ResourceID = LDISK.ResourceID and LDISK.DeviceID0= SUBSTRING (OPSYS.WindowsDirectory0,1,2)...(read more)

Custom Windows 7 report - workstation manufacturer & model type

SMSUG.ca — Mon, 16 Jan 2012 23:03:44 GMT

SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID JOIN v_GS_X86_PC_MEMORY MEM ON COMSYS.ResourceID = MEM.ResourceID JOIN v_GS_OPERATING_SYSTEM OPSYS ON COMSYS.ResourceID = OPSYS.ResourceID JOIN v_GS_LOGICAL_DISK LDISK ON COMSYS.ResourceID = LDISK.ResourceID and LDISK.DeviceID0= SUBSTRING (OPSYS.WindowsDirectory0,1,2)...(read more)

WQL Query for both x86 and x64 version of Software

SMSUG.ca — Mon, 16 Jan 2012 22:27:42 GMT

select distinct SMS_R_System.Name, SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = " Microsoft Lync 2010 ") or SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS_64 where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = " Microsoft Lync...(read more)

Important Webcast Tomorrow: Learn About Exciting Developments in Microsoft’s Private Cloud Strategy

Canadian IT Professionals — Mon, 16 Jan 2012 17:14:53 GMT

Tomorrow (January 17th) at 8:30am PST / 11:30am EST there is a really important webcast featuring Satya Nadella , the President of Microsoft’s Server and Tools Business. If you are interested in hearing developments about Microsoft’s Private Cloud strategy including the System Center product line, Hyper-V, and Windows Server, you need to register for the webcast . During the webcast you will Hear from other senior IT professionals about how cloud computing can help you gain maximum competitive...(read more)

Get Hands-On With Microsoft Virtualization & Help Your Local User Group

Canadian IT Professionals — Fri, 13 Jan 2012 19:58:46 GMT

As our team looks to provide valuable content to you to help you grow in your career and acquire new skills, I am often asked if we can put on more hands-on events where you get a chance to play with the technology. At TechDays 2011 this year we offered hands-on labs for the very first time and had a phenomenal response. However, TechDays did not go to all cities across the country and we want to be able to offer more hands-on style activities to you in the places where you are. ...(read more)