3 ай бұрын
6 ай бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
Пікірлер
@marciogreick4310 Ай бұрын
I am from Brazil, but i have interested, speak português, but go traduzir
@dbasdiary Ай бұрын
Request you to fill below form please forms.gle/MTi9HvmSsWsGz9scA
@abhisheksinha1473 Ай бұрын
yes
@dbasdiary Ай бұрын
Request you to fill below form please forms.gle/MTi9HvmSsWsGz9scA
@barunkumarsingh1862 Ай бұрын
Hi Sir please add table level encryption in Sybase. Also please add DB migration. All types of migration. DR setup and DR Activity. When you are planning to start Sybase Replication including HADR setup?
@dbasdiary Ай бұрын
Request you to fill below form and submit please, asked topics will be covered in more advanced sessions forms.gle/MTi9HvmSsWsGz9scA
@vishnureddy2589 Ай бұрын
Yes sir I am interested
@dbasdiary Ай бұрын
Request you to fill below form and submit please forms.gle/MTi9HvmSsWsGz9scA
@ashwin5102 Ай бұрын
Interested
@dbasdiary Ай бұрын
Request you to fill below form and submit please forms.gle/MTi9HvmSsWsGz9scA
@shubhamsyania7081 Ай бұрын
Yes interested Sir, please include all the topics
@dbasdiary Ай бұрын
Request you to fill below form and submit please forms.gle/MTi9HvmSsWsGz9scA
@khwajanamatullahseddiqy6999 2 ай бұрын
Good.
@ulysses1904 2 ай бұрын
I thought you can't create an index on an XML column either.
@dbasdiary 2 ай бұрын
Yes Sir, Any column which is of LOB data types. Possibly, I should have mentioned like one of the example. Thank you for pointing out. It could be any of these ntext, text, varchar(max), nvarchar(max), varbinary(max), xml, or image.
@manikumarK4144 3 ай бұрын
Sir, Please do a detailed full length on Sybase replication, common issue and how to fix them for all the databases.
@Shivakumar-lp1sz 3 ай бұрын
Nice Pranav!!! Very good informative on deadlocks
@vinayg1843 3 ай бұрын
Nice sir. Good information on deadlocks
@SAP_BASIS_GMK 4 ай бұрын
Are you conducting any training sessions on ase db???
@dbasdiary 4 ай бұрын
Thank you for your comment, I am going to do that very soon - working on preparing list of topics in the progressive order.
@06m51a0505 3 ай бұрын
@@dbasdiaryHow long it will take? Please let us know.
@nikolaybilov9539 5 ай бұрын
Thank you a lot. I was working with mssql for almost fourteen years until I changed my job and I started to work with Sybase now . I knew next to nothing about Sybase before. Your material is a treat for me.
@jefferyyounce5372 4 ай бұрын
Regarding market share, you may want to consider migrating to Azure sql server, SQL database since everything MS offers is in the cloud these days. Sybase rocked back in the day and I last DBA'ed it in 2017 switching back to Oracle.
@dbasdiary 4 ай бұрын
Thank you for the compliment - In my upcoming video, I have handled Deadlock and possible solution; In this video, I have covered both meaning Sybse ASE and MSSQL in parallel to see the difference and possible solution. I hope, you will like it.
@dbasdiary 4 ай бұрын
Thank you for your comment on my channel, many companies are still using Sybase ASE as their database and since migration is a lengthy and troublesome process. Good to know that you used to be a Sybase DBA back in 2017, feel free to pass your feedback on my channel. Thank you!
@user-gq1sf1yp9h 6 ай бұрын
can you suggest me any resource or book for Sybase Replication Server
@ashishmane7271 6 ай бұрын
Very nice .pls find some and post some videos on performance tunning.specially reading and understanding query plans
@dbasdiary 6 ай бұрын
Sure, will do that very soon. Thank you for commenting.
@ravijaiswal6727 8 ай бұрын
Thank you Sir , I've one question Can we assign role to database user . if yes how can we write SQL query to to list which database user has what role ?
@dbasdiary 7 ай бұрын
First thing is login, which is defined at server level, roles are also defined at server level. User is defined at database level, you need to add login as a user in any database and then grant role. Granting permission to a login and role is very similar, as far as finding permission is concerned, you can get details using sp_helprotect. Sorry for late response.
@gykg3202 8 ай бұрын
Can you make videos with more common questions?
@gykg3202 8 ай бұрын
Thank you very much for the video!
@technicalmania9471 9 ай бұрын
Thanks for picking this type of questions..Sir we need more this type of Q and A vedios
@technicalmania9471 9 ай бұрын
thanks.. could pls make vedios on performance and tuning topics
@technicalmania9471 9 ай бұрын
pls make vedio on memory and cpu configuration..
@akhileshshah4245 9 ай бұрын
So helpful...Thank you sir
@shaiknayeem7604 10 ай бұрын
Sir, how to fix end suspect mode in Sybase ....plz can you guide
@technicalmania9471 10 ай бұрын
sir pls make tutorials on SRS..it is very helpful for us...
@technicalmania9471 10 ай бұрын
pls make tutorial on SRS...
@Darshk-gy7pn 11 ай бұрын
Awesome video thanks, is there a .bak file to restore Stackflow DB? Zipped file from Brent ozar web not working for me. Thanks
@tiger1l1l77 11 ай бұрын
How to see errorlogs in Sybase ASE
@saikrishna257 Жыл бұрын
Can you do the video on resloving query slowness issue and server slowness issue in sybase ase. Plz
@pareshchaudhari6415 Жыл бұрын
There are no practical sessions. It feels your are discussing this with your colleagues who is having complete knowledge. This is not at all informative. It is like pieces of vague information. Take it as a feedback.
@dbasdiary Жыл бұрын
Thank you for your reply. I am not sure what do you mean by vague information - I have covered all these through Lab and showed how does it actually work. Have also covered point in time recovery, you can check them here - kzbin.info/www/bejne/j5WVY41ujsSbjdk If you have any specific question, please let me know - I can try answering them.
@ishu1981j Жыл бұрын
For reorg rebuild i don't think there is requirement of same size available on logsegment. Also for space availibility on default segment as per best of my knowledge it should have 120% space free when running reorg rebuild
@dbasdiary Жыл бұрын
Thank you for your comment. 120% requirement is at least and not the max. I have mentioned its safer to have that much space and also I have encountered issue myself when the space was less than that. I am sure you are referring KB 2308194. Please check wording "At Least". You can check another article by Peter www.petersap.nl/SybaseWiki/index.php/Reorg_rebuild
@rodrigojrfirmino Жыл бұрын
Thank you very much, it must be over 15 years since I've restored a database.
@Rajesh-rg6fw Жыл бұрын
Do you think dba career has any future? Specially sql dba and Azure sql dba? And what's next after this
@dbasdiary Жыл бұрын
Thank you for your comment. DBA certainly has bright future, only concern is - they need to be involved in more of creative jobs and analytical jobs rather than just performing backup, restoration and maintenance job as these will be taken care by automation and Cloud.
@Rajesh-rg6fw 11 ай бұрын
@@dbasdiary Can you provide a description of "creative and analytical jobs" and shed some light on the nature of the tasks and responsibilities associated with these roles?
@mamidulislam1963 Жыл бұрын
I have found you 🙏
@dbasdiary Жыл бұрын
I hope you find the content useful.
@wolverine008 Жыл бұрын
Make presentation not only theory works
@vimalprince4467 Жыл бұрын
wow. Didn't know we need to know these as a SQL DBA. I'm going to start learning about index. Thank you.
@dbasdiary Жыл бұрын
Glad it was helpful!
@govind3850 Жыл бұрын
Thank you so much for the answers.
@dbasdiary Жыл бұрын
You are so welcome!
@saikrishna257 Жыл бұрын
Can you do the video on hadr setup
@saikrishna257 Жыл бұрын
Can you do video on hadr setup
@princeaijaz Жыл бұрын
I have Adaptive Server Enterprise/16.0 SP02 PL08 and when i enable trunc log on chkpt=True. Can we perform Point in time recovery?
@dbasdiary Жыл бұрын
You may perform point in time recovery using cumulative backup along with full backup however stopat function won’t be available. Trunc log on checkpoint will be a concern for taking Tran backup.
@MrsBestYT Жыл бұрын
Very good sale offer
@dbasdiary Жыл бұрын
Thank You!
@jaganathanramamurthy1433 Жыл бұрын
Thanks a lot
@chandrakantamohapatra3437 Жыл бұрын
I want to take online class for more about Sybase
@ramyanarla4468 Жыл бұрын
Please explain architecture of Sybase
@dbasdiary Жыл бұрын
Sure, will do in upcoming video. Request you to check other videos in the meantime and if you like then please like and subscribe to my channel.
@nandkumargaikwad9014 Жыл бұрын
very nice , lengthy ,tricky but finally understand... thank you sir.. indexing is very important.. in DQL queries...
@xdhitalks4900 Жыл бұрын
Hello Sir, can you make a video on implementing integrated solutions components for Medicaid sites? as well as about data validation
@PakkaLogic Жыл бұрын
Hi Pranav, Could you please make videos from scratch to advanced level (architecture till adavanced performance tuning and writing stored procedures, triggers, cursors) one by one.
@dbasdiary Жыл бұрын
Sure, will make few videos on architecture and other concepts. In the meantime, you may go through video on how to design index and check the validity of it, also approach to design an index - kzbin.info/www/bejne/gmGvmomAlLRqqs0
@xdhitalks4900 Жыл бұрын
This is amazing! Can't thank you enough!
@xdhitalks4900 Жыл бұрын
Looking forward to the Mock interview sessions. It will be highly appreciated.
@xdhitalks4900 Жыл бұрын
You are absolutely the best. This video has been very helpful. Please make a video based on Store Proc and Triggers too pls
@nandkumargaikwad9014 Жыл бұрын
PERFECT CONTENT WITH GOOD EXPLANATION, THANK YOU SIR .
@antoniojapasepulveda311 Жыл бұрын
Wow the information is very useful, thanks for sharing.
@jyl2002 Жыл бұрын
Do you have a website or something?