ExpressProfiler now is digitally signed.
Today I've replaced download package for ExpressProfiler with digitally signed version of standalone application and Ecosystem installation.
Unfortunately I did something wrong and...
2014-05-24
593 reads
Today I've replaced download package for ExpressProfiler with digitally signed version of standalone application and Ecosystem installation.
Unfortunately I did something wrong and...
2014-05-24
593 reads
I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can...
2014-05-20
659 reads
I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...
2014-05-15
599 reads
If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool...
2014-05-11
690 reads
In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).To be honest, the first version...
2014-05-04
520 reads
In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.Eg - ST012 "Consider using temporary table instead of...
2014-04-27
553 reads
Today we released new version of SQL Code Guard - 2.4.5222There are many fixes and improvements, some new rules were added.Full...
2014-04-20
323 reads
A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...
2014-02-24
812 reads
I realized I never created a post to show how to deploy Terraform from...
By Steve Jones
I’m late to the party this month. Taiob Ali has a great invite for...
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
Comments posted to this topic are about the item Building a Database Dashboard with...
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly...
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