Skip to content
April 1, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Author: Arsalan Khan

SQL Server

SQL Server 2005 SSIS Error Loading Type Library/DLL

June 29, 2015 - by Arsalan Khan - Leave a Comment

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 More
SQL Server

Failure Inserting into the Read-Only Column

May 13, 2015May 12, 2015 - by Arsalan Khan - 3 Comments.

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 …

Failure Inserting into the Read-Only Column Read More
SQL Server

Unable to Create Linked Server for SSAS Provider MSOLAP

April 29, 2015April 29, 2015 - by Arsalan Khan - 1 Comment

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 …

Unable to Create Linked Server for SSAS Provider MSOLAP Read More
SQL Server

SQL Agent Job Error CMDEXEC subsystem failed to load

April 15, 2015April 11, 2015 - by Arsalan Khan - Leave a Comment

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 …

SQL Agent Job Error CMDEXEC subsystem failed to load Read More
SQL Server

Creating Linked Server from SQL 2012 to SQL 2000

April 10, 2015April 8, 2015 - by Arsalan Khan - 5 Comments.

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, …

Creating Linked Server from SQL 2012 to SQL 2000 Read More
SQL Server

Install Client Tools on SQL Server Cluster

April 8, 2015April 7, 2015 - by Arsalan Khan - Leave a Comment

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 …

Install Client Tools on SQL Server Cluster Read More
SQL Server

Slipstreaming SQL Server

April 3, 2015April 3, 2015 - by Arsalan Khan - Leave a Comment

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 …

Slipstreaming SQL Server Read More
SQL Server

SQL Server in Windows Server Environment

January 5, 2015April 3, 2015 - by Arsalan Khan - 2 Comments.

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. …

SQL Server in Windows Server Environment Read More
SQL Server

SQL Server – Understanding Logical Query Processing (LQP)

December 26, 2014January 2, 2015 - by Arsalan Khan - Leave a Comment

“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 More
SQL Server

SQL Sever SERVERPROPERTY – The Unused Power

December 23, 2014 - by Arsalan Khan - Leave a Comment

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 …

SQL Sever SERVERPROPERTY – The Unused Power Read More

Posts navigation

1 2 Next

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.