US Job Growth in 2017; Slow but Steady Battle

The U.S. job growth faced a slow growth according to statistics from the Bureau of Labor Statistics.  According to the numbers, there was a job growth of 179,000 jobs in May 2017 and the unemployment rate was at 4.3%. Lets face it job growth has been stagnant for the past 5 years.  However, under a … Continue reading US Job Growth in 2017; Slow but Steady Battle

Advertisements

Got Web Analytics?

If you haven't taken a look at your performance on your website, you could be missing out on potential sales and customers everyday. Lets face it everyone has a website for their business.  If you don't then it's time to get one.  According to statistics, nearly 46% of small businesses in the United States do … Continue reading Got Web Analytics?

To Blog or Not to Blog?

This challenge of when to blog has been puzzling me for the last 3-6 months.  I've yet to experiment about the perfect time to post an article for everyone to see and most of all pay attention to.  I've come across some really good advice this morning while watching some videos on Youtube.  What better … Continue reading To Blog or Not to Blog?

SQL: Using JOINS in SQL Server

SQL: Using JOINS in SQL Server JOINS Introduction   What is a JOIN? JOINS in SQL Server are used to retrieve data from two of more related tables.  Tables are generally related by foreign key restraints. We will discuss the different types of JOINS: INNER JOIN OUTER JOIN FULL JOIN CROSS JOIN OUTER JOINS are … Continue reading SQL: Using JOINS in SQL Server

SQL: Using the LIKE Operator

SQL: Using the LIKE Operator LIKE Introduction   LIKE is a special operator just for strings LIKE will match strings with a pattern Wildcard Character % Introduction   You can use the % Wildcard character with LIKE % Wildcard character can go anywhere in the string The percent sign % wildcard character matches any sequence … Continue reading SQL: Using the LIKE Operator

SQL: Using AND and OR

  AND Introduction   AND means that two expressions by AND must evaluate to TRUE Example: Who are all the people in my contact list that have the first name Jon and have a birthday later than 1965? SELECT p.person_first_name FROM person p WHERE p.person_first_name = ‘Jon’ AND p.birthday > 12/31/1965;     OR Introduction … Continue reading SQL: Using AND and OR