24 Hours of PASS is back!
SQL PASS (@sqlpass) is having it’s FREE 24 Hours of PASS event again, May 19th and 20th. For 24 hours, industry professionals such as Brian Knight, Donald Farmer, Thomas Grohser, and Brad McGehee will be presenting topics on SQL Server 2008 R2, including database design, SSRS, SSIS, BI, data warehousing, dashboards, server performance and much more. The link to register is here. I did the last one back in October 2009 and it was fantastic. A little difficult to stay…
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…