I have received a very simple but interesting question by one of my earlier clients about how to count NULL values from the column.
SQL SERVER – Install Error – The Account Running SQL Server Setup Does Not Have Administrator Rights On the Computer. To Continue, Use an Account With Administrator Rights
In this blog, I would share the steps to identify and fix error – The account running SQL Server Setup does not have administrator rights on the computer.
SQL SERVER – Truncating Data and ANSI_WARNINGS
Today’s blog subject of Truncating Data and ANSI_WARNINGS was accidentally discovered while working on the Comprehensive Health Check.
SQL SERVER – SELECT INTO a Table Variable in T-SQL
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.