These 5 Tech Jobs Will See the Most Growth in 2014

These 5 Tech Jobs Will See the Most Growth in 2014 (via Dice News in Tech)

Mobile app developers top the list of Robert Half Technology’s top growth tech jobs for 2014. Given the high demand for mobile-dev skills and the difficulty finding people who have them, that’s no surprise. RHT compiles this list based on increases…

 

Hottest Job in the Market: Software Developer

(via Dice News in Tech)

Software development is the most in-demand skill for technology jobs in the U.S., according to a study by Wanted Analytics. More than 232,000 jobs for software developers have been advertised online in the past 90 days, an increase of 3 percent over…

---

Software, Data Skills Key to Higher Pay

Software, Data Skills Key to Higher Pay (via Dice News in Tech)

Though few are on par with Twitter’s $10 million engineer, pay is on the upswing for IT occupations, according to a new Robert Half Technology salary survey. The report suggests that while salaries will rise an average of 3.7 percent in 2014 across…

---

Database Administrator: #2 Fastest Growing Job in America

Rise of the DBA

According to the Department of Labor Database Administrators will see 31% growth in their field between 2010 and 2020.

Six Fast-Growing Careers Taking Over the U.S. - Yahoo! Education

--ab

Last Updated: 4/21/2013 (code cleanup, added pic)

The Tally Table (and a nifty factorial function)

I have not posted anything since September and with good reason. Last year to promote this blog, I began participating in some online SQL forums and, long story short, realized that I needed to get on board with set-based SQL development. I always thought my code was slick until I did a deep dive into this whole “set-based thing.” Since then I have seen time and time again that the set-based solution almost always dramatically outperforms its iterative counter-part, often with cleaner, more elegant code.

Which brings me to The Tally Table. I’ve also heard it referred to as a “numbers table” or “auxiliary table of numbers”. I call it a tally table to give credit where credit is due. What you call it is not important, getting rid of those loops and cursors is. Nothing has helped me do that more than this article: The "Numbers" or "Tally" Table: What it is and how it replaces a loop

In future posts you will see many tricks with the tally table. For now, here's a nifty little factorial script.

Set-Based Factorial Query:

DECLARE @n int=5,          -- @n is the number to aggregate

        @factorial bigint=1; -- set @factorial to 1

 

WITH

t(n,f) AS (SELECT TOP(@n)

               ROW_NUMBER() OVER (ORDER BY (SELECT NULL))+1,

               ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) *

              (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))+1)

     FROM sys.all_columns

     UNION SELECT 1,1)

SELECT @factorial=@factorial*f

FROM t

WHERE n%2=@n%2;

 

SELECT @n AS n, @factorial AS factorial;

 

--ab

Further Reading:

• Virtual Auxiliary Table of Numbers (Itzik Ben-Gan)
• You REQUIRE a Numbers table! (Adam Machanic)
• A Simple Formula to Calculate the ISO Week Number - SQLServerCentral (Jeff Moden)
• Creative Solutions by Using a Number Table (Greg Larsen)
• How to Create and Use A Numbers Table (msdn)

Last Updated: 4/19/2013 (code cleanup)

Career Advice From Zombies

Normally I would pass on an article with this title but, as a subscriber to the Dice.com blog and someone currently reading World War Z (a great zombie book), I was intrigued and gave this a quick read...

This is a great article -- not just for job seekers but for everyone with aspirations to advance a skill and/or their careers, or those with a specific goal. Zombies lead by example: they demonstrate how to set goals and achieve those goals with a focused tenacity that all living persons should aspire to emulate.

Career Advice from Zombies

--ab

Last Updated: 4/19/2013 (code cleanup, added new pic)