I am involved in the Comprehensive Database Performance Health Check. Today we will discuss how we can remove triggers for the Delete statement.
How to Capture Deleted Rows Without Trigger? – Interview Question of the Week #297
Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.
How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242
Question: How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? Let us see the answer of this question in this blog.
SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name
Before you read further, let me warn you that Logon triggers are potentially evil and might also end up locking everyone out of the instance. Be careful! Don’t just copy paste the code and create the trigger, you might end up in downtime to fix the issue.
Recently, one of my blog readers sent an email to me asking a quick suggestion. He informed me that he is using a LOGON trigger to control the access to the server. Here is the code for the trigger.
SQL SERVER – Nested Triggers – Trigger Calling Another Trigger Error
Recently I have received a very interesting question in an email. The user wanted to know how will trigger behave when there are nested triggers. In an email, he described a scenario where trigger called another trigger. I really liked the question and immediately answered in the email as well. However, I believe many others may have the same question, so decided to write this blog post with an example.
Oracle to SQL SERVER Migration – Triggers Used While Migration
I am a big supporter of working on something that I get used. This is a trend I see that most of us are used to. When was the last time you switched loyalty from one phone to another? I know most of us have multiple devices that we use, but rarely that I have seen switch from an Android to iPhone to Windows to other devices. These are second to human nature. In the past 3+ years, I have been a big-time user from using Android phones. The model that I pick up depends on the price, hardware specification, specific features of my like and more. Let us learn about Oracle to SQL migration.
SQL SERVER – How to Avoid Triggers for Multiple Row Operations in a Table
Customers have a unique way to give you challenges that you never faced. It was one of those evenings that I was working late night on some SQL activity when I received a mail from one of my very old customers. It is rare that I get a ping from them and I was surprised at what had gone wrong. As I started to chat with them, he didn’t know I had recently moved to consulting. This got him double excited and I was unaware to why such a reaction. Your best customers are your best well-wishers too. Let us read about How to Avoid Triggers for Multiple Row Operations in a Table.