By Jameel Ahmed, 08/12/2009
Three 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. ...
By Jameel Ahmed, 05/15/2009
Stored 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 ...
By Jameel Ahmed, 06/21/2007
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 ...