tl;dr There is no easy answer. But it’s important. It can be really challenging to work efficiently in a world where not only is the hosting environment typically a hybrid of on-site, off-site, public and private cloud configurations, managed and self-managed services… but also where you have multiple databases gathering different bits of information and you’re in a position to […]
SQL Server
The Magic of Word Vectors
In a nutshell, word vectors represent semantic meanings of natural language words, encoded in numbers. This looks a bit different from traditional representations of words, but this is what makes human language understandable to machines. Visually, a vector space of words can be imagined as a cloud in which words with similar meanings are located nearby. It is important to...
Categories of Database and Database Users – Part 2
Database Management System (DBMS) Architecture The three (3) significant features of the database approach are: (1) Insulation of programs as well as information program data in addition to program operation independence. (2) Assistance of multiple user views; and (3) Usage of a catalog to keep the database description (schema). In this part the architecture for database systems is described, known...
SQL Injection – More tools…
It’s incredible to me when you sit and watch the injection attempts against your public web properties. I realize that most are bot-oriented attempts, that there aren’t people sitting at the other end of most of those connections (no one types that stuff in, give me a break)… but still, someone felt that was a better use of their time […]
Helping a Local Business Become More Visible
What is your process for helping a local business become more visible? As a business consultant, I normally start off with a discovery session to clarify the client’s business goals. Each client’s process would be unique but generally covers the below steps. Research Phase · An initial discovery session to clarify client’s business goals · Market research and analysis that...
Tips for designing SQL Server 2017 tables (Part 1)
Tips for designing SQL Server 2017 tables (Part 1) Avoid using CLR user-defined data types. SQL Server 2017 supports the CLR user-defined data types. These data types allow implement database data types in any of the languages supported by the .NET Framework CLR. Because using these data types usually provides worse performance than internal SQL Server data types, and you...
Categories of Database and Database Users – Part 1
Database User Interface and Database End User There are four (4) unique kinds of database – framework clients, separated by the manner in which they hope to communicate with the framework. Various kinds of user interfaces have been intended for the distinctive kinds of clients. 1. Naive clients are unsophisticated clients who cooperate with the framework by invoking one of...
When to Conduct a Project ‘Lessons Learned’ Session
Does your evaluation need to be done after every successful or failed project to see if the methods used need to be changed? The short answer is “YES” Some people call them Lesson Learned Sessions. Some people call them Post Mortems. Whatever you call them – I recommend have mini-evaluations after each major milestones or iterations (versus waiting until the...
Tips for using SQL Server 2017 configuration options (Part 2)
Tips for using SQL Server 2017 configuration options (Part 2) Consider changing the ‘fill factor’ option to the appropriate value. The ‘fill factor’ option specifies how full SQL Server 2017 will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows...
Tips for using SQL Server 2017 configuration options (Part 1)
Tips for using SQL Server 2017 configuration options (Part 1) In this article, you can find the description of some useful SQL Server 2017 configuration options with the examples how to make it by using the sp_configure system stored procedure. Note. Because setting up some SQL Server 2017 configuration options can degrade performance you should change these options very carefully...