I am glad to announce that I will be speaking in Bulgaria again. It is a pleasure to be
[More]
I am honored to be selected as one of the speaker at SQLSaturday Slovenia this December. This event
[More]
I am honored to be selected speaking at SqlSaturday Bulgaria this October. This event is going to be
[More]
I love to set up MDW on SQL Server because it is worth for the data collection overhead most ca
[More]
Well, where to start…. I have had opportuinity to interview dozens of candidates for DBA and develop
[More]
I was working on a big project of mine, automating some kind of data collection from SQL Server with
[More]
While I am on vacation I saw a SQL Server which was not able to start. It reminded me to my last yea
[More]
I work with Microsoft Project Server 2010 and found that there are some undocumented limitations. We needed to add a new ECF (Enterprise Custom Field) and named it to ParentProjectUID. This should work without any problem, but it does not! I think it...
[More]
Couple of years ago I needed to implement a kind of fuzzy matching algorithm in SQL Server. Today I have just found my code I implemented it in SQL 2005 and it works on newer versions as well. Code is based on the Damerau–Levenshtein distance algorit...
[More]
Locking is a necessary thing for better concurrency. SQL Server manages its locks automatically. In general: when a statement issues about 5000 locks on a single table or index, lock manager issues an escalation. Lock escaltion details can be found i...
[More]