Check our collection of high-quality articles on a variety of SQL Server topics. The collection is being regularly updated with new articles.
SQL Server 2012, among other introduced Sequence Objects. I am sure that sequence objects are widely known but let’s provide their definition in plain words: A sequence object allows you to set a global counter of values within the scope of a DBMS instance. Whenever you call the sequence object it returns a unique value … Read more…
In this article, we will discuss about using Proxy Accounts in SQL Server Agent jobs. We will talk about what this feature offers and how you can use it. Why Using Proxy Accounts in SQL Server Agent Jobs? When using SQL Server, in many cases you will might need to set up a SQL Server … Read more…
Hi! I hope you are all doing well and having a great summer time! It’s been a while since the last time I have posted an article but hey, besides the heavy workload, it’s summer time and the beaches in Cyprus are really great! 🙂 This post discusses about a quite simple task in SQL … Read more…
In this article, we will discuss about executing heavy set-based operations against Very Large Datatabases (VLDBs) in SQL Server. Introduction Recently I had to design and execute some heavy set-based T-SQL operations against a large number of very large databases (VLDBs) within a SQL Server instance. I won’t enter the debate of Row-Based vs. … Read more…
In this article, we will be discussing about using Unicode in SQL Server. Introduction Unicode is the standard used in the computing industry for encoding and representing any text in the most written languages (…). SQL Server supports Unicode, thus allowing the easy storage and manipulation of data in the most languages. Example … Read more…
Today is a very special day! I just got re-awarded with the Microsoft MVP Award on SQL Server for the third year in a row! —————————————— Dear Artemakis Artemiou, Congratulations! We are pleased to present you with the 2011 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their … 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…
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…
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…
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…
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…
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…
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…
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…