SQL 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‘. …
SQL Server 2005 SSIS 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 …
Failure Inserting into the Read-Only Column 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 …
Unable to Create Linked Server for SSAS Provider MSOLAP 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 …
SQL Agent Job Error CMDEXEC subsystem failed to load 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, …
Creating Linked Server from SQL 2012 to SQL 2000 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 …
Install Client Tools on SQL Server Cluster 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 …
Slipstreaming SQL Server 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. …
SQL Server in Windows Server Environment 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 …
SQL Server – Understanding Logical Query Processing (LQP) 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 …
SQL Sever SERVERPROPERTY – The Unused Power Read More