Month: October 2008

User Group Survey

At last week’s user group meeting, I hand out a quick survey of the event and what topic we should do next. The results are fairly interesting: Take more that 10 minutes to write a survey and have someone else proof read it. (Foot) 🙂 The session content applied to everyone The session was not […]

Upgrading and Migrating to SQL Server 2008

Free Evening Event @ Microsoft Ottawa Thursday, November 13th 5:15 – 8:00 PM Feature Presentation: Upgrading and Migrating to SQL Server 2008 Best Practices and Lessons from the Field, Damir Bersinic Damir will be in town for the Ottawa stop of the Align IT tour on November 13th. He will be taking this opportunity to […]

Find everyone with two or more workstations

SELECT     CS.UserName0Into     #tmpFROM        dbo.v_GS_Computer_system CSgroup by    CS.UserName0Having     Count(CS.UserName0) > 1 SELECT     CS.Name0,     CS.Manufacturer0,     CS.Model0,     CS.UserName0FROM        dbo.v_GS_Computer_system CS,    #tmpWhere     #tmp.UserName0 = CS.UserName0    or CS.UserName0 != NullOrder by    CS.UserName0,    CS.Name0,     CS.Manufacturer0,     CS.Model0 Drop table #tmp