This question came from a small business owner. How can a business owner personalize every experience people have with your brand? What are your rules? One item small business forget about is Market Research and Analysis. Market Research Sampling Trying to get inside the mind of a customer is a complicated thing. It requires that you really dig in and...
Standard Members
Training spaCy’s Parser for Conversational Applications
If you already have some experience with spaCy, you know that there are a lot of pre-trained statistical models that can be put in use immediately. These models are not trained however to work in certain areas. In other words, they may not be specific to your domain. This may push you to consider improving an existing model or creating...
Undocumented SQL Server 2017 Agent Procedures
Undocumented SQL Server 2017 Agent Procedures SQL Server 2017 supports the following useful undocumented SQL Server Agent stored procedures: sp_sqlagent_is_srvrolemember sp_sqlagent_get_startup_info sp_MSgetalertinfo sp_readerrorlog Two of these stored procedures exist in the msdb database (sp_sqlagent_is_srvrolemember and sp_sqlagent_get_startup_info), other exist in the master database. sp_sqlagent_is_srvrolemember The sp_sqlagent_is_srvrolemember stored procedure indicates whether a SQL Server login is a member of the specified fixed...
Database Models and Relational Algebra – Part 5
THE RELATIONAL CALCULUS In relational calculus, a query is conveyed as a formulary plan which contains a number of variables as well as an expression concerning these variables. It is up to the Database Management System (DBMS) to convert these non – technical queries into the same, well-organized, effective and procedural queries. The concept of relational calculus was first planned...
How Do You Develop an Effective Content Marketing Strategy?
This question came from a small business owner. How do you develop an effective content marketing strategy? What are your rules? While there are no defined “rules” for building a content marketing strategy, it’s important to include these key components: Market Research and Analysis Valuable and Effective Content Develop Your Brand’s Voice Stay Consistent Analyze Your Results Market Research and...
Undocumented SQL Server 2017 oledb stored procedures
Undocumented SQL Server 2017 oledb stored procedures SQL Server 2017 supports the following useful undocumented oledb stored procedures: sp_oledb_language sp_oledb_ro_usrname sp_oledb_database sp_oledb_defdb sp_oledb_deflang sp_oledb_language The sp_oledb_language database engine stored procedure returns the official language name and alternative language name for each language presents in the instance of SQL Server 2017. Syntax sp_oledb_language Return Code Values None. Result Sets Column name...
Database Models and Relational Algebra – Part 4
The INTERSECTION Operators The INTERSECTION operation on table or relation A and B can be described as relation A INTERSECTION relation B designated as A ∩ B. In other words the rows or tuples which are common as well as belonging to both the tables or relations A and B only those rows or tuples are incorporated in the result...
How Best to Promote Yourself in a Job Interview
This question comes from a busy professional. Looking for HR experts to speak to how to promote yourself in a job interview. One crucial element in a job interview comes with the opening question, “So tell me about yourself.” I’m looking for HR and career coaching experts to give tips on how to speak to your accomplishments without coming off...
Undocumented SQL Server 2017 job stored procedures
Undocumented SQL Server 2017 job stored procedures SQL Server 2017 supports the following useful undocumented job stored procedures: sp_MSget_jobstate sp_delete_all_msx_jobs sp_get_job_alerts sp_multi_server_job_summary sp_help_operator_jobs sp_MSget_jobstate The sp_MSget_jobstate stored procedure returns the job state for the specified job. Syntax sp_MSget_jobstate [ @job_id = ] ‘job_id’ Arguments [ @job_id = ] ‘job_id’ Is the job identifier. job_id is UNIQUEIDENTIFIER, with no default. Return...
Database Models and Relational Algebra – Part 3
RELATIONAL ALGEBRA in Database Management System The relational algebra operators are mathematical functions which are castoff to recover queries by means of explaining a particular sequence of procedures on relations or tables and sometimes on even databases schema. With the help of relational algebra operators, each and every query is always created by a number of relational algebra operators, which...