One of the very popular questions I receive is how to import data from Excel in SQL Server. Let us learn about that in this blog post.
SQL SERVER – Displaying Smiley in SSMS – Emoji
Recently I had an interesting conversation with my client about Emoji in SQL Server. It is possible to create your database with any emoji.
SQL SERVER – Drivers for DevOps – Efficient Monitoring
DevOps is now a part of the volubility of the DBA. Let us talk about today how Efficient Monitoring is one of the important drivers for DevOps.
MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’
One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.
Choosing a Processor for SQL Server
Choosing a Processor for SQL Server is always a challenge and I often find DBAs and organizations struggling with the same.
SQL SERVER – Drop All Auto Created Statistics
During the recent consulting engagement, I ended up a very interesting situation where I had to drop all the auto created statistics.Â
SQL SERVER – Details About SQL Jobs and Job Schedules
SQL Expert Dominic Wirth has written a very interesting script about SQL Jobs and Job Schedules. Let us learn about that in this blog post.