As this is my 100th post on this blog, I decided to write an article which is rather different than the previous ones. It was quite difficult to decide the topic for this post as there are so many aspects of the Database Technology that can be discussed. Finally, I decided to write on the … Read more…
Sometimes I get asked; “Hey Artemis, are you a SQL Server Administrator or a Developer?” I then answer: “none of the two” 🙂 I would rather prefer calling myself a Data Architect as I believe it is more accurate. In a relevant article I posted a year ago, I talked about the responsibilities of database … Read more…
In this article, we will be discussing about eliminating blank spaces in SQL Server table records and columns. About Blank Spaces Blank spaces always needed special handling in many programming languages. This is not an exception in the case of the SQL programming language. In SQL Server, a variety of built-in string functions exist … Read more…
SQL Server 2008, among other introduced significant security changes that enhance the database administrators applying an even stricter security policy on the SQL Server instances. This article discusses the security changes in SQL Server 2008. Major Security Changes in SQL Server 2008 Besides the changes in the Windows local groups that are created during … Read more…
DevReach 2010, the premier developer conference on Microsoft technologies in Central and Eastern Europe will be taking place on October 18 and 19 in Sofia, Bulgaria. This year, DevReach celebrates its fifth anniversary. To this end it has a new fifth track!The event includes 60 unique sessions with more than 30 rock star speakers! DevReach … Read more…
In this article, we will be discussing about how you can change the Database Owner in a SQL Server Database. About the “dbo” User in SQL Server In SQL Server, the dbo (Database Owner) is a special user that has all the necessary permissions to perform all activities in the database. This user exists … Read more…
A great CDNUG event took place on July 15, 2010! As it was the last event before summer holidays, it was a celebratory one of course! After having some sweets and Greek frappĂ© coffee, the event started! Due to the nature of this event, we had two sessions. The first session, dedicated to Windows 7 … Read more…
It’s been a while since my last post but I’ve changed job a few weeks ago and I was in the process of adapting to the new environment 🙂 OK! It is time to sit back, relax a bit, have a cold beer, put some music on, and start writing! A few weeks ago the … Read more…
Some time ago Red Gate released SQL Search, a SSMS add-in that allows the user to search for fragments of text within database objects in a SQL Server instance! Yes, I know, this is cool! 🙂 There are many scenarios where the tool can come in handy. For example, imagine trying to perform a modification … Read more…
In this article, we will be discussing about a special security feature in SQL Server, that is Policy-Based Management. Some time ago I promised publishing a post on Policy-Based Management in SQL Server. Well, it’s time to fulfill my promise! 🙂 This is a rather large post, I hope you find the information it contains … Read more…
So here I am thinking of the next event. Should it be a topic on a new .NET Technology? A topic on a SQL Server 2008 R2 feature maybe? When should I deliver my next webcast? Which is the next local or regional event am I going to attend? As I am thinking the above, … Read more…
A few weeks ago I got asked to present on Microsoft DevDays 2010 in Cyprus. DevDays is the biggest event in Cyprus for Software Architects and Developers. This year, the event features many hot topics such as: Visual Studio 2010 Windows Azure and Windows Identity Framework Interoperability and how to run PHP Applications on Microsoft … Read more…
Today is a very special day! I am proud to announce that I received the MVP award for the second time in a row! ——————————————————————- Dear Artemakis Artemiou,Congratulations! We are pleased to present you with the 2010 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, … Read more…
This post is a follow-up to one of my previous posts, titled: “Using PowerPivot’s Copy-Paste Support for Importing Data from Word” and this time, we will be discussing about building data relationships in PowerPivot. To this end, in this post we will see how we can import data from Microsoft Word using PowerPivot’s copy-paste feature, … Read more…
In this article, we will be discussing about using PowerPivot’s copy-paste support for importing data from MS Word. Importing Data into PowerPivot One of the great features of SQL Server PowerPivot is that it supports importing data directly from the clipboard. This is quite handy in cases you want to import and analyze data … Read more…