Microsoft SQL Server Training in Allen, Texas

Since you asked for the three most important things that non-programmers should know about, and I’ve spent most of my career working with more non-programmers than programmers, I have a few interesting things that would help.

Number One - It Is Impossible To Accurately Estimate Software Projects

No matter what is tried. No matter what tool, agile approach, or magic fairy dust people try to apply to creating software… accurately predicting software project timelines is basically impossible.

There are many good reasons for this. Usually, requirements and feature ideas change on a daily/weekly basis. Often it is impossible to know what needs to be done without actually digging into the code itself. Debugging and QA can take an extraordinary amount of time.

And worst of all…

Project Managers are always pushing for shorter timelines. They largely have no respect for reality. So, at some point they are given estimates just to make them feel better about planning.

No matter how much planning and estimation you do, it will be wrong. At best it will be directionally correct +/- 300% of what you estimated. So, a one year project could actually take anywhere between 0 and 5 years, maybe even 10 years.

If you think I’m joking, look at how many major ERP projects that go over time and over budget by many years and many hundreds of millions of dollars. Look at the F-35 fighter jet software issues.

Or in the small, you can find many cases where a “simple bug fix” can take days when you thought it was hours.

All estimates are lies made up to make everyone feel better. I’ve never met a developer or manager who could accurately estimate software projects even as well as the local weatherman(or woman) predicts the weather.

Number Two - Productivity Is Unevenly Distributed

What if I told you that in the average eight hour work day the majority of the work will get done in a 30 minute timeframe? Sound crazy?

Well, for most programmers there is a 30–90 minute window where you are extraordinarily productive. We call this the flow state.

Being in the flow state is wonderful and amazing. It often is where the “magic” of building software happens.

Getting into flow can be difficult. It’s akin to meditation in that you have to have a period of uninterrupted focus of say 30 minutes to “get in” the flow, but a tiny interruption can pull you right out.

Now consider the modern workplace environment. Programmers work in open office environments where they are invited to distract each other constantly.

Most people need a 1–2 hour uninterrupted block to get 30–90 minutes of flow.

Take the 8 hour day and break it in half with a lunch break, and then pile in a few meetings and all of a sudden you are lucky to get one decent flow state session in place.

That is why I say that most of the work that gets done happens in a 30 minute timeframe. The other 7–8 hours are spent being distracted, answering email, going to meetings, hanging around the water cooler, going to the bathroom, and trying to remember what you were working on before all these distractions.

Ironically, writers, musicians, and other creative professionals have their own version of this problem and largely work alone and away from other people when they are creating new things.

Someday the programming world might catch on, but I doubt it.

Even if this became obvious, it doesn’t sit well with most companies to think that programmers would be paid for an 8 hour day and only be cranking out code for a few hours on a good day. Some corporate middle manager would probably get the bright idea to have mandatory flow state training where a guru came in and then there would be a corporate policy from a pointy haired boss mandating that programmers are now required to spend 8 hours a day in flow state and they must fill out forms to track their time and notify their superiors of their flow state activities, otherwise there would be more meetings about the current flow state reports not being filed correctly and that programmers were spending too much time “zoning out” instead of being in flow.

Thus, programmers would spent 7–8 hours a day pretending to be in flow state, reporting on their progress, and getting all their work done in 30 minutes of accidental flow state somewhere in the middle of all that flow state reporting.

If you think I’m joking about this, I’m not. I promise you this is what would happen to any company of more than 2 employees. (Even the ones run by programmers.)

Number Three - It Will Cost 10x What You Think

Being a programmer, I get a lot of non-programmers telling me about their brilliant app ideas. Usually they want me to build something for free and are so generous as to pay me up to 5% of the profits for doing 100% of the work.

Their ideas are just that good.

Now, I gently tell them that I’m not interested in building anything for free.

At that point they get angry, but a few ask how much it will cost. I give them a reasonable (and very incorrect) estimate of what it would cost to create the incredibly simple version of their app idea.

Let’s say it’s some number like $25,000.

They look at me like I’m a lunatic, and so I explain how much it costs to hire a contract programmer and how long it will actually take. For example’s sake let’s say it is $100/hr for 250 hours.

To be clear, these are made up numbers and bad estimates (See Number One for details…)

In actuality, to build the actual thing they want might cost $250,000, or even $2,500,000 when it’s all said and done.

Building software can be incredibly complex and expensive. What most people can’t wrap their head around is the fact that a company like Google, Apple, or Microsoft has spent BILLIONS of dollars to create something that looks so simple to the end user.

Somehow, the assumption is that something that looks simple is cheap and fast to build.

Building something simple and easy for the end user is time consuming and expensive. Most people just can’t do it.

So, the average person with a brilliant app idea thinks it will cost a few hundred or maybe a few thousand dollars to make and it will be done in a weekend is so off the mark it’s not worth considering their ideas.

And programmers are too eager to play along with these bad ideas (by making bad estimates and under charging for their time) that this notion is perpetuated to the average non-programmer.

So, a good rule of thumb is that software will cost 10 times as much as you think and take 10 times as long to finish.

And that leads to a bonus point…

BONUS - Software Is Never Done

Programmers never complete a software project, they only stop working on it. Software is never done.

I’ve worked at many software companies and I’ve never seen a software project “completed”.

Sure, software gets released and used. But, it is always changing, being updated, bugs get fixed, and there are always new customer requests for features.

Look at your favorite software and you’ll quickly realize how true this is. Facebook, Instagram, Google Search, Google Maps, GMail, iOS, Android, Windows, and now even most video games are never done.

There are small armies of developers just trying to keep all the software you use every day stable and bug free. Add on the fact that there are always feature requests, small changes, and new platforms to deal with, it’s a treadmill.

So, the only way out of the game is to stop working on software. At that point, the software begins to decay until it is no longer secure or supported.

Think about old Windows 3.1 software or maybe old Nintendo Cartridge video games. The current computers and video game consoles don’t even attempt to run that software anymore.

You can’t put an old video game in your new Nintendo Switch and have it “just work”. That is what happens when you think software is done.

When programmers stop working on software the software starts to die. The code itself is probably fine, but all the other software keeps moving forward until your software is no longer compatible with the current technology.

So, those are the four most important things that non-programmers should know about programming. I know you asked for only three, so I hope the bonus was valuable to you as well.

Python Programming for Cisco Networking Engineers

[Jun, 25, 2018] |
Tags:

Wondering why Cisco is teaching network engineers Python in addition to their core expertise?

Yes, arguably there are many other tools available to use to automate the network without writing any code. It is also true that when code is absolutely necessary, in most companies software developers will write the code for the network engineers. However, networks are getting progressively more sophisticated and the ability for network engineers to keep up with the rate of change, scale of networks, and processing of requirements is becoming more of a challenge with traditional methodologies.

Does that mean that all network engineers have to become programmers in the future? Not completely, but having certain tools in your tool belt may be the deciding factor in new or greater career opportunities. The fact is that current changes in the industry will require Cisco engineers to become proficient in programming, and the most common programming language for this new environment is the Python programming language. Already there are more opportunities for those who can understand programming and can also apply it to traditional networking practices.

Cisco’s current job boards include a search for a Sr. Network Test Engineer and for several Network Consulting Engineers, each with "competitive knowledge" desired Python and Perl skills. Without a doubt, the most efficient network engineers in the future will be the ones who will be able to script their automated network-related tasks, create their own services directly in the network, and continuously modify their scripts.

Whether you are forced to attend or are genuinely interested in workshops or courses that cover the importance of learning topics related to programmable networks such as Python, the learning curve at the very least will provide you with an understanding of Python scripts and the ability to be able to use them instead of the CLI commands and the copy and paste options commonly used. Those that plan to cling to their CLI will soon find themselves obsolete.

As with anything new, learning a programming language and using new APIs for automation will require engineers to learn and master the skills before deploying widely across their network. The burning question is where to start and which steps to take next?

In How Do I Get Started Learning Network Programmability? Hank Preston – on the Cisco blog page suggest a three phase approach to diving into network programmability.

“Phase 1: Programming Basics

In this first phase you need to build a basic foundation in the programmability skills, topics, and technologies that will be instrumental in being successful in this journey. This includes learning basic programming skills like variables, operations, conditionals, loops, etc. And there really is no better language for network engineers to leverage today than Python. Along with Python, you should explore APIs (particularly REST APIs), data formats like JSON, XML, and YAML. And if you don’t have one already, sign up for a GitHub account and learn how to clone, pull, and push to repos.

Phase 2: Platform Topics

Once you have the programming fundamentals squared away (or at least working on squaring them away) the time comes to explore the new platforms of Linux, Docker, and “the Cloud.” As applications are moving from x86 virtualization to micro services, and now serverless, the networks you build will be extending into these new areas and outside of traditional physical network boxes. And before you can intelligently design or engineer the networks for those environments, you need to understand how they basically work. The goal isn’t to become a big bushy beard wearing Unix admin, but rather to become comfortable working in these areas.

Phase 3: Networking for Today and Tomorrow

Now you are ready to explore the details of networking in these new environments. In phase three you will dive deep into Linux, container/Docker, cloud, and micro service networking. You have built the foundation of knowledge needed to take a hard look at how networking works inside these new environments. Explore all the new technologies, software, and strategies for implementing and segmenting critical applications in the “cloud native” age and add value to the application projects.”

Community resources:

GitHub’s, PYPL Popularity of Programming Language lists Python as having grown 13.2% in demand in the last 5 years.

Python in the June 2018 TIOBE Index ranks as the fourth most popular language behind Java, C and C++.

Despite the learning curve, having Python in your tool belt is without a question a must have tool.

8 Reasons Why You Should Get Ready For HTML5

[Jul, 25, 2012] |
Tags:

Evolving technologies become fun due to the immense advantages and features they bring with them. Fighting change though is human and while we may initially resist such changes, it is always better to accept them to our advantage.

Switching to HTML 5 is one such change we need to be ready for and there are at least 8 reasons why we should be doing so which are explained later in the article.

Earlier HTML was mainly used only for Web content development. But with the arrival of HTML 5, there would be a radical shift in that it would be used more and more for the development of many of the client side applications as well. The advantages straight away are that CSS as well as JavaScript become free due to the open architecture environment. HTML 5 is also pretty light and has a much easier code to read, making it convenient for devices like smart phones and tablets running on batteries to use the applications.

The 8 reasons mentioned above are as under:

How to study for Exams

[Mar, 12, 2013] |
Tags:

With an ever increasing rise in the use of employment testing, certification testing and need to get a degree, I thought I would write this basic guide on how to study for exams. Although it was originally written with the college student in mind, the fundamentals still apply to all of us in the workforce.

There are few things that strike terror into the hearts of students more than exam day, particularly if they have inadequate study skills. Perhaps these students study for hours and hours, only to discover that by exam time they've forgotten everything they've read. Below are a few study tips to help struggling students remember the information they've reviewed for their exams.

-Use memory tricks. There are a number of memory tricks that you can use to help you remember large amounts of information. For example, the use of acronyms (such as Roy G Biv to remember the colors of the rainbow) can be very helpful. In addition, you can use visualization techniques, similes, and songs to assist you in recalling your study material.

-Don't cram. Your brain requires time to absorb facts. If you know about a test in advance, start studying right away for a little bit every day, ramping up your efforts as the exam approaches.

-Take frequent breaks while studying. It may seem counter-intuitive that spending less time studying might actually help you remember more of what you've read. But taking appropriately timed study breaks will keep your mind fresh and make sure you don't stress too much.

-Write it out. For many people, writing information down as they read it is the best way to learn it. Don't just write exactly what you read, however; by rewording the information or even drawing a picture or diagram you commit it to your memory in more than one way, allowing you to remember it easier later.

-Teach it to a friend. To remember information, you have to understand it. And in order to teach information, you need to understand it as well. Nothing tests your ability to recall facts better than teaching them to another person. Find a friend unfamiliar with your study material and teach them a lesson in the subject.

-Get plenty of sleep the night before the exam. Finally, be sure to get a good night's rest the night before you take the exam. Falling asleep at your desk will accomplish nothing. This will help you be more alert while you are taking your test, and will allow you to retain more information.

Tech Life in Texas

Austin may be considered the live music capital of the world but the field of technology is becoming the new norm in the The Lone Star State. Home to Dell and Compaq computers, there is a reason why central Texas is often referred to as the Silicon Valley of the south. It?s rated third on the charts of the top computer places in the United States with a social learning and training IT atmosphere. Adding the fact that Austin offers fairly inexpensive living costs for students, software developers may take note as they look to relocate.

Obviously everyone wants to be successful, but I want to be looked back on as being very innovative, very trusted and ethical and ultimately making a big difference in the world. Sergey Brin, Google cofounder

other Learning Options

Software developers near Allen have ample opportunities to meet like minded techie individuals, collaborate and expend their career choices by participating in Meet-Up Groups. The following is a list of Technology Groups in the area.

DFW Hardware Startups · Austin CSS for Beginners & Advanced · LoneStar PhoneGap ·

Fortune 500 and 1000 companies in Texas that offer opportunities for Microsoft SQL Server developers

Company Name	City	Industry	Secondary Industry
Dr Pepper Snapple Group	Plano	Manufacturing	Nonalcoholic Beverages
Western Refining, Inc.	El Paso	Energy and Utilities	Gasoline and Oil Refineries
Frontier Oil Corporation	Dallas	Manufacturing	Chemicals and Petrochemicals
ConocoPhillips	Houston	Energy and Utilities	Gasoline and Oil Refineries
Dell Inc	Round Rock	Computers and Electronics	Computers, Parts and Repair
Enbridge Energy Partners, L.P.	Houston	Transportation and Storage	Transportation & Storage Other
GameStop Corp.	Grapevine	Retail	Retail Other
Fluor Corporation	Irving	Business Services	Management Consulting
Kimberly-Clark Corporation	Irving	Manufacturing	Paper and Paper Products
Exxon Mobil Corporation	Irving	Energy and Utilities	Gasoline and Oil Refineries
Plains All American Pipeline, L.P.	Houston	Energy and Utilities	Gasoline and Oil Refineries
Cameron International Corporation	Houston	Energy and Utilities	Energy and Utilities Other
Celanese Corporation	Irving	Manufacturing	Chemicals and Petrochemicals
HollyFrontier Corporation	Dallas	Energy and Utilities	Gasoline and Oil Refineries
Kinder Morgan, Inc.	Houston	Energy and Utilities	Gas and Electric Utilities
Marathon Oil Corporation	Houston	Energy and Utilities	Gasoline and Oil Refineries
United Services Automobile Association	San Antonio	Financial Services	Personal Financial Planning and Private Banking
J. C. Penney Company, Inc.	Plano	Retail	Department Stores
Energy Transfer Partners, L.P.	Dallas	Energy and Utilities	Energy and Utilities Other
Atmos Energy Corporation	Dallas	Energy and Utilities	Alternative Energy Sources
National Oilwell Varco Inc.	Houston	Manufacturing	Manufacturing Other
Tesoro Corporation	San Antonio	Manufacturing	Chemicals and Petrochemicals
Halliburton Company	Houston	Energy and Utilities	Energy and Utilities Other
Flowserve Corporation	Irving	Manufacturing	Tools, Hardware and Light Machinery
Commercial Metals Company	Irving	Manufacturing	Metals Manufacturing
EOG Resources, Inc.	Houston	Energy and Utilities	Gasoline and Oil Refineries
Whole Foods Market, Inc.	Austin	Retail	Grocery and Specialty Food Stores
Waste Management, Inc.	Houston	Energy and Utilities	Waste Management and Recycling
CenterPoint Energy, Inc.	Houston	Energy and Utilities	Gas and Electric Utilities
Valero Energy Corporation	San Antonio	Manufacturing	Chemicals and Petrochemicals
FMC Technologies, Inc.	Houston	Energy and Utilities	Alternative Energy Sources
Calpine Corporation	Houston	Energy and Utilities	Gas and Electric Utilities
Texas Instruments Incorporated	Dallas	Computers and Electronics	Semiconductor and Microchip Manufacturing
SYSCO Corporation	Houston	Wholesale and Distribution	Grocery and Food Wholesalers
BNSF Railway Company	Fort Worth	Transportation and Storage	Freight Hauling (Rail and Truck)
Affiliated Computer Services, Incorporated (ACS), a Xerox Company	Dallas	Software and Internet	E-commerce and Internet Businesses
Tenet Healthcare Corporation	Dallas	Healthcare, Pharmaceuticals and Biotech	Hospitals
XTO Energy Inc.	Fort Worth	Energy and Utilities	Gasoline and Oil Refineries
Group 1 Automotive	Houston	Retail	Automobile Dealers
ATandT	Dallas	Telecommunications	Telephone Service Providers and Carriers
Anadarko Petroleum Corporation	Spring	Energy and Utilities	Gasoline and Oil Refineries
Apache Corporation	Houston	Energy and Utilities	Gasoline and Oil Refineries
Dean Foods Company	Dallas	Manufacturing	Food and Dairy Product Manufacturing and Packaging
American Airlines	Fort Worth	Travel, Recreation and Leisure	Passenger Airlines
Baker Hughes Incorporated	Houston	Energy and Utilities	Gasoline and Oil Refineries
Continental Airlines, Inc.	Houston	Travel, Recreation and Leisure	Passenger Airlines
RadioShack Corporation	Fort Worth	Computers and Electronics	Consumer Electronics, Parts and Repair
KBR, Inc.	Houston	Government	International Bodies and Organizations
Spectra Energy Partners, L.P.	Houston	Energy and Utilities	Gas and Electric Utilities
Energy Future Holdings	Dallas	Energy and Utilities	Energy and Utilities Other
Southwest Airlines Corporation	Dallas	Transportation and Storage	Air Couriers and Cargo Services

training details locations, tags and why hsg

the hartmann software group advantage

why take Microsoft SQL Server Training with the hartmann software group?

A successful career as a software developer or other IT professional requires a solid understanding of software development processes, design patterns, enterprise application architectures, web services, security, networking and much more. The progression from novice to expert can be a daunting endeavor; this is especially true when traversing the learning curve without expert guidance. A common experience is that too much time and money is wasted on a career plan or application due to misinformation.

The Hartmann Software Group understands these issues and addresses them and others during any training engagement. Although no IT educational institution can guarantee career or application development success, HSG can get you closer to your goals at a far faster rate than self paced learning and, arguably, than the competition. Here are the reasons why we are so successful at teaching:

Learn from the experts.
1. We have provided software development and other IT related training to many major corporations in Texas since 2002.
2. Our educators have years of consulting and training experience; moreover, we require each trainer to have cross-discipline expertise i.e. be Java and .NET experts so that you get a broad understanding of how industry wide experts work and think.
Discover tips and tricks about Microsoft SQL Server programming
Get your questions answered by easy to follow, organized Microsoft SQL Server experts
Get up to speed with vital Microsoft SQL Server programming tools
Save on travel expenses by learning right from your desk or home office. Enroll in an online instructor led class. Nearly all of our classes are offered in this way.
Prepare to hit the ground running for a new job or a new position
See the big picture and have the instructor fill in the gaps
We teach with sophisticated learning tools and provide excellent supporting course material
Books and course material are provided in advance
Get a book of your choice from the HSG Store as a gift from us when you register for a class
Gain a lot of practical skills in a short amount of time
We teach what we know…software
We care…

learn more

page tags

what brought you to visit us

Allen, Texas Microsoft SQL Server Training , Allen, Texas Microsoft SQL Server Training Classes, Allen, Texas Microsoft SQL Server Training Courses, Allen, Texas Microsoft SQL Server Training Course, Allen, Texas Microsoft SQL Server Training Seminar

training locations

Texas cities where we offer Microsoft SQL Server Training Classes

·Denton, Texas · Waco, TX · Grapevine · Wichita Falls, TX ·McAllen, Texas · Grand Prairie, TX ·North Richland Hills, Texas · Baytown, TX · Round Rock · Arlington, TX ·Galveston, Texas · Midland, TX ·Garland, Texas · Lubbock, TX · Abilene · Odessa, TX ·El Paso, Texas · Cedar Park, TX ·San Antonio, Texas · Beaumont, TX · Plano · Austin, TX ·Euless, Texas · Frisco, TX ·Carrollton, Texas · Pharr, TX · Missouri City · Corpus Christi, TX ·Allen, Texas · College Station, TX ·McKinney, Texas · Rowlett, TX · Pearland · Lewisville, TX ·Richardson, Texas · Bryan, TX ·Dallas, Texas · Amarillo, TX · Temple · Mission, TX ·New Braunfels, Texas · Flower Mound, TX ·Killeen, Texas · Fort Worth, TX · Sugar Land · San Angelo, TX ·Laredo, Texas · Tyler, TX ·Conroe, Texas · Longview, TX · League City · Harlingen, TX ·Port Arthur, Texas · San Marcos, TX ·Houston, Texas · Mesquite, TX · Victoria · Irving, TX ·Edinburg, Texas · Brownsville, TX ·Pasadena, Texas

Microsoft SQL Server Training Classes in Allen, Texas

Microsoft SQL Server Training Catalog

subcategories

Microsoft SQL Server Classes

Course Directory [training on all levels]

Blog Entries publications that: entertain, make you think, offer insight

Tech Life in Texas

training details locations, tags and why hsg

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.