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…
Returning the Nth weekday in SQL…and in InfoPath
Ok, after much research I found a forum that had a posting that demonstrated how to get the Nth chosen weekday of a month using T-SQL. Here’s the code: DECLARE @date datetimeDECLARE @weekday intDECLARE @day datetimeDECLARE @number intDECLARE @WhichOne int SELECT @WhichOne = 2 — Set this to the week you want to grabSELECT @number = 1SELECT @weekday = 0SELECT @date = getDate() — Change to dateadd(month, 1, getDate()) for next month, etc. WHILE @weekday 4 — Change this value…