Don Castelino

Troubleshooting Query timeouts in SQL Server

Hello all, While working with SQL Server, one of the common issue application teams encounter is...

Date: 10/12/2018

Connection timeout and Command timeout in SQL Server

Hello all, While working with SQL Server, one of the common issue application teams report is...

Date: 10/11/2018

Rapid growth of Tempdb on AlwaysOn secondary replica due to version store

Hello all, Recently I had worked on an interesting issue with rapid growth of Tempdb on AlwaysOn...

Date: 08/04/2018

SQL Performance troubleshooting guide: A walk through

Hi all, , This article gives a high level view of isolating SQL Performance issues and logical...

Date: 08/04/2018

Setting up ASP.NET session state with SQL In memory OLTP and AlwaysOn database

Hello all, Recently I had worked on a requirement of achieving high availability for asp.net...

Date: 03/06/2018

Login failed in SQL Server due to SSMS Intellisense

Hello all, Recently, I had worked on an interesting Login failed error constantly getting reported...

Date: 02/27/2018

SQL database engine service startup failure: Troubleshooting Checklist

Hi all, In this article, we are covering the common scenarios of SQL Service startup failures and...

Date: 02/27/2018

Operating System Best Practice Configurations for SQL Server

Hi all, In this article, we are covering few important Operating System (Windows) best practice...

Date: 02/01/2018

SSIS Package Data flow Execution Slowness Troubleshooting

Hi all, In this blog, we are covering "SQL SSIS package data flow execution slowness"...

Date: 01/30/2018

Isolating SQL Performance Issues due to slow Disk IO subsystem

Hello all, In this blog, we are covering few checklists to identify and isolate disk IO...

Date: 01/29/2018

Database File movement in SQL AlwaysOn Availability group: A walk-through

Hello all, In this blog, we are covering the scenario of moving the database files of AlwaysOn...

Date: 01/23/2018

Migrating SAP ASE database to Microsoft SQL Server using SSMA

Hi all, This blog covers the process of migrating SAP ASE databases to Microsoft SQL Server using...

Date: 12/12/2017

Setting up SQL Server R service (In Database) and R Server(Standalone)

Hello all, Recently, I had worked on a requirement to install R services during the...

Date: 08/31/2017

SQL High CPU troubleshooting checklist

Hello all, In this blog, I am covering the scenario of an approach to troubleshoot "SQL Server...

Date: 07/30/2017

Troubleshoot SQL Query Performance Issues Using QUERY STORE

Hello all, Query Store is a very powerful SQL engine feature available in SQL 2016 designed to...

Date: 07/27/2017

SQL Connectivity troubleshooting checklist

Hello all, During daily operations with SQL Instances, DBA/Application teams frequently encounter...

Date: 07/27/2017

Migrate SQL database from On-Prem to Azure using SQL Database Migration Wizard tool

Hello all, In this blog, I am covering the scenario of migrating the SQL Server database from On...

Date: 12/23/2016

Migrating database from AlwaysOn AG to another with JoinOnly option

Hi all,  In this blog, I am covering a scenario of migrating a SQL database from one AlwaysOn...

Date: 10/07/2016

Enabling client side SSL encryption to SQL Server

Hello all, In this blog, I am covering the scenario of enabling SSL encryption on the client while...

Date: 04/28/2016

Troubleshooting IIS request performance slowness issues using FREB tracing

Hello all, In this blog, I would like to cover the scenario of troubleshooting web application page...

Date: 04/28/2016

Network Error while accessing login page of an application hosted on IIS

Hello all, In this blog I have covered the scenario where IIS site was not loading and the steps I...

Date: 04/05/2016

Common ‘SSPI handshake failed’ errors and troubleshooting

Hello all, I came across a scenario where System Center monitoring tool was constantly reporting...

Date: 02/11/2016

SQL SSMS not listing MSDAORA provider when connected to 64 bit instance

Hello all, Recently I had worked with the application team on a requirement of setting up Linked...

Date: 01/07/2016

SQL Server: Impact of renaming the partitioned table on data

Hello all, Recently I helped an application team to rename a partitioned table of a production...

Date: 12/15/2015

SSIS package execution failure when SSISDB is configured with AlwaysOn

Hello all, Recently I worked on an interesting issue with SSIS package execution issue. In this...

Date: 08/21/2015

Database Mirroring Configuration Failure scenarios

Hello all, In this blog, I am covering few scenario's that I have encountered while configuring...

Date: 07/30/2015

OPENDATASOURCE query execution error while using SQL public account

Hello all, Recently, I was trying to load data from an Excel file without having SysAdmin rights. I...

Date: 07/21/2015

SQL Server Report Execution Fails with "rsRenderingExtensionNotFound" error.

Hello all, Recently, I came across a scenario with a report execution issue. In this blog, I would...

Date: 07/14/2015

Report Server database migration fails at "Setting DSN" step

Hello all, Recently I worked on a scenario where the requirement was to migrate the ReportServer...

Date: 07/02/2015

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

Date: 12/02/2014

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

Date: 10/24/2014

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

Date: 10/06/2014

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

Date: 08/25/2014

Issues in installing SQL 2012 Shared features and connectivity through SSMS.

Recently I worked on an intersting scenario where the SQL Server 2012 shared features installation...

Date: 02/19/2013

Useful information on DB mirroring

Some factors to be considered while setting up DB mirroring Database Mirroring is a software...

Date: 02/19/2013