NSA Releases Guidance on How to Protect Against Software Memory Safety Issues

The National Security Agency (NSA) has released a report of what programming languages people should use because of memory safety (leaks, exploits, etc.). The “Software Memory Safety” Cybersecurity Information Sheet highlights how malicious cyber actors can exploit poor memory management issues to access sensitive information, promulgate unauthorized code execution, and cause other negative impacts. https://www.nsa.gov/Press-Room/News-Highlights/Article/Article/3215760/nsa-releases-guidance-on-how-to-protect-against-software-memory-safety-issues/ The […]

Data Analysis: What to Learn

Applied statistics (not software, but good old math) including general understanding of machine learning (artificial intelligence). R and/or Python with libraries like NumPy and/or pandas. Structured Query Language (SQL) with a broad understanding of extensions (vendor-specific syntax) depending on the relational database management system (RDBMS) that the company (your employer) has like Oracle, MySQL, PostgreSQL […]

Get Started with a List of Reference Sites: Where to Get Help When Needed or What to Read When Bored

Get yourself a list of websites and other resources to read and for reference. The following are some recommendations. https://arstechnica.com/ https://apachefriends.org/ https://cloudsavvyit.com/ https://cnet.com/ https://dev.to/ https://freecodecamp.org/ https://mariadb.org/ https://mongodb.com/ https://mongodb.com/blog https://mysql.com/ https://news.ycombinator.com/ https://oracle.com/ https://phpmyadmin.net/ https://postgresql.org/ https://slashdot.org/ https://sqlite.org/ https://techonthenet.com/ https://techonthenet.com/sql_server/ https://techrepublic.com/ https://wired.com/

Database Administration Fundamentals (WS17SQL1007) – Day 1

We have started a new SQL course. As I explained last night, each relational database management systems (RDBMS) vendor has some proprietary syntax and tools. Therefore some code has to be converted when moving code from SQL Server to Oracle, PostgreSQL or SQLite. Some third-parties have released facilities like SQLines. If you have any questions on other systems, do not hesitate to […]

Database Administration Fundamentals (WS16SQL1006) – Day 6

We have covered parameters, functions and procedures. Do not forget that, if you are taking the certification exam, you must know about procedures. Download the class notes for day 6. Note that functions and procedures change from vendor to vendor. In this course, we are looking at Microsoft’s T-SQL for SQL Server. If anyone if […]