Scott Guthrie is returning to Phoenix!
Mark the calendar, Microsoft’s own Scott Guthrie is returning to Phoenix on May 10th at the Scottsdale Resort and Conference Center. From 8am-6pm, we’ll get to enjoy the wisdom and insight of one of the industry’s top professionals, along with great speakers such as Scott Hanselman and Jeffrey Palermo! There’s a link on the side along with a countdown, courtesy of @ScottCate. Seats are filling up quickly!
Long SQL query time and account permissions
My good friend @MichaelPerillo and I were recently discussing the possible cause for a SQL query to take an excessively long time, even though proper measures had been taken to ensure performance tuning had taken place. He made a suggestion that I believe is noteworthy, so I’m putting it here, also so I can reference it later. A transactional SQL database performs each transaction in a queue, assigning each transaction a queue request. Queue requests are prioritized not only by…
Query AD using T-SQL
So I’m working on a small interface that needs to check certain computers in our enterprise for file changes, and fortunately these specific computers are kept in a group nested inside our AD structure. My thought was, if I can use a SQL query to go get that list of machines, put the results in a table, then have the interface read from that table it would always have a current list of these machines, with no maintenance required for…
No-Cost training on Channel 9
MSDN’s Channel 9 is offering no cost training from their learning center. Learn at your own pace with these on-demand videos. Here are a few links to some of their content: Microsoft Office 2010 WorkshopWindows Server 2008 R2 Developer TrainingSharePoint 2010 DeveloperVisual Studio 2010 and .Net Framework 4 Training CourseWindows 7 Developer Training Also, here are a few links to some no-cost Exchange Server 2010 E-Learning courses:Clinic 6899: Exploring Features of Exchange Server 2010 (2 hours)Clinic 6900: Introduction to Exchange…
Excellent article on getting AD info using C#
I’m always getting, updating, and validating against AD info at my company, and today I needed to pull several different schema attributes in one method, and kept running into more and more trouble. Code got bigger and bigger, and I thought there had to be a way to simplify this. I then ran across a CodeProject article definitely worth mentioning. The author, Rajasekhara Sambangi does an excellent job of demonstrating a simplified way of pulling just about anything from AD…