SQL Consolidation Considerations !!!

In modern times, with current focus of most organizations on saving costs by means of virtualization and consolidations., It becomes increasingly important for DBAs to ensure that help organization achieve this objective without compromising on the performance, scalability, availability & application compatibility. In this blog post, I would like to give some pointers on the… Continue reading SQL Consolidation Considerations !!!

Unable to run DTS Package fetching data from Oracle using ODBC Driver after migrating to 64 bit

Recently one of my customers migrated and upgraded their servers from SQL 2000 32 bit  to SQL 2005 64 bit following which their DTS packages stopped working. In this blog post I intend to explain the troubleshooting approach, we adopted to resolve the issue along with the resolution to the problem. When you migrate DTS… Continue reading Unable to run DTS Package fetching data from Oracle using ODBC Driver after migrating to 64 bit

Dependency Map of the Nested Stored Procedures using DMV

One of my customers, had a requirement to identify the call graph (or other words dependency map)  for the nested stored procedures. While with SQL 2008, two new DMVs viz  sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities  to identify the referencing and referenced objects by the stored procedures within the database. However, the DMV gives the information of the… Continue reading Dependency Map of the Nested Stored Procedures using DMV

How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I

Recently there was a requirement from one of my customers to query Active Directory and load the data into a table in sql server. To be honest I am not developer so I started researching on the topics over the net and took help of some of the internal resources which I had access to.… Continue reading How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I

How to query Active Directory to Fetch more than 1000 rows using Sql Server–Part II

Continuing from where I left in my previous post.  The Stored Procedure mentioned in my previous post cannot be used to query pwdlastset from AD since it is stored in Integer8Date format which cannot be interpreted by sql server. So when there is a requirement to query pwdlastset from AD we need to use a… Continue reading How to query Active Directory to Fetch more than 1000 rows using Sql Server–Part II