With just a few hours remaining for entering the new year 2012, I could do nothing else than preparing this blog post! In the end of every year, I gather up all my tweets for that year and post it here! It is a privilege to communicate with the SQL Server Community via all possible … Read more…
In this article, I present useful T-SQL knowledge for SQL Developers and DBAs. A few days ago I started writing an article that it would provide a set of useful tips on SQL Server topics that are met in the everyday life of DBA/Database Developer. The article is now completed and you can find it … Read more…
With SQL Server Denali RC0 released a few weeks ago, I am thinking of recording a webcast with topic its Database Engine features mainly focusing on the programmability area. To this end, I am conducting a poll in order to see if you are interested in attending such a webcast. If you are interested you … Read more…
In this article, we will be discussing about the following error message in SQL Server and how to easily resolve it: Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed… About this Error Message If you ever encounter issues when trying to create, add, or edit steps for a … Read more…
This article discusses about retrieving only the date from a datetime value in SQL Server. Why Converting Datetime to Date? There are many times where you might need to only retrieve the date from a datetime value. For example, you may have today’s datetime (2011-10-10 20:30:28.230) and you want to only get the following … Read more…
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…
Even though the SQL Server Database Engine automatically sets the best possible locking hints on the underlying database objects of the various T-SQL operations that executes, there are cases where we need to manually control locking as a part of the business logic in our T-SQL script. About the NOLOCK Table Hint A popular locking … 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…
The Story Behind Dynamic SQL Generator At some point in the past, in the early years of SQLNetHub, it reached 100.000 visits. Given this opportunity I decided to try to do something special, for example write a pretty cool article or even better, build a SQL-Related tool and make it available on SQLNetHub! Before talking … 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…
This article, discusses about the NOLOCK Table Hint in SQL Server. About Query Optimizer in SQL Server Each time you write and execute a T-SQL Query in SQL Server, the Database Engine selects the most optimized query plan for executing the query. The SQL Server Database Engine component that undertakes this task is the … Read more…
This article, discusses how you can resolve the error “Database [Database_Name] cannot be upgraded because it is read-only or has read-only files“. About the Error Message At some point in the past, I was trying to attach some databases on a SQL Server 2005 instance. The database files were copied over the network and … Read more…