Microsoft SQL Server Training Classes in Albany, New York
Learn Microsoft SQL Server in Albany, NewYork and surrounding areas via our hands-on, expert led courses. All of our classes either are offered on an onsite, online or public instructor led basis. Here is a list of our current Microsoft SQL Server related training offerings in Albany, New York: Microsoft SQL Server Training
Microsoft SQL Server Training Catalog
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- AI Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Azure Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Data Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- SAS Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
- Linux Troubleshooting
1 June, 2026 - 5 June, 2026 - AWS Certified Machine Learning: Specialty (MLS-C01)
20 July, 2026 - 24 July, 2026 - Linux Fundamentals
23 March, 2026 - 27 March, 2026 - RED HAT ENTERPRISE LINUX SYSTEMS ADMIN I
18 May, 2026 - 22 May, 2026 - ANSIBLE
27 April, 2026 - 29 April, 2026 - See our complete public course listing
Blog Entries publications that: entertain, make you think, offer insight
The consulting industry is fiercely competitive and nets between $130B and $150B a year. In fact, professional consultants earn more money than many lawyers, doctors and other professionals.
Offering free consultations is a common way for a software consultant to seize new accounts. But is there a red flag where a consultant may be giving away too many services for free? The worst scenario for a professional software consultant is to offer free services to the client and then never hear from them again once they no longer need their help.
Although having the best intentions, many people will waste a consultant's time (i.e., client ignores or rejects any suggested approaches or solutions given by the consultant and seek the services of someone who will do it cheaper or will attempt to do it themselves). Small business owners especially can be challenging to work with. Some clients have a tendency to jump into projects before having adequate resources to finish what they have started, decide to go in a different direction midstream, while others simply don't want to spend any money when getting professional services. It's hard to believe, but some clients actually expect to receive free services for life. To counteract this notion, a software consultant can draw the line by offering free services within a promotional time frame and then begin charging a fee for services rendered after that time.
A good indicator of what a client's true intentions are is to monitor their activity within a specified period to see if their consultation activity bears fruit in the form of a contract. One big red flag is non-commitment on the part of the client. If they seem indecisive or vague about what they want it may be time to move on. Although there are times when a free consultation results in a paying client years later, who can wait that long?
Less of Your Time is Wasted When You're Upfront
After being burned, some professional software consultants no longer give free consulting. They find that clients are much more willing to follow their advice when they have paid something. In order to close an account, a happy medium can be agreed upon by both parties involved as a way to build a long term relationship with highly qualified prospects.
A software consultant's work, knowledge, skills and time are valuable. They can offer a potential client general solutions instead of addressing specific challenges. If a specific topic of discussion, troubleshooting session or other issue needs to be addressed, the consultant can inform the client of any upfront costs to receive a particular service if they need further assistance. Really, a free software consultation (if one is given) should be presented in a very similar way someone would hand out samples of a product at a grocery store. A professional consultant ideally wants clients to see how they can benefit using their services on a trial basis with a pitch leading to more extensive services which would only be available if they sign a contract with their firm.
Red Flags
It is said that spoken languages shape thoughts by their inclusion and exclusion of concepts, and by structuring them in different ways. Similarly, programming languages shape solutions by making some tasks easier and others less aesthetic. Using F# instead of C# reshapes software projects in ways that prefer certain development styles and outcomes, changing what is possible and how it is achieved.
F# is a functional language from Microsoft's research division. While once relegated to the land of impractical academia, the principles espoused by functional programming are beginning to garner mainstream appeal.
As its name implies, functions are first-class citizens in functional programming. Blocks of code can be stored in variables, passed to other functions, and infinitely composed into higher-order functions, encouraging cleaner abstractions and easier testing. While it has long been possible to store and pass code, F#'s clean syntax for higher-order functions encourages them as a solution to any problem seeking an abstraction.
F# also encourages immutability. Instead of maintaining state in variables, functional programming with F# models programs as a series of functions converting inputs to outputs. While this introduces complications for those used to imperative styles, the benefits of immutability mesh well with many current developments best practices.
For instance, if functions are pure, handling only immutable data and exhibiting no side effects, then testing is vastly simplified. It is very easy to test that a specific block of code always returns the same value given the same inputs, and by modeling code as a series of immutable functions, it becomes possible to gain a deep and highly precise set of guarantees that software will behave exactly as written.
Further, if execution flow is exclusively a matter of routing function inputs to outputs, then concurrency is vastly simplified. By shifting away from mutable state to immutable functions, the need for locks and semaphores is vastly reduced if not entirely eliminated, and multi-processor development is almost effortless in many cases.
Type inference is another powerful feature of many functional languages. It is often unnecessary to specify argument and return types, since any modern compiler can infer them automatically. F# brings this feature to most areas of the language, making F# feel less like a statically-typed language and more like Ruby or Python. F# also eliminates noise like braces, explicit returns, and other bits of ceremony that make languages feel cumbersome.
Functional programming with F# makes it possible to write concise, easily testable code that is simpler to parallelize and reason about. However, strict functional styles often require imperative developers to learn new ways of thinking that are not as intuitive. Fortunately, F# makes it possible to incrementally change habits over time. Thanks to its hybrid object-oriented and functional nature, and its clean interoperability with the .net platform, F# developers can gradually shift to a more functional mindset while still using the algorithms and libraries with which they are most familiar.
Related F# Resources:
I remember the day like it was yesterday. Pac Man had finally arrived on the Atari 2600. It was a clear and sunny day, but it was slightly brisk. My dad drove us down to the video store about three miles from our Michigan house. If I remember correctly, the price for the game was $24.99. It was quite expensive for the day, probably equaling a $70 game in today’s market, but it was mine. There *was* no question about it. If you purchase a game, it’s your game… right?
You couldn’t be more wrong. With all the licensing agreements in games today, you only purchase the right to play it. You don’t actually “own” the game.
Today, game designers want total control over the money that comes in for a game. They add in clauses that keep the game from being resold, rented, borrowed, copied, etc. All of the content in the game, including the items you find that are specifically for you, are owned by the software developer. Why, you ask, do they do this? It’s all about the money.
This need for greed started years ago, when people started modifying current games on the market. One of the first games like this was Doom. There were so many third part mods made, but because of licensing agreement, none of these versions were available for resale. The end user, or you, had to purchase Doom before they could even install the mod. None of these “modders” were allowed to make any money off their creation.
It is hard not to wonder how current technology would have altered the events surrounding the tragic death of John F. Kennedy. On the afternoon of November 22, 1963, shots rang out in Dallas, TX, taking the life of JFK, one of the most beloved Americans. Given the same circumstances today, surely the advances in IT alone, would have drastically changed the outcome of that horrible day. Would the government have recognized that there was a viable threat looming over JFK? Would local and government agencies have been more prepared for a possible assassination attempt? Would the assortment of everyday communication devices assisted in the prevention of the assassination, not to mention, provided greater resources into the investigation? With all that the IT world has to offer today, how would it have altered the JFK tragedy?
As many conspiracy theories have rocked the foundation of the official story presented by government agencies, realization of the expansive nature of technology provides equal consideration as to how the event would have been changed had this technology been available during the time of the shooting. There were T.V. cameras, home 8mm recorders, even single shot-hand held cameras snapping away as the car caravan approached. Yet, there remains little documentation of the shooting and even less information pertaining to the precautions taken by officials prior to JFK's arrival. Theorists consider these possibilities along with how the world would have turned out had the great John F. Kennedynever been assassinated on that day.
Tech Life in New York
| Company Name | City | Industry | Secondary Industry |
|---|---|---|---|
| NYSE Euronext, Inc. | New York | Financial Services | Securities Agents and Brokers |
| Anderson Instrument Company Inc. | Fultonville | Manufacturing | Tools, Hardware and Light Machinery |
| News Corporation | New York | Media and Entertainment | Radio and Television Broadcasting |
| Philip Morris International Inc | New York | Manufacturing | Manufacturing Other |
| Loews Corporation | New York | Travel, Recreation and Leisure | Hotels, Motels and Lodging |
| The Guardian Life Insurance Company of America | New York | Financial Services | Insurance and Risk Management |
| Jarden Corporation | Rye | Manufacturing | Manufacturing Other |
| Ralph Lauren Corporation | New York | Retail | Clothing and Shoes Stores |
| Icahn Enterprises, LP | New York | Financial Services | Investment Banking and Venture Capital |
| Viacom Inc. | New York | Media and Entertainment | Media and Entertainment Other |
| Omnicom Group Inc. | New York | Business Services | Advertising, Marketing and PR |
| Henry Schein, Inc. | Melville | Healthcare, Pharmaceuticals and Biotech | Medical Supplies and Equipment |
| Pfizer Incorporated | New York | Healthcare, Pharmaceuticals and Biotech | Pharmaceuticals |
| Eastman Kodak Company | Rochester | Computers and Electronics | Audio, Video and Photography |
| Assurant Inc. | New York | Business Services | Data and Records Management |
| PepsiCo, Inc. | Purchase | Manufacturing | Nonalcoholic Beverages |
| Foot Locker, Inc. | New York | Retail | Department Stores |
| Barnes and Noble, Inc. | New York | Retail | Sporting Goods, Hobby, Book, and Music Stores |
| Alcoa | New York | Manufacturing | Metals Manufacturing |
| The Estee Lauder Companies Inc. | New York | Healthcare, Pharmaceuticals and Biotech | Personal Health Care Products |
| Avon Products, Inc. | New York | Healthcare, Pharmaceuticals and Biotech | Personal Health Care Products |
| The Bank of New York Mellon Corporation | New York | Financial Services | Banks |
| Marsh and McLennan Companies | New York | Financial Services | Insurance and Risk Management |
| Corning Incorporated | Corning | Manufacturing | Concrete, Glass, and Building Materials |
| CBS Corporation | New York | Media and Entertainment | Radio and Television Broadcasting |
| Bristol Myers Squibb Company | New York | Healthcare, Pharmaceuticals and Biotech | Biotechnology |
| Citigroup Incorporated | New York | Financial Services | Banks |
| Goldman Sachs | New York | Financial Services | Personal Financial Planning and Private Banking |
| American International Group (AIG) | New York | Financial Services | Insurance and Risk Management |
| Interpublic Group of Companies, Inc. | New York | Business Services | Advertising, Marketing and PR |
| BlackRock, Inc. | New York | Financial Services | Securities Agents and Brokers |
| MetLife Inc. | New York | Financial Services | Insurance and Risk Management |
| Consolidated Edison Company Of New York, Inc. | New York | Energy and Utilities | Gas and Electric Utilities |
| Time Warner Cable | New York | Telecommunications | Cable Television Providers |
| Morgan Stanley | New York | Financial Services | Investment Banking and Venture Capital |
| American Express Company | New York | Financial Services | Credit Cards and Related Services |
| International Business Machines Corporation | Armonk | Computers and Electronics | Computers, Parts and Repair |
| TIAA-CREF | New York | Financial Services | Securities Agents and Brokers |
| JPMorgan Chase and Co. | New York | Financial Services | Investment Banking and Venture Capital |
| The McGraw-Hill Companies, Inc. | New York | Media and Entertainment | Newspapers, Books and Periodicals |
| L-3 Communications Inc. | New York | Manufacturing | Aerospace and Defense |
| Colgate-Palmolive Company | New York | Consumer Services | Personal Care |
| New York Life Insurance Company | New York | Financial Services | Insurance and Risk Management |
| Time Warner Inc. | New York | Media and Entertainment | Media and Entertainment Other |
| Cablevision Systems Corp. | Bethpage | Media and Entertainment | Radio and Television Broadcasting |
| CA Technologies, Inc. | Islandia | Software and Internet | Software |
| Verizon Communications Inc. | New York | Telecommunications | Telephone Service Providers and Carriers |
| Hess Corporation | New York | Energy and Utilities | Gasoline and Oil Refineries |
training details locations, tags and why hsg
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.
- We have provided software development and other IT related training to many major corporations in New York since 2002.
- 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…














