The recent blog post on PASS.org announces that Microsoft has renewed its sponsorship of SQLSaturday events. They are even, at the own discretion, sponsor individual events with more money...
2019-08-03
26 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
34 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
175 reads
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World Tour. There will be a one-day workshop on Tuesday...
2018-11-20
12 reads
Please join the Power BI User Community in Dallas on Nov 27th through the 29th for the Power BI World...
2018-11-20
197 reads
This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is in addition to registration going up next by $200...
2018-09-19
16 reads
This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is...
2018-09-18
303 reads
The “full” PASS Summit 2018 schedule has been released. This includes the regular sessions along with the pre-conference sessions which were released a couple of months ago.
Wednesday thru Friday...
2018-09-08
27 reads
The “full” PASS Summit 2018 schedule has been released. This includes the regular sessions along with the pre-conference sessions which...
2018-09-08
221 reads
Please join me for a day of developing and deploying Power BI reports in an On-Premises environment. This event is a pre-conference session on the Friday before SQLSaturday #801...
2018-08-21
9 reads
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...
By Steve Jones
Imagine this situation, someone edits a stored procedure on a production server to “fix”...
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