I had covered set of interview questions earlier( Important 15 Sybase ASE DBA Interview Questions and Answers) and it was liked by our DBA community and have got feedback to cover few more questions and a bit challenging ones. I have compiled list of a bit tricky questions and I am sure you would like …
SAP Sybase ASE DBA Experienced Interview Questions Read More »
In this post, we would like to cover Database Backup of different types and their restoration – which one is needed when and how to use them in which sequence. In earlier post, we had covered aspects of full backup with compression, cumulative backup and tran backup (Point in Time Recovery with Cumulative and Tran …
SAP Sybase ASE Backup Restoration and Point in Time Recovery Read More »
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 »