Image is Everything
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
2009-01-07
416 reads
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
2009-01-07
416 reads
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
2009-01-07
999 reads
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
2009-01-06
136 reads
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
2009-01-05
798 reads
Steve Jones talks about one of the least favorite things for IT people: documentation. How much do you really need to do?
2009-01-04
742 reads
This Friday, a guest poll and editorial from Adrian Nichols wondering about the value of experience in a particular area.
2009-01-01
135 reads
It's the first day of 2009 and Steve Jones gives a few predictions for the new year in this editorial.
2008-12-31
79 reads
Steve Jones looks back at the past year and database news that has occurred.
2008-12-29
71 reads
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
2008-12-28
945 reads
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
2008-12-27
746 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