You could use TRY_CONVERT(int, field) to ensure that you have an integer to work with in your query. If it fails to convert you'll get a null rather than an...

For Oracle to SQL Server ETL we use

CAST(DOB AS DATE DEFAULT NULL ON CONVERSION ERROR) as "DOB"

in the select query and load to date field if no time required. This...

Apart from the server installation, you need to set the correct server version in the project properties of your SSIS project in Visual Studio before deploying the project. Right click...

As another over 65 with many years of SQL developing and DBA, I'm now lucky enough to work for a company that has decided to go over to AWS, S3...

With work life being building a new data hub in AWS S3 and Athena when my skills were focused on SSIS and SQL for the on-premises SQL Server based hub,...

Good to see a post highlighting the basics for those newer to SQL Server.

Server registration was a life saver back in 2004-2015 when I was DBA for many SQL Servers...

I'm not a DBA. I have been officially a DBA and before that I started as a developer who had to be the DBA because no-one else would. Recently I've...

Is it a modern thing to require homework for an interview? In forty years in the software industry, the only interview that has asked me to prepare and present anything...

Reading these posts makes me feel better about only having SQL Server 2016 (and an exit plan for it) and procrastinating over upgrading my Windows 8.1 tablet because it works...

Check the schedule on the SQL agent job to make sure it isn't running repeatedly.

Check the advanced settings for the job step and make sure that the job is set...

I've never been across the pond to the USA but I hate pubs here in the UK where the music is too loud and everyone is having to talk loudly...

As a data engineer currently involved in a pilot for migrating an on-premises SQL Server corporate data store to a cloud AWS data lake with S3 storage and Athena querying,...

You set which version of SQL Server you are deploying the package to in the project properties.

Open SSIS solution in visual studio and right click the project name and select...

I had to do this recently in SQL Server 2016 and used STRING_SPLIT which was far simpler and seems to keep the order anyway.

It's another day when I think SQL Server Central must have been spying on us, producing such on-topic editorials, as here I am, old enough to claim my UK state...