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 MoreAuthor: Arsalan Khan
Failure Inserting into the Read-Only Column
A 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 MoreUnable to Create Linked Server for SSAS Provider MSOLAP
Recently 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 MoreSQL Agent Job Error CMDEXEC subsystem failed to load
We 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 MoreCreating Linked Server from SQL 2012 to SQL 2000
We 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 MoreInstall Client Tools on SQL Server Cluster
Recently 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 MoreSlipstreaming SQL Server
As 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 MoreSQL Server in Windows Server Environment
This 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 MoreSQL Server – Understanding Logical Query Processing (LQP)
“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 MoreSQL Sever SERVERPROPERTY – The Unused Power
Over 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