Standard Members

Pro Members SQL Server Standard Members

10 Things you can do to create traffic to your website (Part 1)

This question came from a professional. Who can help me create traffic to my website? I need someone to help me with marketing my website. I have a website designer who is working for me but looking for more advise or recommendations. It is great that you are getting a professional website designer to work on your website. There are...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Tips for using SQL Server 2017 Integration Services (Part 3)

Tips for using SQL Server 2017 Integration Services (Part 3) Use breakpoints when you debug the packages. SQL Server 2017 Integration Services provide the ability to set breakpoints on packages, containers, and task events. Using breakpoints can help you debug your packages and find potential problems during the testing before transferring to production environments. Consider deploying a cache file together...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

7 Things IT Professionals Can Do to Increase Their Exposure on Social Media

What can IT professionals do to increase their exposure on social media? This is a great question. Here are 7 thing an IT professional can do to increase their exposure on social media. Craft your 30 second elevator pitch Create your individual website Create valuable shareable content Post your content on your website, and business social media pages Start participating...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Tips for using SQL Server 2017 Integration Services (Part 2)

Tips for using SQL Server 2017 Integration Services (Part 2) Try to eliminate logging. Use logging during debugging and troubleshooting and eliminate unneeded logging when deploying completed packages to production. Use checkpoints to restart the package from the failed task instead of having to rerun the whole package. In SQL Server 2017 Integration Services a package that fails during execution...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Converting Raw Text into SQL Data with spaCy

As the title suggests, this article covers how raw text can be converted into structured data. Before going any further, a word on the terminology used here is needed. In simple terms, raw text can be thought of as a set of tokens grouped into sentences, carrying information expressed in a natural language such as English. Put simply, raw text...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Categories of Database and Database Users – Part 6

Specialization The entity set might comprise of subgroups of entities which are discrete in some way from additional entities in the set. For an example, a subset of entities within an entity set might have columns or attributes which are not shared by each and every entities in the entity set. The Entity Relationship (ER) model offers a way out...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
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 - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here