The Mysterious Case of the Missing Default Value
Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.
2017-03-24 (first published: 2015-12-01)
6,873 reads
Raul Gonzalez @SQLDoubleG
Database ownership and TRUSTWORTHY
Database ownership is an old topic for SQL Server pro's. Check this simple lab to learn the risks your databases can be exposed to.
2015-01-29
10,938 reads
2013-11-15
2,002 reads
2013-09-23
2,340 reads
Blogs
Modifying a Trigger to Capture More Info: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences
After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling...
T-SQL Tuesday #187–Solving Problems
By Steve Jones
This month we have a great invite from Joe Fleming, a first time host...
Forums
Transitioning AlwaysOn Availability Group to Synchronous Commit Mode
Hello, I have a SQL Server with an AlwaysOn configuration consisting of three replicas...
CDC & Azure Managed Instances - Performance degredation
Anyone got any good advice for performance tuning CDC on a Managed Instance? We...
The Trigger Updated Column(s)
Comments posted to this topic are about the item The Trigger Updated Column(s)
Question of the Day
The Trigger Updated Column(s)
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers