Enabling ADUC on Windows 7
I’m unable to locate a working plug-in/snap-in for Active Directory Users and Computers that works on Windows 7. Fortunately, there’s a workaround that allows administration of ADUC in Windows 7 with a little modification. First, you’ll need to download and install RSAT for Windows 7. It’s found here. You’ll need this before you can do anything else. Once this is installed, on your Windows 7 box, open Programs and Features and click the Turn Windows Features On or Off option….
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…