Implementation of SMB file share to host SQL databases: A walk-through

Recently I worked on a scenario where the requirement was to host more than 25 SQL server instances on a cluster. SQL supports 50 instances on a failover cluster if SMB file shares are used to host the databases. In this blog, I have shared the steps to implement the SMB file share as a…

0

Tips and Tricks to fix SQL Connectivity Issues

Hello all, Have you had any issues connecting to the SQL instance from an application or remote machine? Well, don’t worry because in this blog, I have: Explained a few common scenarios; Approached these connectivity issues; and Included fixes for these issues. To illustrate the SQL connectivity issues, I have installed SQL 2012 named instance…

14

Data Migration failure from Oracle to SQL using SQL Server Migration Assistant tool

Hello all, Recently, I worked on an interesting case for data migration from Oracle to SQL Server. I got the error message below at the time of migration.     PROBLEM DESCRIPTION Getting the error, “The given value of type String from the data source cannot be converted to type bit of the specified target column”,…

5

Performance Monitor user-defined data collector set doesn’t collect 32-bit SQL data when installed on a 64-bit OS

Hello All, Recently, I worked on an interesting issue with SQL data collection for user-defined data collection set. And I would like to share my thoughts on the workaround available to address this issue.   Problem description When a 32-bit SQL Server is installed on a 64-bit Windows Operating System, Performance Monitor user-defined data collection…

2