I have written a python script that reads files one-by-one out of a blob storage account, reformat them into a data frame and then writes them to a SQL Server DB using SQL Alchemy for daily log files.

In some circumstances such as this, schema in read_sql_table() is being interpreted as a database name + schema, rather than just a schema. This results in a use <database> statement - and as ODBC ...

Interviewing for developer jobs with an SQL Server specialism can be daunting, but if you know what questions you’ll likely face, you can prepare to answer them in advance. Here are just 10 questions ...