I'm one of the older ones who could retire, but this is happening in my world as our SQL Server databases are being replaced by the cloud and AWS S3...

UK National Insurance numbers (equivalent of US Social Security Number) are also said to have duplicates, especially from the early years of their issue.

One of our databases on a clustered server was stuck in recovery mode last week. There had not been any restoring from backup so the solution was to fail over...

Yes use Registered Servers (View menu, Registered Servers) and collect  them into Registered Server Groups like folders for files.

You can save passwords with each server registration so that it just...

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...