http://www.sqlmag.com/authors/author/author/5297693/rss/5297693en-USFri, 25 May 2012 11:00:07 GMTFri, 25 May 2012 11:00:07 GMThttp://www.sqlmag.com/article/tsql3/querying-active-directory-recordsThree common methods for querying AD are using a linked server, using an SSIS ADO.NET connection manager, and using an SSIS Script component. But these three methods aren’t equal. Learn how they work and why their results differ.]]>Jameel AhmedWed, 12 Aug 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/querying-active-directory-recordshttp://www.sqlmag.com/article/tsql3/clr-stored-procedure-finds-broken-objectsStored procedures, user-defined functions, views, and triggers can fail to execute when the objects they reference have been changed. Here’s a tool you can use to detect broken objects before they cause problems. ]]>Jameel AhmedFri, 15 May 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/clr-stored-procedure-finds-broken-objectshttp://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures When a SQL Server job fails, SQL Server Agent sends a notification but it doesn’t include the error message generated by that job failure. Here’s how you can have the error message emailed to you.]]>Jameel AhmedThu, 21 Jun 2007 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures