Essentially, they wanted to know command which can Show Engines to Display All Available and Supported Engine in MariaDB.
SQL Puzzle – Schema and Table Creation – Answer Without Running Code
It has been a while we have a puzzle on this blog. Let us have a very simple and interesting puzzle today about Schema and Table Creation.
MySQL – MariaDB – Writing the Very First Stored Procedure
While it was easy to write a stored procedure in SQL Server, for MariaDB and MySQL one has to know a bit of syntax to write the very first stored procedure.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
SQL SERVER Management Studio – ALT Keys Trick to Select Vertical Text
Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.
SQL SERVER Management Studio – ALT + SHIFT Keys Trick to Select Vertical Text
Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.
SQL SERVER Management Studio – Removing Completion Time in Messages
I have received many curious emails and questions while working with clients on Removing Completion Time in Messages. Let us learn them today.