At some time in the past, I set up a maintenance plan in one SQL Server instance for rapidly tuning up a set of databases with some simple tasks such as index rebuild, etc., and I got the error message: “No global profile is configured. Specify a profile name in the @profile_name parameter”. About … Read more…
[Update 2018] Please visit Snippet’s Generator page for the latest release of the tool and much more. T-SQL code snippets is a very handy new feature originally shipped in SQL Server 2012. Using code snippets you can save time when you write code and you just need to enter code that does common tasks. Code reuse has … Read more…
Hello and Happy New Year 2011! Wishing all the best, always in good health! Microsoft has recently released CTP1 of SQL Server 2012 codenamed “Denali“. This new version of SQL Server Server introduces many new features that increase productivity and reduce the development and administration effort. One of my main observations is that there is … Read more…
Well, I guess that’s it. It’s time to say goodbye to 2010 and welcome a brand new year: 2011! Like last year, in this post I am presenting a set of selected tweets I did in 2010 grouped into different categories. Again, it was a great experience communicating with the SQL Server Community among other, … Read more…
This article discusses about dynamically generating T-SQL statements for SQL Server database administration and development purposes. Why Dynamically Generating T-SQL Statements? So you have many databases, objects, etc. and you want to massively administer it right? In some of my previous posts I explained the undocumented stored procedures “sp_msforeachdb” and “sp_msforeachtable” that allow you … Read more…
Lately I have been dealing a lot with SQL Server development that involves among other, segmenting strings. So, I decided to post an example-based article that discusses some simple ways of segmenting strings with T-SQL mainly by using the SUBSTRING built-in function and some other built-in functions such as CHARINDEX, LEFT, RIGHT and LEN. Additionally, … Read more…
Cyprus .NET User Group (CDNUG) brings another event to you, by/for the Community! This month’s event features two sessions: Microsoft and Openness Clustering in SQL Server 2008 The first session, with speaker Andreas Hadjipanayi (Technical Account Manager at the local Microsoft Office in Cyprus) discusses how Microsoft has become more open over time. The major discussion … Read more…
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…