Tools for development

SQLServerCentral Article

Using Registered Servers in SSMS

  • Article

One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection dialog. This post looks at this feature and how […]

5 (2)

You rated this post out of 5. Change rating

2024-07-31

2,315 reads

SQLServerCentral Article

Database Dashboards in Azure Data Studio

  • Article

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the database dashboards and how you can customize them. The other articles in this series on ADS works […]

5 (1)

You rated this post out of 5. Change rating

2024-05-03

2,835 reads

SQLServerCentral Article

A First Look at SSMS 20

  • Article

Recently Microsoft released SQL Server Management Studio (SSMS) v20.0, which is a major release of the primary tool that many of us use to work with SQL Server. Over the last few years, the tools team at Microsoft has worked to separate the tools from the various editions, giving us separate SSMS downloads. There have […]

5 (4)

You rated this post out of 5. Change rating

2024-03-27

11,584 reads

SQLServerCentral Editorial

How Often Do You Update SSMS?

  • Editorial

I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a quarter. As I checked my desktop, I saw I was still on 19.1 (my laptop […]

You rated this post out of 5. Change rating

2024-02-02

307 reads

SQLServerCentral Article

Server Dashboards in Azure Data Studio

  • Article

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the server and database dashboards and how you can customize them. Another article will cover the Database dashboards. […]

5 (1)

You rated this post out of 5. Change rating

2024-03-28 (first published: )

3,646 reads

Blogs

Monday Monitor Tips: Tracking The Cost of Instances

By

One of the things that I’ve been asked in every operations situation is what...

Social Anxiety and Events Like the PASS Summit

By

If you are an introvert like me, events like the PASS Summit can call...

Thoughts on AI Data Infrastructure Field Day #1

By

On October 2nd and 3rd, I took part in an amazing event called AI...

Read the latest Blogs

Forums

Building Pivot from SSIS with growing list of Month Columns

By Reh23

Good afternoon, I have an SSIS package which loads raw records into a sheet...

Two queries or one?

By Steve Collins

The setup: 3 tables: core_users, core_roles, and core_user_roles.  core users is the "base" table,...

Best Clustered Index Configuration for Partitioned Multi-Tenant Table with RLS

By Jonathan AC Roberts

I’m working with a SQL Server database that supports a multi-tenant application. We have...

Visit the forum

Question of the Day

Comparing Images

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);
GO
I 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