Mini-Me
This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.
2008-11-19
86 reads
This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.
2008-11-19
86 reads
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
2008-11-19
1,177 reads
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
2008-11-18
89 reads
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
2008-11-17
876 reads
With people becoming smarter about technology, does it make sense for them to choose their own computer? Steve Jones thinks so.
2008-11-16
796 reads
Employers say they're looking for more ethics and morals in IT for 2009. Steve Jones hopes it's true.
2008-11-16
1,016 reads
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
2008-11-13
147 reads
Twitter is one of those interesting Web 2.0 ideas that is hard to analyze. Is it valuable? Steve Jones might have an idea for how it could be used by DBAs.
2008-11-12
810 reads
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed.
2008-11-11
1,148 reads
Are DBAs worth more to a company than other types of IT employees? Steve Jones has some thoughts about the salary ranges for DBAs today.
2008-11-10
893 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