Adding new files to a log-shipped database (SQL Spackle)
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,588 reads
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,588 reads
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
2024-08-09 (first published: 2011-01-12)
45,794 reads
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
The post Availability Group issues fixed...
2020-08-17 (first published: 2020-08-06)
842 reads
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
The post Availability Group issues fixed...
2020-08-06
288 reads
Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.
2020-08-06
14 reads
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The post Using Google Chrome...
2020-02-28 (first published: 2020-02-18)
9,376 reads
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
The post Using Google Chrome...
2020-02-18
33 reads
In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.
2020-02-18
4 reads
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
12 reads
Are you a speaker in SQL Server topics? Come on out to Richmond, VA to speak to our user group. There are several topics that we are interested in...
2019-12-10
5 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