The Reading Poll
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
2009-07-24
811 reads
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
2009-07-24
811 reads
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
2009-07-23
523 reads
Gordon Bell works for Microsoft Research and always asks Steve Ballmer for a database. What's wrong with SQL Server?
2009-07-22
689 reads
It seems that many meetings in corporate settings are wastes of times. Can they be better? Steve Jones has a few ideas that might help make them more productive.
2009-07-21
873 reads
Certifications are being devalued in the IT industry because of cheating and braindumps. Steve Jones thinks we need to re-examine how we view them.
2009-07-20
940 reads
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
2009-07-16
914 reads
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
2009-07-15
506 reads
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
2009-07-14
719 reads
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
2009-07-13
660 reads
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
2009-07-10
676 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