Tibor Nagy
I am a technical and business professional based in Budapest, Hungary. I am working in the financial industry on the operations side, but also have test management experience in the educational software domain. My experience includes Microsoft SQL Server 2000-2012, IBM DB2 and MySQL database administration, troubleshooting, migration and development. My focus points are performance tuning and security. I am passionate about sharing my knowledge with the greater audience.
I hold MSc degree in Engineering and Management. I am married and I have a
beautiful daughter.
LinkedIn account:
http://www.linkedin.com/in/nagytibor
Twitter account:
https://twitter.com/#!/tnagy_eeft
2015 Awards
Auditing and Compliance
- What does PCI DSS mean for your SQL Server environment? (last update: 4/25/2014)
Database Administration
- Automatic Statistics Update Slows Down SQL Server 2005 (last update: 2/7/2011)
Indexing
- How to Find Outdated Statistics in SQL Server 2008 (last update: 8/3/2012)
- SQL Server Auto Update and Auto Create Statistics Options (last update: 9/13/2012)
- SQL Server's Auto Update Statistics Async option (last update: 3/12/2013)
- What are the SQL Server _WA_Sys... statistics? (last update: 8/9/2012)
Performance Tuning
- How to Identify IO Bottlenecks in MS SQL Server (last update: 3/17/2011)
- How to Identify Microsoft SQL Server Memory Bottlenecks (last update: 2/18/2011)
- How to Identify SQL Server CPU Bottlenecks (last update: 3/1/2011)
- Issues Caused by Outdated Statistics in SQL Server (last update: 6/21/2012)
Professional Development Certifications
- SQL Server 2008 Certification Resources (last update: 11/21/2011)
Query Plans
- Comparison between a SQL Server Graphical Plan and Text Plan (last update: 1/10/2012)
- Differences Between SQL Server Query Plan Formats (last update: 6/28/2011)
Reporting Services Performance
- How to Speed up MS SQL Server Reporting Services on First Run (last update: 1/3/2011)
Restore
- Table level recovery for selected SQL Server tables (last update: 11/30/2012)
Security
- How to configure SSL encryption in SQL Server (last update: 8/12/2014)
- How to troubleshoot SSL encryption issues in SQL Server (last update: 11/25/2014)
- How to use module signing for SQL Server security (last update: 9/18/2014)
- PCI Best Practices Guide for SQL Server DBAs (last update: 5/8/2015)
- SQL Server PCI DSS Security Patching Checklist (last update: 12/25/2014)
- SQL Server Security Checklist (last update: 2/6/2014)
SQL Server Management Studio
- Column and block text selection using SQL Server Management Studio (last update: 10/19/2012)
Testing
- Populating a SQL Server Test Database with Random Data (last update: 12/9/2010)
