Microsoft SQL Server Training in Ontario, California

Learning SQL development can seem like an overwhelming task at first. However, mastering just a few key points will help ease your way through 80 percent of the day-to-day challenges when writing stored procedures and solving common problems. Here are three important SQL development factors to keep in mind:

Outer Joins
One of the most crucial things to understand in SQL server are joins. Joins are a way to retrieve data from two or more tables based on logical relationships between them. Joins dictate how Microsoft SQL Server ought to use data from one table to select the rows in another table.

In my experience inner joins are intuitive while outer joins can present additional hours of grief by overlooking associations in the other table(s). The outer join is the key to answering questions about what the database does not have. For example, if you need to make a query to display all the students who are without report-cards, you’ll need a left join to get all students coupled with a “where clause” to return the ones who have nulls for their report card table columns in the results.

Many talented Java script programmers have muddled through the SQL Server by deficient coding around the inner join. As a result, their queries can take five hours to run, whereas, properly written left joins, can take only two seconds to run.

Aggregation
Grouping results comes up in SQL a lot more than you might think. Knowing how to write a query when answering questions such as, “What’s the average grade for each teacher’s student list?” is invaluable. This kind of question cannot be answered with a single table or solely by joins. You’ll often find you need to use joins in conjunction with group by statements. Always write the raw query first and then look at the results. Next, you have to figure out the best way to group them, rewrite your select clause and add a group by clause in the end.

Digging Through Data
I find this is the most lacking skill in many programmers. In fact, many otherwise-talented programmers holding Master’s Degrees fail to get jobs because they couldn’t analyze rows of data objectively during interviews. It’s just something that’s not taught but is crucial to get under you belt. Why? Eventually, some query is not going to perform as you may expect. And, the only way to find discrepancies is to look at rows of data, identify what join isn’t finding a match or where bad data is throwing things into chaos. Get familiar with how joins actually work, even if you have to manually walk through the logic of a large stored procedure’s tree of joins. It’s boring and time-consuming but absolutely necessary.

Take the time to master the core skills that will make you a successful SQL Programmer and avoid queries that run for five hours!

Fixing Copy and Paste for Remote Desktop

[May, 31, 2014] |
Tags:

From Brennan's Blog which is no longer up and running:

I use Remote Desktop all the time to work inside of my development systems hosted by Microsoft Virtual Server. I use the host system to browse the web for documentation and searches as I work and when I need to copy some text from the web browser I find many times the link between the host clipboard and the remote clipboard is broken. In the past I have read that somehow the remote clipboard utility, rdpclip.exe, gets locked and no longer allows the clipboard to be relayed between the host and the client environment. My only way to deal with it was to use the internet clipboard, cl1p.net. I would create my own space and use it to send content between environments. But that is a cumbersome step if you are doing it frequently.

The only way I really knew to fix the clipboard transfer was to close my session and restart it. That meant closing the tools I was using like Visual Studio, Management Studio and the other ancillary processes I have running as I work and then restarting all of it just to restore the clipboard. But today I found a good link on the Terminal Services Blog explaining that what is really happening. The clipboard viewer chain is somehow becoming unresponsive on the local or remote system and events on the clipboards are not being relayed between systems. It is not necessarily a lock being put in place but some sort of failed data transmission. It then goes on to explain the 2 steps you can take to restore the clipboard without restarting your session.

Use Task Manager to kill the rdpclip.exe process
Run rdpclip.exe to restart it

The clipboard communications should be restored. My clipboard is currently working because I just restarted my session to fix it, but I wanted to test these steps. I killed rdpclip.exe and started it and was able to copy/paste from the remote to the host system. The next time my clipboard dies I will have to check to see if these steps truly do work.

3 Most Important Things Non-Programmers Should Know About Programming?

[May, 11, 2018] |
Tags:

What are the three most important things non-programmers should know about programming?

Written by Brian Knapp, credit and reprint CodeCareerGenius

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.

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 California

Largely influenced by several immigrant populations California has experienced several technological, entertainment and economic booms over the years. As for technology, Silicon Valley, in the southern part of San Francisco is an integral part of the world?s innovators, high-tech businesses and a myriad of techie start-ups. It also accounts for 1/3rd of all venture capital investments.

As machines become more and more efficient and perfect, so it will become clear that imperfection is the greatness of man. Ernst Fischer

other Learning Options

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

Responsive Web Design SF · iOS Developers (SF / SV) · vNext_OC ·

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

Company Name	City	Industry	Secondary Industry
Mattel, Inc.	El Segundo	Retail	Sporting Goods, Hobby, Book, and Music Stores
Spectrum Group International, Inc.	Irvine	Retail	Retail Other
Chevron Corp	San Ramon	Energy and Utilities	Gasoline and Oil Refineries
Jacobs Engineering Group, Inc.	Pasadena	Real Estate and Construction	Construction and Remodeling
eBay Inc.	San Jose	Software and Internet	E-commerce and Internet Businesses
Broadcom Corporation	Irvine	Computers and Electronics	Semiconductor and Microchip Manufacturing
Franklin Templeton Investments	San Mateo	Financial Services	Investment Banking and Venture Capital
Pacific Life Insurance Company	Newport Beach	Financial Services	Insurance and Risk Management
Tutor Perini Corporation	Sylmar	Real Estate and Construction	Construction and Remodeling
SYNNEX Corporation	Fremont	Software and Internet	Data Analytics, Management and Storage
Core-Mark International Inc	South San Francisco	Manufacturing	Food and Dairy Product Manufacturing and Packaging
Occidental Petroleum Corporation	Los Angeles	Manufacturing	Chemicals and Petrochemicals
Yahoo!, Inc.	Sunnyvale	Software and Internet	Software and Internet Other
Edison International	Rosemead	Energy and Utilities	Gas and Electric Utilities
Ingram Micro, Inc.	Santa Ana	Computers and Electronics	Consumer Electronics, Parts and Repair
Safeway, Inc.	Pleasanton	Retail	Grocery and Specialty Food Stores
Gilead Sciences, Inc.	San Mateo	Healthcare, Pharmaceuticals and Biotech	Pharmaceuticals
AECOM Technology Corporation	Los Angeles	Real Estate and Construction	Architecture,Engineering and Design
Reliance Steel and Aluminum	Los Angeles	Manufacturing	Metals Manufacturing
Live Nation, Inc.	Beverly Hills	Media and Entertainment	Performing Arts
Advanced Micro Devices, Inc.	Sunnyvale	Computers and Electronics	Semiconductor and Microchip Manufacturing
Pacific Gas and Electric Corp	San Francisco	Energy and Utilities	Gas and Electric Utilities
Electronic Arts Inc.	Redwood City	Software and Internet	Games and Gaming
Oracle Corporation	Redwood City	Software and Internet	Software and Internet Other
Symantec Corporation	Mountain View	Software and Internet	Data Analytics, Management and Storage
Dole Food Company, Inc.	Thousand Oaks	Manufacturing	Food and Dairy Product Manufacturing and Packaging
CBRE Group, Inc.	Los Angeles	Real Estate and Construction	Real Estate Investment and Development
First American Financial Corporation	Santa Ana	Financial Services	Financial Services Other
The Gap, Inc.	San Francisco	Retail	Clothing and Shoes Stores
Ross Stores, Inc.	Pleasanton	Retail	Clothing and Shoes Stores
Qualcomm Incorporated	San Diego	Telecommunications	Wireless and Mobile
Charles Schwab Corporation	San Francisco	Financial Services	Securities Agents and Brokers
Sempra Energy	San Diego	Energy and Utilities	Gas and Electric Utilities
Western Digital Corporation	Irvine	Computers and Electronics	Consumer Electronics, Parts and Repair
Health Net, Inc.	Woodland Hills	Healthcare, Pharmaceuticals and Biotech	Healthcare, Pharmaceuticals, and Biotech Other
Allergan, Inc.	Irvine	Healthcare, Pharmaceuticals and Biotech	Biotechnology
The Walt Disney Company	Burbank	Media and Entertainment	Motion Picture and Recording Producers
Hewlett-Packard Company	Palo Alto	Computers and Electronics	Consumer Electronics, Parts and Repair
URS Corporation	San Francisco	Real Estate and Construction	Architecture,Engineering and Design
Cisco Systems, Inc.	San Jose	Computers and Electronics	Networking Equipment and Systems
Wells Fargo and Company	San Francisco	Financial Services	Banks
Intel Corporation	Santa Clara	Computers and Electronics	Semiconductor and Microchip Manufacturing
Applied Materials, Inc.	Santa Clara	Computers and Electronics	Semiconductor and Microchip Manufacturing
Sanmina Corporation	San Jose	Computers and Electronics	Semiconductor and Microchip Manufacturing
Agilent Technologies, Inc.	Santa Clara	Telecommunications	Telecommunications Equipment and Accessories
Avery Dennison Corporation	Pasadena	Manufacturing	Paper and Paper Products
The Clorox Company	Oakland	Manufacturing	Chemicals and Petrochemicals
Apple Inc.	Cupertino	Computers and Electronics	Consumer Electronics, Parts and Repair
Amgen Inc	Thousand Oaks	Healthcare, Pharmaceuticals and Biotech	Biotechnology
McKesson Corporation	San Francisco	Healthcare, Pharmaceuticals and Biotech	Pharmaceuticals
DIRECTV	El Segundo	Telecommunications	Cable Television Providers
Visa, Inc.	San Mateo	Financial Services	Credit Cards and Related Services
Google, Inc.	Mountain View	Software and Internet	E-commerce and Internet Businesses

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

Ontario, California Microsoft SQL Server Training , Ontario, California Microsoft SQL Server Training Classes, Ontario, California Microsoft SQL Server Training Courses, Ontario, California Microsoft SQL Server Training Course, Ontario, California Microsoft SQL Server Training Seminar

training locations

California cities where we offer Microsoft SQL Server Training Classes

·Rancho Cucamonga, California · Vallejo, CA · Chula Vista · Indio, CA ·South Gate, California · Modesto, CA ·Camarillo, California · Yorba Linda, CA · Merced · West Covina, CA ·Chico, California · Oceanside, CA ·Fresno, California · Lodi, CA · Carlsbad · Temecula, CA ·Madera, California · Chino, CA ·Alameda, California · Pleasanton, CA · Bellflower · Watsonville, CA ·Folsom, California · Apple Valley, CA ·Thousand Oaks, California · Redwood City, CA · Perris · San Rafael, CA ·Garden Grove, California · Compton, CA ·Burbank, California · Redondo Beach, CA · Elk Grove · Riverside, CA ·Milpitas, California · Monterey Park, CA ·Fontana, California · Sunnyvale, CA · Arcadia · Lynwood, CA ·Highland, California · Union City, CA ·Mission Viejo, California · Rialto, CA · Lake Forest · South San Francisco, CA ·Redlands, California · Daly City, CA ·Santee, California · Hawthorne, CA · Oxnard · Rancho Cordova, CA ·Hayward, California · Rocklin, CA ·Norwalk, California · La Habra, CA · Alhambra · Newport Beach, CA ·San Clemente, California · Cathedral City, CA ·Delano, California · Gardena, CA · San Leandro · Carson, CA ·San Bernardino, California · Pomona, CA ·Turlock, California · Fullerton, CA · San Mateo · Hemet, CA ·Palmdale, California · Encinitas, CA ·Buena Park, California · Walnut Creek, CA · Tulare · Victorville, CA ·Glendale, California · Santa Clara, CA ·Fairfield, California · Oakland, CA · Santa Clarita · Ventura, CA ·Chino Hills, California · Murrieta, CA ·Visalia, California · Santa Rosa, CA · Corona · Livermore, CA ·Laguna Niguel, California · National City, CA ·Irvine, California · Porterville, CA · Concord · San Jose, CA ·Orange, California · Berkeley, CA ·Lakewood, California · Fountain Valley, CA · Santa Maria · Mountain View, CA ·Huntington Beach, California · Stockton, CA ·Roseville, California · Whittier, CA · Palm Desert · Upland, CA ·Long Beach, California · Paramount, CA ·Clovis, California · Sacramento, CA · Manteca · La Mesa, CA ·Novato, California · Los Angeles (la), CA ·Citrus Heights, California · Tracy, CA · El Cajon · Lancaster, CA ·Pittsburg, California · Hanford, CA ·Pico Rivera, California · Fremont, CA · Palo Alto · Redding, CA ·Richmond, California · Santa Ana, CA ·Westminster, California · Bakersfield, CA · San Marcos · Moreno Valley, CA ·Escondido, California · Davis, CA ·Baldwin Park, California · Cerritos, CA · Costa Mesa · Santa Barbara, CA ·Lake Elsinore, California · Santa Monica, CA ·Ontario, California · Pasadena, CA · Petaluma · Vacaville, CA ·Woodland, California · Torrance, CA ·Yuba City, California · Downey, CA · Huntington Park · Hesperia, CA ·Montebello, California · El Monte, CA ·San Diego, California · Antioch, CA · Diamond Bar · Tustin, CA ·Vista, California · Rosemead, CA ·Inglewood, California · Santa Cruz, CA · Colton · Salinas, CA ·Simi Valley, California · Napa, CA ·Cupertino, California · Anaheim, CA · San Francisco

Microsoft SQL Server Training Classes in Ontario, California

Microsoft SQL Server Training Catalog

Course Directory [training on all levels]

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

Tech Life in California

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.