Microsoft SQL Server Training Classes in Lansing, Michigan
Learn Microsoft SQL Server in Lansing, Michigan 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 Lansing, Michigan: 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
- RED HAT ENTERPRISE LINUX SYSTEMS ADMIN II
8 December, 2025 - 11 December, 2025 - Python for Scientists
8 December, 2025 - 12 December, 2025 - RHCSA EXAM PREP
17 November, 2025 - 21 November, 2025 - Object-Oriented Programming in C# Rev. 6.1
17 November, 2025 - 21 November, 2025 - ASP.NET Core MVC (VS2022)
24 November, 2025 - 25 November, 2025 - See our complete public course listing
Blog Entries publications that: entertain, make you think, offer insight
Over time, companies are migrating from COBOL to the latest standard of C# solutions due to reasons such as cumbersome deployment processes, scarcity of trained developers, platform dependencies, increasing maintenance fees. Whether a company wants to migrate to reporting applications, operational infrastructure, or management support systems, shifting from COBOL to C# solutions can be time-consuming and highly risky, expensive, and complicated. However, the following four techniques can help companies reduce the complexity and risk around their modernization efforts.
All COBOL to C# Solutions are Equal
It can be daunting for a company to sift through a set of sophisticated services and tools on the market to boost their modernization efforts. Manual modernization solutions often turn into an endless nightmare while the automated ones are saturated with solutions that generate codes that are impossible to maintain and extend once the migration is over. However, your IT department can still work with tools and services and create code that is easier to manage if it wants to capitalize on technologies such as DevOps.
Narrow the Focus
Most legacy systems are incompatible with newer systems. For years now, companies have passed legacy systems to one another without considering functional relationships and proper documentation features. However, a detailed analysis of databases and legacy systems can be useful in decision-making and risk mitigation in any modernization effort. It is fairly common for companies to uncover a lot of unused and dead code when they analyze their legacy inventory carefully. Those discoveries, however can help reduce the cost involved in project implementation and the scope of COBOL to C# modernization. Research has revealed that legacy inventory analysis can result in a 40% reduction of modernization risk. Besides making the modernization effort less complex, trimming unused and dead codes and cost reduction, companies can gain a lot more from analyzing these systems.
Understand Thyself
For most companies, the legacy system entails an entanglement of intertwined code developed by former employees who long ago left the organization. The developers could apply any standards and left behind little documentation, and this made it extremely risky for a company to migrate from a COBOL to C# solution. In 2013, CIOs teamed up with other IT stakeholders in the insurance industry in the U.S to conduct a study that found that only 18% of COBOL to C# modernization projects complete within the scheduled period. Further research revealed that poor legacy application understanding was the primary reason projects could not end as expected.
Furthermore, using the accuracy of the legacy system for planning and poor understanding of the breadth of the influence of the company rules and policies within the legacy system are some of the risks associated with migrating from COBOL to C# solutions. The way an organization understands the source environment could also impact the ability to plan and implement a modernization project successfully. However, accurate, in-depth knowledge about the source environment can help reduce the chances of cost overrun since workers understand the internal operations in the migration project. That way, companies can understand how time and scope impact the efforts required to implement a plan successfully.
Use of Sequential Files
Companies often use sequential files as an intermediary when migrating from COBOL to C# solution to save data. Alternatively, sequential files can be used for report generation or communication with other programs. However, software mining doesn’t migrate these files to SQL tables; instead, it maintains them on file systems. Companies can use data generated on the COBOL system to continue to communicate with the rest of the system at no risk. Sequential files also facilitate a secure migration path to advanced standards such as MS Excel.
Modern systems offer companies a range of portfolio analysis that allows for narrowing down their scope of legacy application migration. Organizations may also capitalize on it to shed light on migration rules hidden in the ancient legacy environment. COBOL to C# modernization solution uses an extensible and fully maintainable code base to develop functional equivalent target application. Migration from COBOL solution to C# applications involves language translation, analysis of all artifacts required for modernization, system acceptance testing, and database and data transfer. While it’s optional, companies could need improvements such as coding improvements, SOA integration, clean up, screen redesign, and cloud deployment.
C# PROGRAMMING –MAIN DESIGN GOALS
C# is a popular programming language these days, and it was designed from inception to provide a simple, clean, general purpose programming language for those intending to work within the confines of Microsoft’s .NET framework. Since then, it has been approved as one of the standard languages by both ECMA and ISO, making C# programming an essential tool in every programmers’ kit.
Different languages have different uses and specialties, and C# was designed for programmers to be able to use it to create different components for use in software that would be deployed and distributed en masse, to live use environments. This means that designers had to really put an emphasis on making the actual source code extremely compatible and portable. Those already familiar with C or C++ should definitely notice this emphasis.
Another particular point of emphasis during design was focus on internationalization of the language; it was intended from inception to be available all over the world, and to see all sorts of different implementations based on variance in regional programming technique. The resultant use should help the language develop sophistication as it is refined throughout different versions.
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.
Welcome to the career field of Business Intelligence. Business Intelligence is a concept that involves a certain level of interaction within an organism, analytically and dynamically, to come to business solutions which implement better, more effective and timely decision making. These solutions are reached by establishing an understanding of the right kinds of user data: what is going well, what is going wrong, taking and monitoring certain actions, previously unknown trends, and patterns, and improved collaboration. When all of this data is taken into account, the entire decision-making process, within a business, will inevitably improve. As an Oracle BI developer, there are specific skills which will drastically make your job easier and results more effective. As time goes on and technology changes, the list is constantly being updated. The following are skills an Oracle Business Intelligence Developer might need to know or learn in 2019.
Communication
Tech Life in Michigan
| Company Name | City | Industry | Secondary Industry |
|---|---|---|---|
| Lear Corporation | Southfield | Manufacturing | Automobiles, Boats and Motor Vehicles |
| TRW Automotive Holdings Corp. | Livonia | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Spartan Stores, Inc. | Byron Center | Retail | Grocery and Specialty Food Stores |
| Steelcase Inc. | Grand Rapids | Manufacturing | Furniture Manufacturing |
| Valassis Communications, Inc. | Livonia | Business Services | Advertising, Marketing and PR |
| Autoliv, Inc. | Auburn Hills | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Cooper-Standard Automotive Group | Novi | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Penske Automotive Group, Inc. | Bloomfield Hills | Retail | Automobile Dealers |
| Con-Way Inc. | Ann Arbor | Transportation and Storage | Freight Hauling (Rail and Truck) |
| Meritor, Inc. | Troy | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Visteon Corporation | Van Buren Twp | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Affinia Group, Inc. | Ann Arbor | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Perrigo Company | Allegan | Healthcare, Pharmaceuticals and Biotech | Pharmaceuticals |
| BorgWarner Inc. | Auburn Hills | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Auto-Owners Insurance | Lansing | Financial Services | Insurance and Risk Management |
| DTE Energy Company | Detroit | Energy and Utilities | Gas and Electric Utilities |
| Whirlpool Corporation | Benton Harbor | Manufacturing | Tools, Hardware and Light Machinery |
| Herman Miller, Inc. | Zeeland | Manufacturing | Furniture Manufacturing |
| Universal Forest Products | Grand Rapids | Manufacturing | Furniture Manufacturing |
| Masco Corporation Inc. | Taylor | Manufacturing | Concrete, Glass, and Building Materials |
| PULTEGROUP, INC. | Bloomfield Hills | Real Estate and Construction | Real Estate & Construction Other |
| CMS Energy Corporation | Jackson | Energy and Utilities | Energy and Utilities Other |
| Stryker Corporation | Portage | Healthcare, Pharmaceuticals and Biotech | Medical Devices |
| General Motors Company (GM) | Detroit | Manufacturing | Automobiles, Boats and Motor Vehicles |
| Kellogg Company | Battle Creek | Manufacturing | Food and Dairy Product Manufacturing and Packaging |
| The Dow Chemical Company | Midland | Manufacturing | Chemicals and Petrochemicals |
| Kelly Services, Inc. | Troy | Business Services | HR and Recruiting Services |
| Ford Motor Company | Dearborn | Manufacturing | Automobiles, Boats and Motor Vehicles |
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 Michigan 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…














