Microsoft SQL Server Training in Columbus, Ohio

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.

The Future of Java and Python

[Mar, 13, 2014] |
Tags:

Java still has its place in the world of software development, but is it quickly becoming obsolete by the more dynamically enabled Python programming language? The issue is hotly contested by both sides of the debate. Java experts point out that Java is still being developed with more programmer friendly updates. Python users swear that Java can take up to ten times longer to develop. Managers that need to make the best decision for a company need concrete information so that an informed and rational decision can be made.

First, Java is a static typed language while Python is dynamically typed. Static typed languages require that each variable name must be tied to both a type and an object. Dynamically typed languages only require that a variable name only gets bound to an object. Immediately, this puts Python ahead of the game in terms of productivity since a static typed language requires several elements and can make errors in coding more likely.

Python uses a concise language while Java uses verbose language. Concise language, as the name suggests, gets straight to the point without extra words. Removing additional syntax can greatly reduce the amount of time required to program. A simple call in Java, such as the ever notorious "Hello, World" requires three several lines of coding while Python requires a single sentence. Java requires the use of checked exceptions. If the exceptions are not caught or thrown out then the code fails to compile. In terms of language, Python certainly has surpassed Java in terms of brevity.

Additionally, while Java's string handling capabilities have improved they haven't yet matched the sophistication of Python's. Web applications rely upon fast load times and extraneous code can increase user wait time. Python optimizes code in ways that Java doesn't, and this can make Python a more efficient language. However, Java does run faster than Python and this can be a significant advantage for programmers using Java. When you factor in the need for a compiler for Java applications the speed factor cancels itself out leaving Python and Java at an impasse.

While a programmer will continue to argue for the language that makes it easiest based on the programmer's current level of knowledge, new software compiled with Python takes less time and provides a simplified coding language that reduces the chance for errors. When things go right, Java works well and there are no problems. However, when errors get introduced into the code, it can become extremely time consuming to locate and correct those errors. Python generally uses less code to begin with and makes it easier and more efficient to work with.

Ultimately, both languages have their own strengths and weaknesses. For creating simple applications, Python provides a simpler and more effective application. Larger applications can benefit from Java and the verbosity of the code actually makes it more compatible with future versions. Python code has been known to break with new releases. Ultimately, Python works best as a type of connecting language to conduct quick and dirty work that would be too intensive when using Java alone. In this sense, Java is a low-level implementation language. While both languages are continuing to develop, it's unlikely that one language will surpass the other for all programming needs in the near future.

What Are The 10 Most Famous Software Programs Written in Python?

[Mar, 19, 2014] |
Tags:

Python is an incredibly powerful and useful computer programming language that many of the biggest websites in the world rely on for their foundation. Python provides reliable results that are functional and involve a variety of dynamic scripted and non-scripted contexts. And because it is free and open source, it has remained a popular choice for a variety of different developers who are looking to build new sites on one of the most reliable languages available. Here is a look at 10 of the most famous software programs that are written in Python and what they do.

YouTube
If you love watching hours of homemade and professional quality video clips on YouTube, you can thank Python for giving you that option. The foundation for Python helped YouTube integrate streaming videos into their pages, as well as the ability to like videos and embed certain information. YouTube is one of the most popular sites on the Internet, and it runs off of one of the most powerful languages in Python.

DropBox
What started as a powerful app, DropBox is now used by a variety of individuals, businesses, companies, organizations and more. This program lets you save files to a cloud-based service, that you can then access from anywhere in the world. With Python at the root of DropBox, there is no longer a need for USB sticks or blank CDs, since you can now save and share everything with your cloud-based account.

Google
It takes a lot of power to be able to handle the most popular search engine in the entire world. That is why Google uses Python for its mainframe foundation, as well as in addition to various apps that it runs in conjunction with the main site. The ease that Google provides for finding certain information, would be impossible without Python at the core.

Quora
Got a question? Ask it on Quora. This site compiles a list of questions and answers that come from a community of individuals. Those questions are then organized by various members of the community, which puts the most relevant information at the top. The creators of Quora, who happened to be former Facebook employees, decided to use Python to help them create the world’s best Magic 8 ball in Quora.

Instagram
If you love taking photos of your food or a new outfit and posting it online for all of your friends to see, you can thank Python for that ability. Granted, Instagram has both a very powerful app and a website, but the latter runs on Python language. The system allows for users to browse, find and post pictures that they like on the site.

BitTorrent
BitTorrent has evolved quite a bit in recent years, but its foundation and earlier years were built on Python. When it comes to one of the largest databases of knowledge, media and content, BitTorrent is the way to go. But you wouldn’t be able to get any of those lectures or other legal stuff that you are downloading from BitTorrent, if it wasn’t for Python.

Spotify
Spotify changed the music game when it allowed you to listen to ad-free music of your choice. This wasn’t a program where you got to select a playlist, but rather full songs that you love, on repeat as many times as you can imagine, if you so desire. But whether you are rocking out to the latest K-Pop song from Psy or a classic jazz tune, you are doing so because Spotify was built on Python.

Reddit
Reddit is one of the biggest open communities on the web. You have a question, want to talk about something in specific, or find tons of information regarding a particular topic, you can just look on Reddit. The site relies on Python to help them store user names, categorize subreddits, upload links to GIFs and, of course, award gold to valued posters.

Yahoo Maps
Much like Google, Yahoo also uses Python for a variety of different resources. Most valued may be Yahoo Maps. The API and programming behind the maps program, which is built with Python, allows for users to find locations, get directions and even find reviews about local places.

Hipmunk
If you love to travel, you have likely come across Hipmunk. And while the site lets you save money on booking your itinerary through Hipmunk, it is Python that keeps everything organized. Python also helps sort the best discounts and rates, so you can get the best packages available.

Python is an incredibly powerful tool for web development. More and more sites rely on it, including 10 of the most powerful sites in the world that are listed here.

Working With Lists In Python

Will Tesla Finally Bring the D2C Revolution to the Auto Industry?

[Aug, 09, 2013] |
Tags:

Another blanket article about the pros and cons of Direct to Consumer (D2C) isn’t needed, I know. By now, we all know the rules for how this model enters a market: its disruption fights any given sector’s established sales model, a fuzzy compromise is temporarily met, and the lean innovator always wins out in the end.

That’s exactly how it played out in the music industry when Apple and record companies created a digital storefront in iTunes to usher music sales into the online era. What now appears to have been a stopgap compromise, iTunes was the standard model for 5-6 years until consumers realized there was no point in purchasing and owning digital media when internet speeds increased and they could listen to it for free through a music streaming service. In 2013, streaming models are the new music consumption standard. Netflix is nearly parallel in the film and TV world, though they’ve done a better job keeping it all under one roof. Apple mastered retail sales so well that the majority of Apple products, when bought in-person, are bought at an Apple store. That’s even more impressive when you consider how few Apple stores there are in the U.S. (253) compared to big box electronics stores that sell Apple products like Best Buy (1,100) Yet while some industries have implemented a D2C approach to great success, others haven’t even dipped a toe in the D2C pool, most notably the auto industry.

What got me thinking about this topic is the recent flurry of attention Tesla Motors has received for its D2C model. It all came to a head at the beginning of July when a petition on whitehouse.gov to allow Tesla to sell directly to consumers in all 50 states reached the 100,000 signatures required for administration comment. As you might imagine, many powerful car dealership owners armed with lobbyists have made a big stink about Elon Musk, Tesla’s CEO and Product Architect, choosing to sidestep the traditional supply chain and instead opting to sell directly to their customers through their website. These dealership owners say that they’re against the idea because they want to protect consumers, but the real motive is that they want to defend their right to exist (and who wouldn’t?). They essentially have a monopoly at their position in the sales process, and they want to keep it that way. More frightening for the dealerships is the possibility that once Tesla starts selling directly to consumers, so will the big three automakers, and they fear that would be the end of the road for their business. Interestingly enough, the big three flirted with the idea of D2C in the early 90’s before they were met with fierce backlash from dealerships. I’m sure the dealership community has no interest in mounting a fight like that again.

To say that the laws preventing Tesla from selling online are peripherally relevant would be a compliment. By and large, the laws the dealerships point to fall under the umbrella of “Franchise Laws” that were put in place at the dawn of car sales to protect franchisees against manufacturers opening their own stores and undercutting the franchise that had invested so much to sell the manufacturer’s cars. There’s certainly a need for those laws to exist, because no owner of a dealership selling Jeeps wants Chrysler to open their own dealership next door and sell them for substantially less. However, because Tesla is independently owned and isn’t currently selling their cars through any third party dealership, this law doesn’t really apply to them. Until their cars are sold through independent dealerships, they’re incapable of undercutting anyone by implementing D2C structure.

Tech Life in Ohio

Ulysses S. Grant, Rutherford B. Hayes, James A. Garfield, Benjamin Harrison, William McKinley, William H. Taft, and Warren G. Harding, were all U.S. Presidents born in Ohio. The first recognized university in Ohio was Ohio University founded in 1804. It wasn?t long until the first interracial and coeducational college in the United States, Oberlin, was founded in 1833. The Buckeye State produced some interesting discoveries such as: Charles Goodyear discovering the process of vulcanizing rubber in 1839; Roy J. Plunkett inventing Teflon in 1938; and Charles Kettering inventing the automobile self-starter in 1911.

It is your attitude, not your aptitude that determines your altitude. Zig Ziglar

other Learning Options

Software developers near Columbus 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.

Cleveland Perl Mongers · Columbus Web Group · DevOpsCLE ·

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

Company Name	City	Industry	Secondary Industry
Nationwide Insurance Company	Columbus	Financial Services	Insurance and Risk Management
Owens Corning	Toledo	Manufacturing	Concrete, Glass, and Building Materials
FirstEnergy Corp	Akron	Energy and Utilities	Gas and Electric Utilities
The Lubrizol Corporation	Wickliffe	Manufacturing	Chemicals and Petrochemicals
Sherwin-Williams	Cleveland	Retail	Hardware and Building Material Dealers
Key Bank	Cleveland	Financial Services	Banks
TravelCenters of America, Inc.	Westlake	Retail	Gasoline Stations
Dana Holding Company	Maumee	Manufacturing	Automobiles, Boats and Motor Vehicles
O-I (Owens Illinois), Inc.	Perrysburg	Manufacturing	Concrete, Glass, and Building Materials
Big Lots Stores, Inc.	Columbus	Retail	Department Stores
Limited Brands, Inc.	Columbus	Retail	Clothing and Shoes Stores
Cardinal Health	Dublin	Healthcare, Pharmaceuticals and Biotech	Healthcare, Pharmaceuticals, and Biotech Other
Progressive Corporation	Cleveland	Financial Services	Insurance and Risk Management
Parker Hannifin Corporation	Cleveland	Manufacturing	Manufacturing Other
American Financial Group, Inc.	Cincinnati	Financial Services	Insurance and Risk Management
American Electric Power Company, Inc	Columbus	Energy and Utilities	Gas and Electric Utilities
Fifth Third Bancorp	Cincinnati	Financial Services	Banks
Macy's, Inc.	Cincinnati	Retail	Department Stores
Goodyear Tire and Rubber Co.	Akron	Manufacturing	Plastics and Rubber Manufacturing
The Kroger Co.	Cincinnati	Retail	Grocery and Specialty Food Stores
Omnicare, Inc.	Cincinnati	Healthcare, Pharmaceuticals and Biotech	Pharmaceuticals
The Procter and Gamble Company	Cincinnati	Consumer Services	Personal Care

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

Columbus, Ohio Microsoft SQL Server Training , Columbus, Ohio Microsoft SQL Server Training Classes, Columbus, Ohio Microsoft SQL Server Training Courses, Columbus, Ohio Microsoft SQL Server Training Course, Columbus, Ohio Microsoft SQL Server Training Seminar

training locations

Ohio cities where we offer Microsoft SQL Server Training Classes

·Springfield, Ohio · Cleveland, OH · Canton · Columbus, OH ·Middletown, Ohio · Toledo, OH ·Mentor, Ohio · Dayton, OH · Elyria · Kettering, OH ·Cuyahoga Falls, Ohio · Cincinnati, OH ·Lorain, Ohio · Youngstown, OH · Hamilton · Parma, OH ·Akron, Ohio · Lakewood, OH

Microsoft SQL Server Training Classes in Columbus, Ohio

Microsoft SQL Server Training Catalog

Course Directory [training on all levels]

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

Tech Life in Ohio

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.