In this post, we shall cover password policy of SAP Sybase ASE in depth. Password policy is an integral part of Database Administrator job – it is getting more and more traction after incident of hacking has increased post pandemic. Security department wants to ensure that password matches to best possible stringent norms and it …
Indexes are very crucial part of a table and to be able to decide on which index is required, which one should be dropped and which one should be changed is one of the most important part of DBA’s job, especially if you are into performance tuning of an application connecting to your database. In …
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 »
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 »
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 »
Running database backup is one of the most critical part of DBA’s job. If you don’t have RTO and RPO defined and backup job configured to meet those objectives then the job could be at stake. When its daily job, we need to ensure that the backup(dump) process could finish as fast as possible. When …
How to Expedite SAP Sybase ASE Backup(Dump) Process Read More »
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. …
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 »
You would have heard from many in DBA community or in development community that if there is index seek in the execution plan, its always good. Lets see today whether its a myth or fact. To clarify further, Index seeks are mostly good when it is with equality operator however when it comes to inequality …
Index Seek is Necessarily Always Great – Myth or Fact? Read More »
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 »