Data Ownership
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
75 reads
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
2008-10-20
75 reads
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-18
509 reads
With the economy slowing the the world facing a financial crisis, Steve Jones polls the man on the street this Friday.
2008-10-16
72 reads
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
2008-10-15
74 reads
Can you be too good at analyzing data? An interesting story from the financial markets.
2008-10-13
73 reads
Another spy story involving data that's not true, and perhaps not plausible, but it makes Steve Jones think about data shadows.
2008-10-11
74 reads
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
2008-10-11
469 reads
What's in a database health report? Steve Jones asks what you might want to put in one for this Friday's poll.
2008-10-09
71 reads
The state of project management for technology projects doesn't seem to be keeping up with technology itself. Steve Jones talks a little about what might be wrong.
2008-10-08
76 reads
Today Steve Jones talks about starting your own business and should you do it with online tools.
2008-10-07
65 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