Talks and Publications

Below you can find a list of my selected talks and publications.


Books

  • "Tuning SQL Server" (Second Edition). Artemakis Artemiou. Published online. May 6, 2017. [link]
  • "Developing SQL Server". Artemakis Artemiou. Published online. November 4, 2015.
  • "Administering SQL Server". Artemakis Artemiou. Published online. December 2, 2013.

  • "Tuning SQL Server". Artemakis Artemiou. Published online. October 1, 2013.

 


Technical Papers on Industry's Applied Technologies

  • "In-Memory OLTP Simulator: The Experiment". Artemakis Artemiou. Published online. March 2, 2016. [link] (note: see how I achieved a 26x speedup by simulating a 5M-record workload against SQL Server's In-Memory OLTP Engine)

 


Journal Publications

  • "Script to Manage SQL Server Rebuilds and Reorganize for Index Fragmentation", Artemakis Artemiou. MSSQLTips.com Online Journal. September 2016. [link]
  • "Simple Experiment with SQL Server In-Memory OLTP is 79 Times Faster", Artemakis Artemiou. MSSQLTips.com Online Journal. September 2016. [link]
  • "Top 10 Security Considerations for your SQL Server Instances", Artemakis Artemiou. SQLShack Online Journal, August 2016. [link]
  • "Export SQL Server Records into Individual Text Files", Artemakis Artemiou. MSSQLTips.com Online Journal, June 2016. [link]
  • "Modifying the SQL Server Model System Database to Customize New Database Settings", Artemakis Artemiou. MSSQLTips.com Online Journal. April 2016. [link]
  • "Implementing SQL Server In-Memory OLTP", Artemakis Artemiou. Simple-Talk Online Technical Journal, April 2016. [link]

  • "Assessing the SQL Server In-Memory OLTP Performance Benefits", Artemakis Artemiou. MSSQLTips.com Online Technical Journal, March 2016. [link]

  • "Introducing SQL Server In-Memory OLTP", Artemakis Artemiou. Simple-Talk Online Technical Journal, September 2015. [link]

  • "Database Management Systems: A Vision for Tomorrow". Artemakis Artemiou. Journal of Cyprus Computer Society, Issue 17, pp 38-41, June 2008. [link]

 


Given Talks

  • "Entity Framework: Let's Code First!", Cyprus .NET User Group Event, April 18, 2016, Microsoft Innovation Center, Nicosia, Cyprus.
  • "SQL Server 2016 Top Features", Cyprus .NET User Group Event, November 11, 2015, Microsoft Innovation Center, Nicosia, Cyprus.
  • "Community Event", Cyprus Developers and IT Pros Gathering, October 27, 2015, Microsoft Innovation Center, Nicosia, Cyprus.
  • "SQL 2014: A First Look Into the New Features", Microsoft Conference 2014, March 21 2014, Nicosia, Cyprus.
  • "Windows Azure SQL Database Overview", Cyprus .NET User Group Event, May 22, 2013. [link]

  • "Working with Snippets in SQL Server 2012", Screencast, March, 2013. Online. [link]

  • "Migrating to a Contained Database in SQL Server 2012", Screencast, December 20, 2012. Online. [link]

  • "SQL Server 2012: The Database Engine", Webcast, October 17, 2012. Online. [link]

  • "Let's talk SQL Server: Denali CTP 3!", Cyprus .NET User Group Event, November 12 2011, Microsoft Office, Nicosia, Cyprus. [link]

  • "Introducing SQL Server Denali (CTP1)", Webcast, January 7, 2011. Online. [link]

  • "SQL Server 2008 R2: Features for Developers and IT Pros", Cyprus .NET User Group Event. July 15, 2010. Microsoft Office, Nicosia, Cyprus. [link]

  • "An Introduction to the ADO.NET Entity Framework and Data Services", Microsoft DevDays 2010, April 15, 2010. Nicosia, Cyprus.

  • "Self-Service Business Intelligence with SQL Server 2008 R2", Microsoft Momentum 2009, November 26, 2009. Nicosia, Cyprus. [link]

  • "ADO.NET Data Services for the Web", Cyprus .NET User Group Event. June 18, 2009. Microsoft Office, Nicosia, Cyprus. [link]

  • "The ADO .NET Entity Framework and LINQ to Entities", Cyprus .NET User Group Event. March 31, 2009. Microsoft Office, Nicosia, Cyprus. [link]

  • "SQL Server 2008: An overview for Developers and IT Pros", Cyprus .Net User Group Event (within the context of the SQL Server 2008 Community Launch Program). December 18, 2008. Microsoft Office, Nicosia, Cyprus. [link]

  • "The MERGE Statement in SQL Server 2008", Microsoft TechEd EMEA Developers 2008, Speaker Idol Contest, November 12, 2008. Barcelona, Spain. [link]

  • "Build Data Applications with Microsoft SQL Server 2008".Co-Speaker (with Evangelos Hadjichristodoulou). Microsoft Momentum 2008. Heroes {happen here}. April 11, 2008, Nicosia, Cyprus.

  • "MapCenter: An Open Grid Status Visualization Tool". High Performance Computing Systems Laboratory, Department of Computer Science, University of Cyprus, February 18, 2004.

  • "Ovid: A Browser for Grids" . High Performance Computing Systems Laboratory, Department of Computer Science, University of Cyprus, November 24, 2003.

 


Conference Proceedings and Workshops

  • "Data Parallel Acceleration of Decision Support Queries Using Cell/BE and GPUs". P. Trancoso, D. Othonos, A. Artemiou, ACM International Conference on Computing Frontiers, May 18 - 20, 2009, Ischia, Italy. [link]

  • "Towards a Universal Client for Grid Monitoring Systems: Design and Implementation of the Ovid Browser." M. D. Dikaiakos, A. Artemiou, and G. Tsouloupas. In CDROM Proceedings of the 11th International Workshop on High-Level Parallel Programming Models and Supportive Environments, 20th IEEE International Parallel & Distributed Processing Symposium, (IPDPS 2006), April 25-29, 2006, Rhodes, Greece. IEEE Computer Society, 2006. [link]

  • "Ovid: A Browser for Grids." M. Dikaiakos, A. Artemiou, 2nd European Across Grids Conference, poster paper, CD-Rom Proceedings, 29 January 2004. [link]

 


Extended Abstracts

  • "Exploiting the GPU to Accelerate DSS Query Execution" (poster). P. Trancoso, A. Artemiou. ACM International Conference on Computing Frontiers, May 5 - 7, 2008, Ischia, Italy. [link]

 


Technical Reports

  • "Navigating the Grid Information Space: Design and Implementation of the Ovid browser." M. Dikaiakos, A. Artemiou, Technical Report TR-2004-08, Department of Computer Science, University of Cyprus, December 2004. [link]

 


M.Sc. Thesis (with Distinction)

  • Artemakis Artemiou, "Exploiting the Graphics Processing Unit for Efficient Execution of Decision Support System Queries." Department of Computer Science, University of Cyprus, September 2007.


B.Sc. Thesis (with Distinction)

  • Artemakis Artemiou, "Design and Implementation of a Browser for Grids." Department of Computer Science, University of Cyprus, June 2005.