Recently one of my oldest clients asked me a very interesting question about a table variable and SELECT INTO. Let us learn about it.
How to Join Two Tables Without Using Join Keywords? – Interview Question of the Week #266
Question: How to Join Two Tables Without Using Join Keywords?
Answer: In my life, I have attended many interviews as an interviewer.
SQL SERVER – Import Data from Excel
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:
SQL SERVER – Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group
This database is encrypted by the database master key, you need to provide a valid password when adding it to the availability group.