SQL Server 2005 SSIS Error Loading Type Library/DLL
As part of consolidation for a client, I came across a minor issue with SQL Server 2005 SSIS. While opening SQL Server 2005 SSIS there was an error ‘Loading Type Library/DLL‘. …
Read MoreSQL Server Education (by the geeks, for the geeks)
As part of consolidation for a client, I came across a minor issue with SQL Server 2005 SSIS. While opening SQL Server 2005 SSIS there was an error ‘Loading Type Library/DLL‘. …
Read MoreA common snag that I have seen while using the Import & Export wizard over the years is running into – Failure Inserting into the Read-Only Column. Lot of us have panicked …
Read MoreRecently I ran into an odd scenario. Net new SQL servers were built in Dev, QA and Prod. I had to create Linked Servers to SSAS. All of these were on SQL …
Read MoreWe have been recently migrating a lot of physical clusters to virtual. The quickest way to move sql agent jobs was to restore MSDB database. To validate if jobs were in order …
Read MoreWe all know that creating linked server from SQL 2012 to SQL 2000 does not work using the new native client SQLNCLI11. This client only connects to the following: 2005, 2008, …
Read MoreRecently I was approached and asked if there was an easy way to install client tools on SQL Server cluster. There is an easy way without ripping out and reinstalling the …
Read MoreAs promised here is my take on Slipstreaming SQL Server. I will touch on a WHY and HOW. If you have been following my previous blogs, my intention is to get work done …
Read MoreThis blog is intended to be a guideline for installing SQL Server in Windows Server environments. This came about as I am heavily involved with virtualizing SQL Server in different Windows environments. …
Read More“TSQL is 2 faced!” – cried the app team member “Have you been watching Batman?” Recent conversation with application folks made me think and I decided to break it down on Understanding …
Read MoreOver the years I have seen admins struggle when asked to provide SQL instance level information. They right click here and there and YES I was one of them till I …
Read More