SQL Server

Pro Members SQL Server Standard Members

Rules for a Content Marketing Strategy

How do you develop an effective content marketing strategy? What are your rules? While there aren’t any hard and fast rules regarding an effective content marketing strategy, you will be more successful if you keep this list in mind. 1. Understand your audience (buyer persona, research) 2. Keyword research 3. Identify effective content 4. Decide on placement 5. Develop your...

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 Integration Services (Part 1)

Tips for using SQL Server 2017 Integration Services (Part 1) If you need to distribute data rows to multiple downstream data flow components, you can use the Conditional Split and Multicast transformation. This transformation was first added in SQL Server 2005 Integration Services and make easy for developers to build packages with complex data flow without writing any code. Try...

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

Categories of Database and Database Users – Part 5

Mapping Cardinalities The cardinalities is the number of entities to which any other entity can be linked through any relation set is known as mapping cardinalities, or cardinality ratios. Mapping cardinalities are mostly valuable in defining the binary relationship sets, even though they can subsidize to the definition of relationship sets which involves more than two (2) entity sets. o...

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

Relevant Metrics for Tracking ROI on Social Media

What are the relevant metrics for tracking ROI on social media and to determine the success of a digital marketing campaign? This is an impossible question to answer with a single solution. As a business consultant, I normally start off with a discovery session to clarify the client’s business goals. Zach Gallagher, Director of Interactive Strategy for Weiden + Kennedy,...

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 useful SQL Server 2017 Transact-SQL optimization tips (Part 2)

Some useful SQL Server 2017 Transact-SQL optimization tips (Part 2) Try to avoid using the DISTINCT clause, whenever possible. The DISTINCT clause should only be used if you know that duplicate returned rows are a possibility. Because using the DISTINCT clause will result in some performance degradation, you should use this clause only when it is necessary. Use table variables...

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

Training Models in spaCy

spaCy v2.0 features statistical neural network models for named entity recognition, dependency parsing, and similarity prediction. One of the most exciting opportunities is that you cannot only use pre-trained, ready-for-use models, but you can also train a model with your own training examples, thus tuning it for your particular use case. spaCy’s Model Architecture Before starting to train a model,...

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

Categories of Database and Database Users – Part 4

Relational Databases In relational databases, the association among data files is relational. Hierarchical as well as network databases need the end user to pass a hierarchy in sequence to access the desirable data. These databases link to the data in dissimilar files by means of making use of shared data numbers or any key field. Data in relational databases is...

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 to Motivate an Employee Who Is Lacking Drive

What is the best way to motivate a team member that is competent for the work but is lacking drive? Getting on the same page Let’s better define “lacking drive”. Is he performing his duties adequately and as expected, but just doesn’t have the drive or ambition to advance? Is he performing his duties adequately, but just not showing 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

Some useful SQL Server 2017 Transact-SQL optimization tips (Part 1)

Some useful SQL Server 2017 Transact-SQL optimization tips (Part 1) Try to avoid using SQL Server cursors, whenever possible. SQL Server cursors can result in some performance degradation in comparison with select statements. Try to use correlated subquery or derived tables, if you need to perform row-by-row operations. Encapsulate your Transact-SQL code inside a transaction when you modify database, not...

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

Intelligent Text Processing with spaCy

The task of extracting meaning from text data can be quite challenging. The problem is that you cannot rely on the meaning of individual words in a sentence or phrase, since the order of words may invert the whole point. Moreover, the same words may have different meaning, depending on the context. To address this problem, NLP has linguistic features...

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