Friend of Redgate 2019
This year starts with a good news:
Here is the list of people in the directory.
Stay tuned!
2019-01-25
178 reads
Alessandro Alpi
Managing migrations with RedGate SQL Source Control 5
This is a good day for me. I’ve finally tried the improved migrations feature in the latest version of RedGate SQL Source Control ...
2016-07-07 (first published: 2016-06-30)
2,762 reads
SQL Server 2016 CTP3 – new features and the JSON support improvements
SQL Server Community Technology Preview 3 has been released some days ago.
The SQL Server team added a lot of features...
2015-11-09
648 reads
How to manage SQL Server security with SQL Source Control
One of the most common issue you can find when source controlling the database is about the security. How to manage...
2015-08-20 (first published: 2015-08-15)
2,160 reads
How to manage SQL Server security with SQL Source Control
One of the most common issue you can find when source controlling the database is about the security. How to manage...
2015-08-15
400 reads
Unit testing with SQL Server article on SQLServerCentral.com
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
621 reads
Unit testing with SQL Server article on SQLServerCentral.com
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
252 reads
A 2015 full of DLM
After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:
PASS Italian Virtual Chapter, April 14. I’ll demonstrate...
2015-03-24
524 reads
A 2015 full of DLM
After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:
PASS Italian Virtual Chapter, April 14. I’ll demonstrate...
2015-03-24
267 reads
SQL Saturday Parma – English Slide decks available to download
My SQL Saturday Parma slide decks are available to download on SlideShare.
The main topic of those presentations is database lifecycle management (DLM)...
2014-11-26
7 reads
Blogs
PASS Data Community Summit LinkedIn Contest
By Brian Kelley
If you're not having success in convincing your organization to send you to this...
Boost SQL Server Security with gMSA: Real-World Examples & PowerShell Scripts
By Rohit Garg
When deploying SQL Server in enterprise environments, choosing the right service account model is...
Andreas Wolter on Evading Data Access Auditing
By Brian Kelley
There are always bad actors who will seek to get access to and, likely,...
Forums
Determining the Updated Columns
Comments posted to this topic are about the item Determining the Updated Columns
Carrots and Sticks
Comments posted to this topic are about the item Carrots and Sticks
Replace with like join
I am trying to create and Update query based on a like join. Is...
Question of the Day
Determining the Updated Columns
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers