Zsolt Soczo

About Me

A passionate software engineer, consultant, and programmer with an internationally proven track record of delivering .NET, SQL Server programming, and enterprise software architecture solutions to a broad range of clients.
Awarded Microsoft Most Valuable Professional status in ASP.NET and SQL Server from 2004 to 2010.

My story

I started programming when I was 11 years old on Commodore Plus 4 and Commodore 64. Programming in Basic was a bit too boring for me, so I started learning machine-level programming. The need to understand everything as deeply as possible become an everlasting habit of mine.

In secondary school, I acquired electronic technician skills. I ate, breathed, and slept designing and building circuits.

After 5 years I graduated as an Electrical Engineer from the Technical University of Budapest in 1999. My MSc theme was Computer Systems and Applications. My thesis was on Windows Security Programming.

In the last two years of my engineering study (1998-99), I started working part-time as a Systems Engineer, and then as a Programmer. I took several Microsoft Certified Professional exams at this time, and as soon as I finished the University, I became a Microsoft Certified Systems Engineer.

I quickly realized that software development is much more enjoyable than designing an Active Directory system (for me). After more studying, I became a Microsoft Certified Solution Developer, and Microsoft Certified Database Administrator.

In 2000 I joined a Microsoft Certified Training Center. .NET 1.0 was in the beta phase, and Microsoft had asked me to write some articles about the upcoming new language: C#. I have been involved in .NET since the birth of the platform.

In the next 7 years, I delivered .NET and SQL Server training to several hundred students. I have also created and taught my course about Design Patterns adapted to .NET. The training earned my reputation as someone knowledgeable about .NET, OOP Design, and SQL Server and allowed me to pursue my consulting journey. There were several local Microsoft conferences where I presented about hot .NET topics.

In 2003 I was awarded a Microsoft Most Valuable Professional in ASP.NET. Later, I then became SQL Server MVP util 2010 (Unfortunately I did not have enough time to support the community since then).

In 2006 I decided to take a break from training because as it was a very demanding business. I joined a company writing low-level C++ code for Internet Explorer. It was a very different endeavor compared to my earlier days, but a welcomed diversification.

In 2009 I became a freelance consultant. Great timing during a recession. :).

In recent times I have created and delivered 4 new courses to my clients:

Refactoring and Test Driven Development for .NET

Refactoring and Test Driven Development for C++

C# from A to Z

Entity Framework Programming

Optimizing SQL Server Queries

Since 2009 I worked for many companies helping them to:

  • Creating architecture prototypes
  • Tuning SQL Queries
  • Optimizing .NET code performance
  • Troubleshooting SQL Server blocking and deadlocking
  • Creating C# Roslyn-based refactoring tool
  • Troubleshooting Web Server crashes via Memory Dump analysis
  • Finding memory leaks in Web Apps
  • Investigating excess memory usage for Desktop Applications
  • Phasing out legacy WCF code
  • Introducing more loosely coupled design into legacy applications
  • Refactoring legacy code to allow unit testing
  • Migrating WCF code to gRCP
  • Replacing legacy Dependency Injection Framework (Unity) to Autofac
  • Migrating from Entity Framework Classic to EF core
  • Tuning EF Core querying

You can check my MCP history. Transcript ID 681053 Access Code: alma1234

For easier access, here is my MCP history from the link. Charter means I took the beta version of the exam when no one has seen it yet, so any cheating is excluded.

Microsoft Certification Official Transcript
Microsoft Certification ID: 1266303 Microsoft Logo
ZSOLT SOCZO
Active Certifications Achievement Date
Microsoft® Certified Solutions Associate: Cloud Platform (Charter)* September 26, 2016
Certification Number: F805-8011
Microsoft® Certified Solutions Associate: SQL Server 2012/2014 May 15, 2015
Certification Number: H364-1485
Microsoft Specialist: Developing Microsoft Azure Solutions December 30, 2014
Certification Number: F143-5433
Microsoft Specialist: Implementing Microsoft Azure Infrastructure Solutions December 19, 2014
Certification Number: F121-5613
Microsoft Certified Professional: Microsoft Certified Professional April 16, 2012
Certification Number: E904-1154
Microsoft® Certified Technology Specialist: .NET Framework 4, Data Access (Charter)* June 5, 2010
Certification Number: B403-5452
Microsoft® Certified Technology Specialist: .NET Framework 4, Web Applications (Charter)* June 5, 2010
Certification Number: B403-5451
Microsoft® Certified Technology Specialist: .NET Framework 4, Windows Applications (Charter)* June 5, 2010
Certification Number: B403-5450
Microsoft® Certified Technology Specialist: SQL Server 2008, Database Development (Charter)* October 7, 2008
Certification Number: B403-5449
Microsoft® Certified IT Professional: Database Developer 2008 (Charter)* October 7, 2008
Certification Number: B403-5447
Microsoft® Certified Technology Specialist: Windows Internals (Charter)* August 5, 2008
Certification Number: B403-5446
Microsoft® Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance (Charter)* July 31, 2008
Certification Number: B403-5448
Microsoft Certified Trainer History Active From To
MCT History February 14, 2003 May 28, 2007
Exams Date Completed
762 Developing SQL Databases September 19, 2016
459 Transition your MCITP on SQL Server 2008 to MCSE: Data Platform May 22, 2015
457 Transition your MCTS on SQL Server 2008 to MCSA: SQL Server 2012 -Part 1 May 15, 2015
532 Developing Microsoft Azure Solutions December 30, 2014
533 Implementing Microsoft Azure Infrastructure Solutions December 19, 2014
515 TS: Web Applications Development with Microsoft .NET Framework 4 April 29, 2010
516 TS: Accessing Data with Microsoft .NET Framework 4 April 20, 2010
519 Pro: Designing and Developing Web Applications Using Microsoft .NET Framework 4 April 15, 2010
511 TS: Windows Applications Development with Microsoft .NET Framework 4 April 13, 2010
563 PRO: Designing and Developing Windows Applications using Microsoft .NET Framework 3.5 October 30, 2008
433 TS: Microsoft SQL Server 2008, Database Development October 7, 2008
451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 September 30, 2008
660 TS: Windows Internals August 5, 2008
432 Microsoft SQL Server 2008, Implementation and Maintenance July 31, 2008
620 TS: Configuring Microsoft Windows Vista Client May 9, 2007
431 TS: Microsoft SQL Server™ 2005 – Implementation and Maintenance May 3, 2007
442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server™ 2005 December 19, 2006
554 UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 2 March 6, 2006
553 UPGRADE: MCSD Microsoft .NET Skills to MCPD Enterprise Application Developer by Using the Microsoft .NET Framework: Part 1 March 6, 2006
551 UPGRADE: MCAD Skills to MCPD Web Developer by Using the Microsoft .NET Framework March 3, 2006
552 UPGRADE: MCAD Skills to MCPD Windows Developer by Using the Microsoft .NET Framework March 3, 2006
447 UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server™ 2005 December 16, 2005
443 PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server™ 2005 December 16, 2005
444 PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server™ 2005 December 2, 2005
441 PRO: Designing Database Solutions by Using Microsoft SQL Server™ 2005 December 2, 2005
229 Designing and Implementing Databases with Microsoft SQL Server™ 2000 Enterprise Edition December 21, 2004
340 Implementing Security for Applications with Microsoft Visual C# .NET May 3, 2004
306 Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET August 22, 2003
300 Analyzing Requirements and Defining Microsoft .NET Solution Architectures November 7, 2002
305 Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET July 12, 2002
310 Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework June 25, 2002
228 Installing, Configuring, and Administering Microsoft SQL Server™ 2000 Enterprise Edition October 11, 2001
100 Analyzing Requirements and Defining Solution Architectures October 13, 2000
176 Designing and Implementing Desktop Applications with Microsoft Visual Basic 6.0 September 7, 2000
175 Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 June 21, 2000
029 Designing and Implementing Databases with Microsoft SQL Server 7.0 March 1, 2000
079 Implementing & Supporting the Microsoft Internet Explorer Admin Kit for Microsoft IE 4.0 November 16, 1999
059 Internetworking with Microsoft TCP/IP on Microsoft Windows NT™ 4.0 October 27, 1999
058 Networking Essentials August 17, 1999
067 Implementing and Supporting NT™ Server 4.0 March 3, 1999
068 Implementing and Supporting NT™ Server 4.0 in the Enterprise February 23, 1999
073 Implementing and Supporting NT™ 4.0 Workstation December 21, 1998
Certification History Achievement Date
Microsoft® Certified Technology Specialist: Microsoft Windows Vista, Configuration (Charter)* May 9, 2007
Certification Number: B403-5427
Microsoft® Certified Technology Specialist: SQL Server 2005 May 3, 2007
Certification Number: B403-5423
Microsoft® Certified IT Professional: Database Administrator on SQL Server 2005 May 3, 2007
Certification Number: B403-5419
Microsoft® Certified IT Professional: Database Developer on SQL Server 2005 May 3, 2007
Certification Number: B403-5418
Microsoft® Certified Technology Specialist: .Net Framework 2.0, Distributed Applications (Charter)* March 6, 2006
Certification Number: B403-5426
Microsoft® Certified Professional Developer: Enterprise Application Developer (Charter)* March 6, 2006
Certification Number: B403-5422
Microsoft® Certified Professional Developer: Web Developer (Charter)* March 3, 2006
Certification Number: B403-5420
Microsoft® Certified Technology Specialist: .Net Framework 2.0, Web Applications (Charter)* March 3, 2006
Certification Number: B403-5425
Microsoft® Certified Technology Specialist: .Net Framework 2.0, Windows Applications (Charter)* March 3, 2006
Certification Number: B403-5424
Microsoft® Certified Professional Developer: Windows Developer (Charter)* March 3, 2006
Certification Number: B403-5421
Microsoft Certified Solution Developer: Microsoft .NET July 9, 2004
Certification Number: B403-5405
Microsoft Certified Application Developer: Microsoft .NET August 22, 2003
Certification Number: B403-5403
Microsoft Certified Database Administrator: Microsoft SQL Server 2000 October 11, 2001
Certification Number: B403-5397
Microsoft Certified Solution Developer: Visual Studio 6.0 October 13, 2000
Certification Number: B403-5392
Microsoft Certified Systems Engineer: Windows NT 4.0 November 16, 1999
Certification Number: B403-5387
Microsoft Certified Professional: Microsoft Certified Professional December 21, 1998
Certification Number: B403-5388