Don Castelino

Troubleshooting Query timeouts in SQL Server

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

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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"...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] Date: 12/12/2017

Migrating On premise SQL database to Azure SQL database using DMA v3.2

Hi all, This blog covers the steps to migrate the On premise SQL Server database to Azure SQL...

Author: Don Castelino[MSFT] Date: 09/18/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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] Date: 07/27/2017

SQL Connectivity troubleshooting checklist

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

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] 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...

Author: Don Castelino[MSFT] Date: 02/19/2013

Useful information on DB mirroring

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

Author: Don Castelino[MSFT] Date: 02/19/2013