Latest News


[December 2, 2016]: My new article on SQLShack Journal: SQL Server consolidation – Hosting multiple databases on a single SQL Server instance.

[October 28, 2016]: My new article on SQLShack Journal: How to create and manage T-SQL code snippets.

[October 26, 2016]: My new article on SQLShack Journal: Securing SQL Server Surface Area.

[October 5, 2016]: Dynamic T-SQL Generator v2.0 is Now Out and its free!

[September 28, 2016]: My new article on MSSQLTips Journal: Script to Manage SQL Server Rebuilds and Reorganize for Index Fragmentation.

[September 21, 2016]: Snippets Generator v3.1 is now out!

[September 20, 2016]: My latest article on MSSQLTips Journal: Simple Experiment with SQL Server In-Memory OLTP is 79 Times Faster.

[September 15, 2016]: Artemiou Data Tools is now SQLArtBits! We are now a team and we are here to provide the world with highly-intelligent and powerful SQL Server tools! More info...


Projects


Artemiou Data Tools Artemiou SQL Books

Books


The SQL Server and .NET Blog eBook Series: Developing SQL Server The SQL Server and .NET Blog eBook Series: Administering SQL Server The SQL Server and .NET Blog eBook Series: Developing SQL Server


SQL Server MVP Artemakis Artemiou INETA EU

Cyprus .NET User Group The SQL Server and .NET TV Artemakis on Twitter The SQL Server and .NET Blog

 

 


More than twenty years ago I started a journey into Computer Science. I belong to the generation that started with a 386DX 40MHz, MS DOS 5.0, QBasic and Gorillas. Gorillas was a great game back then, however much greater was the fact that before running the game, you could see its QBasic code and experiment. The key word here is "experiment". It was because of that "experimentation" that all started...


Professional Qualifications and Experience

Over all these years I have experimented and developed software with many different programming languages like:

In 2002, I worked with SQL Server 2000 for the first time for a project at the University. Since then, I realized that Databases and Software Development would be my professional paths and started studying SQL Server and Databases technology.

From August 2005 to November 2007 i  worked as an ERP Developer/Consultant at a private IT company located in Nicosia, Cyprus. My responsibilities were:

From November 2007 to June 2010 I  worked as a Programmer/Analyst at a private IT company located in Nicosia, Cyprus. My responsibilities were:

Since June 2010 I have been working in the Information Technology Division of the Bank of Cyprus Group specializing on Advanced Database Systems. Currently, I work as a Senior Database Developer/Architect at the Data Warehouse Team.

I currently hold the following Microsoft certifications, all on SQL Server (development and administration):


Academic Qualifications and Experience

I hold a B.Sc. degree in Computer Science and a M.Sc. degree in Advanced Information Technologies both from the University of Cyprus.

In parallel with my undergraduate studies (2001-2005), I worked as a research assistant at the Laboratory for Internet Computing (formerly High Performance Computing Systems Laboratory) of the Computer Science Department at the University of Cyprus under WP2.3 of the CrossGrid project. I have worked there for two years under the same project designing and developing Ovid; a Browser for the Grid environment. Additionally, during my undergraduate studies, I received the third prize of the Cyprus Research Promotion Foundation's competition for undergraduate students research (www.research.org.cy) by presenting my research work " Ovid: A Browser for Grids ".

My B.Sc. Thesis (with distinction) had as a topic the design and development of Ovid; A Browser for Grid Computational Environments. Within the context of my research, I have developed the browser in Java implementing a variety of browser primitives. Additionally I have developed a network topology and visualization algorithm and a plug-in mechanism. This work has been published in Conference and Workshop proceedings. You can find more details in the Talks & Publications page on this website.

My M.Sc. Thesis (with distinction) has as a topic the exploitation of the Graphics Processing Unit (GPU) for efficient execution of Decision Support System (DSS) queries. Within the context of my Thesis I designed and implemented basic database algorithms like table scans, different types of joins, etc. for parallel processing by the Graphics Processing Unit (GPU). The outcome of these experiments was remarkable. If you are interested for more information, this research work has been published in Conference proceedings. You can find more details in the Talks & Publications page on this website.


Community Activity

I have always been a supporter of technical communities. I strongly believe that knowledge exchange within the community is the best way to learn new technology and solve complex tasks. Back when I was at the University, I maintained an MSN Group on C Programming which had more than 1000 members. I followed the same path on the Industry. Since 2008 I am an active blogger, author and speaker on SQL Server technologies. Additionally I develop free data tools that undertake simple, yet useful data-related tasks.

Furthermore, I am a SQL Server MVP since 2009, the president of Cyprus .NET User Group (CDNUG) since 2008 and the INETA Country Leader for Cyprus since 2010.

In October 1, 2013, I published my first eBook from the series "The SQL Server and .NET eBook Series" with title "Tuning SQL Server" and in December 2, 2013, I published my second eBook from the series "The SQL Server and .NET eBook Series" with title "Administering SQL Server".

In January 2014 I started the "Artemiou Data Tools" initiative. Artemiou Data Tools is my personal collection of tools that have to do with data processing and interaction with SQL Server. All the tools are designed and developed by myself and they all have a Community Edition which is free for download.

For more info on my community activity you can visit: