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…
There are cases where you might need to restore an entire SQL Server database (i.e. in the case of loss of data, etc.) on another SQL Server instance. A set of objects that are restored from the backup set and are included in the restored database are the database users. However, in such cases, the SQL … Read more…
In this article, we will be discussing about cleaning up the backup and restore history logs in the MSDB system database in SQL Server. The Necessity for Maintaining MSDB history Sometimes, there are cases, where it is reported to me that the MSDB database is huge and needs to be shrunk again back to … Read more…
Hello and Happy New Year 2010! Wishing you all the best, a new year full of health, happiness, success and even more SQL Server knowledge!!! 🙂 As this is my first blog post in 2010, I thought that it should focus on a really hot topic! I hope you will enjoy it! I called this … Read more…
This is a rather different post than the usual. As the end of year 2009 approaches, I decided to publish a selected number of tweets I did, grouped into different categories. It was a great experience to communicate with the Community, among other, by using Twitter. Throughout tweeting it was possible to easily and directly … Read more…
In this article, we will be discussing about the OUTPUT clause in SQL Server, and how we can use it for creating data archiving mechanisms. What is the OUTPUT Clause in SQL Server? The OUTPUT Clause in T-SQL as described in the relevant MS Docs article, “returns information from, or expressions based on, each … Read more…
Today I managed to pass the Microsoft Exam 70-433 – TS: Microsoft SQL Server 2008, Database Development and thus I got my third MCTS certification on SQL Server 🙂 This exam was all about database development using SQL Server 2008. While studying for the exam, I had the chance to try and learn more on … Read more…
This article, is an introduction to SQL Server PowerPivot and also a review of my session on the MS Momentum 2009 event, that took place in Cyprus. About the MS Momentum 2009 Event in Cyprus On November 26th 2009, Microsoft-Cyprus launched Momentum 2009; a New Efficiency Community Launch event. The event took place in Nicosia, … Read more…
In November 26th, Microsoft Cyprus will be hosting “Momentum 2009“, this year’s biggest event in Cyprus.The event features two tracks; (i) A track for IT Professionals, and (ii) A track for Developers. On the IT Professionals track, attendees can learn on how to increase productivity using innovations in Windows 7, Windows Server 2008 R2 and Microsoft … Read more…