Twitter, John, Building a Blog and #MEME15
I saw an interesting post this morning care of the micro-blogging/social networking site twitter that really got me thinking about...
2012-01-15
1,459 reads
I saw an interesting post this morning care of the micro-blogging/social networking site twitter that really got me thinking about...
2012-01-15
1,459 reads
We’ve all have service accounts, application accounts, sysadmin and domain admin accounts and other privileged shared accounts on our systems....
2012-01-10
633 reads
It’s always handy to know if there any problems with your servers before you get into work in the morning....
2012-01-09
651 reads
I was reading this article about internet usage by staff who work for local authorities in Wales http://www.bbc.co.uk/news/uk-wales-16394916 The content...
2012-01-06
942 reads
Today is the first day of 2012 and some commentators and bloggers in the SQL Server blog space use this...
2012-01-01
1,078 reads
Image: ponsuwan / FreeDigitalPhotos.net
As 2011 draws to a close and as people look forward to evening of partying and celebrating I’d...
2011-12-31
1,951 reads
This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...
2011-12-19
1,189 reads
Written by Ian Treasure
Gethyn posted on the use of execute permissions a while ago (db_executor at http://www.gethynellis.com/2010/04/dbexecutor-role.html). Briefly, this approach...
2011-12-15
1,376 reads
A while back I started posting some contractor related articles.The articles were mainly for the those people that wanted to...
2011-12-14
595 reads
I haven’t posted for a while but thought I’d dust off the blog and get a post out. I have...
2011-11-24
4,260 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
Hi, hoping someone can help. We're in the process of migrating to a new...
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