Speaking at SQL Saturday Chicago
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019. I will be presenting my...
2019-02-15
5 reads
I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on Saturday, March 23, 2019. I will be presenting my...
2019-02-15
5 reads
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...
2019-02-13
107 reads
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
5 reads
Recently I had a need to build a Power BI report for a client. This client has a multi-tenant database...
2019-02-07
814 reads
Recently I had a need to build a Power BI report for a client. This client has a multi-tenant database and their own custom web app. They want to...
2019-02-07
12 reads
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More...
2019-01-23
150 reads
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More often than not this leads to the “not seeing...
2019-01-23
2 reads
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read...
2019-01-04
148 reads
After speaking at SQL Saturday Iceland last year, which is a smaller event that I absolutely loved (you can read about that adventure here), I decided I wanted to...
2019-01-04
4 reads
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January...
2019-01-04
123 reads
By kleegeek
On October 2nd and 3rd, I took part in an amazing event called AI...
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
Comments posted to this topic are about the item Comparing Images
Comments posted to this topic are about the item Time to Change Your Team
Comments posted to this topic are about the item A Tidy Database is a...
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid FROM dbo.Image_Staging AS ist INNER JOIN dbo.Images AS i ON ist.imagebinary = i.imagebinary;See possible answers