I'm just in the middle turning a 2-tier app into a 3-tier app (it was planned all along, so it's been quite easy so gar). Anyway I added the service reference to my client project and wanted to reuse shared assemblies (which was a pain in the a** in ASP.net 2.0 Webservice - let me … Continue reading Add Web Reference instead of Service Reference in Visual Studio 2008
Year: 2008
‘MSDTC unavailable for SQL Express Transactions’ or ‘Who took my MSDTC settings on Vista?’
Greeted this morning by the following error after starting my unit tests "MSDTC on server 'LONDON\SQLEXPRESS' is unavailable.". Just moved development to a new Vista machine. Ok, that's usually solved quickly by activating Network DTC Access (side note: System.Transactions promotes to MSDTC if it needs too). On Win2003 and XP you opened up the Component … Continue reading ‘MSDTC unavailable for SQL Express Transactions’ or ‘Who took my MSDTC settings on Vista?’
Dynamic Data – GUIDs/uniqueidentifiers as primary keys
I primarily use a GUID (uniqueidentifier) as my primary key data type. You never know when you need to synchronize your data, and I'd rather be prepared by using a GUID as a unique global identifier. Anyhow, it seems that the brand new Dynamic Data (released today as part of .net 3.5 Service Pack 1) … Continue reading Dynamic Data – GUIDs/uniqueidentifiers as primary keys
Entity Data Model generated from SQL 2008 and used with SQL 2005
Ok, this is of course is not a perfect scenario, because ideally my dev and test environments should be identical to my live enviroment. But anyhow, I had some troubles with Entity Framework today. After deployment my WCF services just threw exceptions (have I ever mentioned that I don't like WCF for making everything including … Continue reading Entity Data Model generated from SQL 2008 and used with SQL 2005
Sync Framework is now RTM – Go check it out!
It has finally arrived. Sync Framework as of now is live and available for download at http://www.microsoft.com/sync. Check out the release post or download it directly here. This is great and gives me a really good reason to post some more. I hardly posted anything about the last pre-release but in August check back soon … Continue reading Sync Framework is now RTM – Go check it out!
Windows Server 2008 Terminal Server connections beep
Anybody else encounter the problem that when connected to a Windows 2008 server via MSTSC (Remote Desktop/Terminal Services) any dialog box causes your local machine to beep? I didn't help to switch off sound in the MSTSC settings or anything. It not only drove me crazy but I'm sure my office colleagues will agree a … Continue reading Windows Server 2008 Terminal Server connections beep
“SQL Server 2008 Agent will not accept DatabaseMail (bug in feb ctp?)” or “How to activate DatabaseMail using stored procedures/regedit”
I wanted to set up some error notification for a SQL Server Agent job this morning on our SQL Server 2008 (February CTP 10.0.1300) installation. It's fairly straight forward. First you set up database mail using the configuration wizard. Next you set up your operators. Now comes the interesting part that I had to troubleshoot. … Continue reading “SQL Server 2008 Agent will not accept DatabaseMail (bug in feb ctp?)” or “How to activate DatabaseMail using stored procedures/regedit”
Visual Studio Database Projects with SQL Server 2008 or ‘Why do I prefer Google Search?’
Ok, I'm going to mix some info with a little bit of remarks on search engines. First up, if you encounter an error when creating a Visual Studio Database Project with SQL Server 2008 telling you only version up to 2005 are supported, just download the Microsoft® Visual Studio Team System 2008 Database Edition GDR … Continue reading Visual Studio Database Projects with SQL Server 2008 or ‘Why do I prefer Google Search?’
Outlook Form Regions / User Properties / Add-Ins / Ribbons – A quick walkthrough
Code for this sample available here. Sorry it's on GigaSize, but in.solit.us is down, and SkyDrive registration gives me an error code 15. A couple of days ago I was asked at work about some troubles a team was having with user properties begin written by a form region control and not being able to … Continue reading Outlook Form Regions / User Properties / Add-Ins / Ribbons – A quick walkthrough
SQL Server Reporting Services 2008 Tutorial in 5 Minutes or "How to send my boss a report from a view quickly"
Some facts: SQL Server Reporting Services were great in the past. SSRS 2008 are better. MSDN is great. MSDN has lots of details. Sometimes it's too much if you are under pressure. Google usually gets me the information I want faster. Especially when I need to get something done quickly. All in all this post … Continue reading SQL Server Reporting Services 2008 Tutorial in 5 Minutes or "How to send my boss a report from a view quickly"
Tales from the travelling tech founder 
You must be logged in to post a comment.