Tibor Nagy

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
MSSQLTips award

MSSQLTips award

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)
SQL Server Graphical Query Plans Tutorial (last update: 10/12/2011)

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 SSRS 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)

Upgrades and Migrations

MySQL to SQL Server Conversion Tutorial (last update: 6/14/2011)

More SQL Server Solutions

download

get free sql tips