Blog

Search results for: DBA

26-Jun-2014

SQL Yoga : Certificate Expired, Mirroring Stopped

Database Administrators might face this issue while certificate gets expired and database mirroring (Non domain database mirroring) gets disconnected as two servers, Primary and Secondary cannot communicate with each other. The error message can be found in Log as follows:


Message
Database Mirroring login attempt failed with error: 'Connection handshake failed. The certificate used by this endpoint was not found: Certificate expired. Use DBCC CHECKDB in master database to verify the metadata integrity of the endpoints. State 85.'. [CLIENT: xxx.xxx.xxx.xxx]
In this post, We are going to review step by step process to resolve this issue by providing renew parameters with certificate configurations.
 

SQL SERVER: Find executing queries

23-Aug-2010

SQL SERVER: Find executing queries

Recently my company owner reported that SQL SERVER is running slow. I searched for it and get following T-SQL query. SQL SERVER provides dynamic views, which contains current information about all details.

15-Mar-2010

SQL SERVER: Execute Stored Procedure when SQL SERVER is started

We have a requirements to execute Stored Procedure when SQL SERVER is started/restarted and we need to start some processes. I found that SQL SERVER provides a way to call Stored Procedure when SQL services are restarted.

SQL SERVER: SSIS - Foreach Loop Container

23-Nov-2009

SQL SERVER: SSIS - Foreach Loop Container

Today, I am going to explain SSIS For Each Loop Task. I am sure that it will be easy to configure SSIS Package with Foreach Loop task, after you read this article.

SQL SERVER SSIS: BULK INSERT Task

14-Oct-2009

SQL SERVER SSIS: BULK INSERT Task

As we have seen SSIS Data Flow TASK in previous article, today I am going to explain SSIS BULK INSERT TASK.
 

22-Oct-2009

SQL SERVER: What is SSIS?

SSIS (SQL Server Integration Services) is an upgrade of DTS (Data Transformation Services), which is a feature of the previous version of SQL Server

Community TechDays at Ahmedabad - Great Event

09-Oct-2009

Community TechDays at Ahmedabad - Great Event

There was a great event held by Microsoft and PASS (Professional Association of SQL Server) in Ahmedabad on 3rd October 2009. This was very big event where 250+ attendees attend the excellent session of Vinod KumarPinal DaveJacob Sebastian and Prabhjot Singh Bakshi. There were Four technical sessions by these excellent speakers.

18-Aug-2009

SQL SERVER: Check if Node exists in XML or not


Today, I have one requirement to check dynamically if a node exists in my xml or NOT.

22-Jul-2009

SQL SERVER: Reset Setup Values, when SQL SERVER is started/restarted

We have a requirements to clear all setup values when SQL SERVER is started/restarted and we need to setup default values to setup table.

SQL SERVER: Read values from Comma Separated variable

05-May-2009

SQL SERVER: Read values from Comma Separated variable

As we have seen, How to generate Comma separated List in SQL. Today we know, how to get values from Comma separated column. Many times developers asked, How can I read comma separated values from variable? There are many ways to get solution for this. Lets discuss about the best way, I think so. We can use XML to read values from comma separated values. XML made our life easy.