2021-05-26
417 reads
Python
Dimensionality Reduction Techniques - PCA, Kernel-PCA and LDA Using Python
Summary In this article, we will be looking at some of the useful techniques on how to reduce dimensionality in our datasets. When we talk about dimensionality, we are referring to the number of columns in our dataset assuming that we are working on a tidy and a clean dataset. When we have many columns […]
2021-05-24
3,975 reads
Should You Learn R or Python?
Both Python and R have become very popular languages in the last few years, especially among data professionals. Which should you learn or use? Steve has a few thoughts.
2021-05-21
404 reads
2021-05-12
475 reads
2021-04-28
474 reads
2021-04-21
409 reads
2021-04-07
443 reads
2021-03-24
147 reads
Comparing Two Geospatial Series with Python
Learn how to use Python and pandas to compare two series of geospatial data and find the matches.
2021-03-23
5,259 reads
2021-03-10
369 reads
Blogs
Terraform Commands
I realized I never created a post to show how to deploy Terraform from...
T-SQL Tuesday #189–AI and your Career
By Steve Jones
I’m late to the party this month. Taiob Ali has a great invite for...
TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
Forums
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
Handcrafted Drinkware Inspired by Nature
We offers a collection of handcrafted drinkware that reflects the beauty and calm of...
CDC job running for 17 days?
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
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