LessThanDot Site Logo


A decade of helpful technical content

This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.

Dealing with Cannot resolve collation conflict for equal to operation errors

This was asked on twitter recently and I gave the answer there. I decided to write a blog post about this because I can use over 140 charaters here instead. You will see the Cannot resolve collation conflict for equal to operation error when you try to join 2 tables. let’s take a look at what we need to do to resolve this. First create and populate these two tables


Intranet Makeover: Virtual Web Sites with Custom DNS Names

Why make your users interact with URLs such as: http://companyweb1/mainsite/repository/main.html when they could just type repository? The Mess Your corporate intranet probably has a lot of different resources on it. Wherever those are, users have to gain access to them somehow. And there are several issues that can reduce ease of access, whether the resources are whole web sites or individual web pages. If resources are mainly grouped together on one site, then you have to deal with problems like:


LessThanDot Re-Design

LessThanDot has had a stable layout and design for a couple years now, giving all of us time to get used to buttons being in certain places, new items appearing in certain areas, and a general feel for where links and sections will be before we open a page. Many experts will (and in fact recently have) said that executing a massive redesign of a website is dangerous once it has received a following and made a brand impression on that following (then again other experts write articles on their redesign process or what to do when re-designing, so I guess it depends on who we are going to listen to).


Windows 7 Launch In New York City

This post is not a review, you can find detailed reviews all over the internet, this is just about the Windows 7 launch in New York City which I attended today. If you click on the pictures you can get larger sizes. I am running Windows 7 on all my home machines since it became available from MSDN in August. I think that this is the best operating system that Microsoft created yet, you can tell that 8 million people have beta tested this puppy.


Setting trust between 2 windows server 2003 domains results in "The specified user already exist"

So yesterday we were setting up a trust between my domain and another domain. Both were Windows Server 2003. In prinicipal this is a very easy task but sometimes you get the most interesting error messages. Like this one. The specified user already exists After googling for a while we ended up with no real answer. A lot of maybes and pointers to search in a certain direction.


Application.StartupPath and Nunit

In some cases, you want to have a file in your Startupfolder that you want to access from within your application. Perhaps an XML-file with application settings or an image that can be changed. In most cases the application startuppath will be in program files so you don’t really want to put too much stuff in there but from time to time, you might. And I always like to test if the pesky file is configured right, so that it appears as a file in that folder.


Visual Studio 2010 and .NET Framework 4 Beta 2 Available on MSDN

Microsoft announced the immediate availability of Microsoft Visual Studio 2010 Beta 2 and Microsoft .NET Framework 4 Beta 2 to MSDN subscribers; general availability will follow on Oct. 21. The company also outlined a simplified product lineup and pricing options for Visual Studio 2010 as well as new benefits for MSDN subscribers, including the Ultimate Offer, available to all active MSDN Premium subscribers at the official product launch on March 22, 2010.


Series of "Bad habits to kick" by Aaron Bertrand

I commend Aaron Bertrand (blog and twitter) for his latest series of blogs titled, “Bad habits to kick”. These types of blogs are always good for even the experienced groups. I say that because I can pretty much guarantee that some of you are doing the things he points out in this series. You may not know you do them or even understand the fact they are bad habits but I can say for sure, this is a great way to find out what they are and the explanations needed to get you out of the habits.


How to Monitor Database Mirroring

This morning I came into work and went through my usual 100 or so emails. One of the emails was from MSSQLTips.com, it was on how to monitor SQL Server Database mirroring with email alerts. By Alan Cranfield. While agree with Alan that every DBA should monitor their database mirroring with email alerts I disagreed with his method. He had the DBA create a job that was scheduled to run at some interval throughout the day.


SQL University and why you should be attending

Jorge Segarra (@sqlchicken on twitter) has put together something called SQL University over on his site at sqlchicken.com. SQLU as it has been tagged is and will be a compilation of classes put together by a highly respected group of DBAs around the SQL Server community focusing on the basics. When I look at the faculty names I can honestly say these people will not send you in the wrong direction.