Home

Re-Initialize Replication for Secondary with MSA Online

How to Re-Initialize Replication for Secondary with MSA Online

In this post, we shall talk about reinitializing the replication to warm standby when it is already up and running for MSA(Multiple Subscriber Agent) to reporting or some other server. Actually, I faced this issue few days ago when we had commissioned a new reporting server and wanted to offload the reporting load to this …

How to Re-Initialize Replication for Secondary with MSA Online Read More »

Important 15 Sybase ASE DBA Interview Questions and Answers

Important 15 Sybase ASE DBA Interview Questions and Answers

I thought of doing another session for Sybase ASE DBA interview Questions and Answers inline with SQL Server DBA interview Questions and Answers and share with you. These questions are of expert levels and check your overall understanding as well as troubleshooting of SAP Sybase ASE database and approach towards solving issues. Interview typically lasts …

Important 15 Sybase ASE DBA Interview Questions and Answers Read More »

MS SQL Server DBA Interview Questions and Answers For Experienced

MS SQL Server DBA Interview Questions and Answers For Experienced

I thought of doing one session for SQL Server DBA interview Questions and Answers and share with you. These questions are of different levels and check your overall understanding of SQL Server database administration and approach towards solving issues. Interview typically lasts for 20-40 minutes, nobody can find everything about candidate however these questions and …

MS SQL Server DBA Interview Questions and Answers For Experienced Read More »

Thought of Those Queries Where No Index Recommendation from SQL Server? Still Helps in Big Way!

Thought of Those Queries Where No Index Recommendation from SQL Server? Still Helps in Big Way!

As you know Index recommendation is very handy when you execute a query and check the execution plan and SQL Servers suggest to create an index and this much gain will be there in query performance, Its not always correct however very helpful. All the suggestions shouldn’t be implemented neither it should be ignored completely. …

Thought of Those Queries Where No Index Recommendation from SQL Server? Still Helps in Big Way! Read More »

Error 226 'xxx' command not allowed within multi-statement transaction

Error 226 ‘xxx’ command not allowed within multi-statement transaction

In the earlier post Error 2762 The ‘xxx’ command is not allowed within a multi-statement transaction in the database, we covered how to find a work-around for solving multi-statement transaction error and keep it running while having option of rolling back or committing it based on the requirement and execution. Today, we will talk about …

Error 226 ‘xxx’ command not allowed within multi-statement transaction Read More »

SAP Sybase ASE - How to Add Server Entry in Interfaces File Through DSCP

SAP Sybase ASE – How to Add Server Entry in Interfaces File Through DSCP

As you know interface file holds details of servers where Sybase ASE can connect to, here we are talking about server level, we shall cover details about client side in different post. A typical interface file contains server name(could be anything as per your choice), IP or hostname of the server and port number, which …

SAP Sybase ASE – How to Add Server Entry in Interfaces File Through DSCP Read More »