Pro Members

Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Categories of Database and Database Users – Part 1
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Database and Hashing Technique – Part 6

DATA DICTIONARY An individual can characterize data dictionary as Database Management System (DBMS) part that stores the meaning of data attributes and connections. An individual might review that such “data about data” were marked metadata. The Database Management System (DBMS) data dictionary gives Database Management System (DBMS) with its self-depicting characteristics. As a result, the data dictionary reference looks like...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

How Leaders Communicate the Company’s Vision So That Others Will Share It

Could you give some examples of how leaders can communicate the company’s vision so that others will share it? This is an excellent question. One of the leader’s responsibility is to communicate the company vision, mission statements and goals. One-on-one meetings One of the most effective ways is to meet one-on-one with each employee. 1. Work with each individual to...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Some tips for using ASP.NET with SQL Server 2017

Some tips for using ASP.NET with SQL Server 2017 If you use ADO to access SQL Server data in your ASP.NET, always create a Connection object explicitly, not implicitly. This can reduce the server overhead and simplify the controlling of a connection. Set the MultipleActiveResultSets (MARS) option in the SQL Server connection string. This option makes it possible to execute...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Using Machine Learning Algorithms to Analyze Chatbot Data

As a chatbot developer, you must tap into a set of emerging technologies. Machine learning is definitely one of them. Broadly speaking, machine learning can be used in a pretty wide variety of fields to recognize the patterns in your data to provide visual insights and statistical analysis, helping you interpret the data in your data set. Turning back to...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register