Question: What is the Difference between TRUNCATE and DELETE in SQL Server?
How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117
Question: How to Change Owner of Database in SQL SERVER?
SQL SERVER – Unable to Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types
Learning never stops for me with SQL Server. Even though I have written articles to solve many issues, I still get pinged from various clients and I find one new thing every day. In this blog post we will learn how to fix the error related to installing the service pack in the cluster.
SQL SERVER – Script to Audit Login and Role Member Change
Once there was a security breach on my client machine and they wanted to know who made changes to the SysAdmin role. They contacted me and my first question was that, are you are auditing such changes and as expected answer was No. I gave them answer that nothing can be done as a consultant. They still wanted my suggestion to prevent this in future. So, they want to track if someone does such things in future. Let us see a script to audit login and role member change.
How to Find Median in SQL Server? – Interview Question of the Week #116
Question: How to Find Median in SQL Server?






