Pro Members

Pro Members SQL Server Standard Members

10 Things You Can Do to Create Traffic to Your Website (Part 2)

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. This is a continuation from the initial 10 Things you can do to create traffic to your website...

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 distributed queries

Tips for using SQL Server 2017 distributed queries Try to avoid using the TOP clause in the distributed queries. Because distributed queries that involve the TOP clause are never delegated to an OLE DB provider and are always evaluated locally, you should avoid using the TOP clause in the distributed queries to increase the local SQL Server performance. The first...

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

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

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

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

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