I want to add my appreciation for all that you as a team do to run SQL Server Central and for having provided me with that backstop I needed to...

Back around the Millenium I got promoted from new developer to DBA because the server died and the previous DBA hadn't backed up Master, Model and particularly the MSDB database...

Our business made the data lake choice two years ago, just before Fabric was widely released. We were expecting Azure to be the chosen one since we were heavily Microsoft...

Here in the UK there are already enough available unions that encompass IT workers and other managerial and professional services staff and over the years smaller unions have amalgamated into...

We're using SSIS with CozyRoc components on the old warehouse and AWS tools - Step Functions and Glue with Python and Athena SQL on the new Data Lake.

The rest of...

Agree about the plagiarism - too much of it around. We have to support several pieces of anti-plagiarism software at the University to monitor students' work.

As for the date dimension,...

Call me a dinosaur if you like, but I'm 100% with Alex Gay - don't use it and wouldn't use it for code I can write myself. Nearest thing I...

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