Upcoming SQL Saturday Precon Sessions (Update!!!!)
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
934 reads
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
934 reads
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
9,020 reads
Recently, I was working with a customer designing Power BI reports and dashboards. Everything was going great until she asked...
2016-01-25
2,725 reads
So two new exciting capabilities were announced recently in Power BI. One involved Excel and the other SSRS, but they...
2015-12-17 (first published: 2015-12-14)
1,845 reads
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. ...
2015-12-03
900 reads
I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted...
2015-12-09 (first published: 2015-12-02)
4,211 reads
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturdayfor the first time...
2015-07-24 (first published: 2015-07-20)
2,101 reads
After a few years away, the Baton Rouge SQL Saturday group has finally allowed me back at their annual event...
2015-07-15
1,340 reads
Join me for a full day of Power BI in Baton Rouge, LA and Downers Grove, IL, where I will teach...
2015-04-13
1,397 reads
2015-04-10
1,108 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