Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
491 reads
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
2008-09-13
491 reads
2008-09-11
63 reads
Are database professionals liable for the security of their data? Should they be? Some think so, but Steve Jones thinks this is a bad idea and we might need protection as data professionals.
2008-09-10
64 reads
As database professionals, we know that we are responsible for the security and integrity of the data in our systems. But Steve Jones wonders if you know what legal responsibilities you might have.
2008-09-09
64 reads
Where is the dividing line between work time and personal time? As more and more employees get new phones, such as the Blackberry and iPhone, is the line becoming too blurred? Are there legal implications?
2008-09-08
66 reads
More and more technology workers are being asked to sign non-compete agreements as a condition of their employment. But is that fair? Steve Jones has a few thoughts.
2008-09-06
63 reads
As Information Technology workers become more wired, with more demands, and less benefits, should they consider unionizing.
2008-09-06
496 reads
As DBAs, we don't often deal with the human interface side of the applications that we build, but it is important. And we want to be sure that anything we develop considers the end user's perspective. Steve Jones asks how much should this matter?
2008-09-04
63 reads
Blogging is increasingly becoming a part of more and more people's lives. But to what extent should it be part of your corporate image? Steve Jones has a few comments about a very interesting blog he found.
2008-09-03
48 reads
It seems a tremendous amount of data is lost every year on laptops in airports. Steve Jones talks about some of the issues with physical security and your portable computers.
2008-09-02
54 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