A robust Python script that converts Excel (.xlsx, .xls) and CSV files to T-SQL INSERT statements, ready for execution in SQL Server or Azure SQL Database.

Windows may get all the attention, but when you want to get real work done, you turn to the applications that run on it. And if you use spreadsheets, that generally means Excel. Excel is, of course, ...

Moving information from an HTML form into a database is a two-step design process. First, create an entry HTML form capable of passing information to a secondary file. Next, create a Hypertext ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

I am a red team operator, and a security enthusiast I write blogs and articles related to cyber-sec topics. I am a red team operator, and a security enthusiast I write blogs and articles related to ...