1508, 2020

How to Fix [ODBC Driver 13 for SQL Server] SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]

Paopatsin/ August 15, 2020/ Database, MS SQL, Technology

Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) As a Database Administrator, I’m always a fan of CLI (Command-Line Interface) to run some adhoc administrative commands in administering Microsoft SQL Server and Database. In my case I often use osql or sqlcmd. SQL CLI osql allows you to enter and run Transact-SQL statements, system procedures,

1508, 2020

Extract Table Fields from SQL Database

Paopatsin/ August 15, 2020/ Database, MS SQL, Technology

Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64) Although, you can generate table scripts easily using built-in context menu from SQL Database Management Studio, you may want to do it your own way.. the HARD way but FUN way. In this post, we will do that, we will extract the table definition of our database

1106, 2020

How to generate MD5 in Windows

Paopatsin/ June 11, 2020/ Tech Nuggets, Technology

Please read our Disclaimer Works With-Windows 10 Version 1903 OS Build 18362.836 There are times when you need to generate an MD5 to know if something you’ve downloaded from the internet was not altered from the original. MD5, being one of the most commonly used cryptographic hash function has its own throes and limitations. Nevertheless, having the tools will always