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 – TempDB and Trace Flag 1117 and 1118 – Not Required
Yes, it is true that from SQL Server 2016, Trace Flag 1117 and 1118 are not required. Recently I was hired by a large banking firm to help.
SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It
In this blog, I would share my knowledge about how to fix error 15580 – Cannot drop the master key because dialog “GUID” is encrypted by it.
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.
SQL SERVER – Unable to Allocate Enough Memory to Start ‘SQL OS Boot’. Reduce Non-essential Memory Load or Increase System Memory
In this blog, I would share my learning about error “Unable to allocate enough memory to start ‘SQL OS Boot’. Let us learn the workaround.
How to Forecast the Size of Restore of Backup in SQL Server? – Interview Question of the Week #265
Question: How to Forecast the Size of Restore of Backup in SQL Server?
Answer: Recently, I had discussed this in consulting engagement: