Archive for March, 2009

A reference to the master.dbschema (or similar, see below!) is necessary for database projects in Visual Studio that reference system objects. Here’s how to add those objects without slowing everything down.

In the March edition of MSDN we provided an overview of Server Projects and how to reference the master.dbschema file to resolve references to system objects. If you have a project that references the master.dbschema file, you may have noticed it takes a while to establish this reference. You may have also noticed the project may not load or deploy as quickly as it did before referencing the master.dbschema file. This is because when referencing the master.dbschema file you are adding all the system objects found in a typical SQL Server instance to your database model in Visual Studio. The number of system objects defined in the master.dbschema file greatly outnumbers the user created objects for many database projects. If you have multiple projects referencing the master.dbschema file this can be compounded as each projects reference to the master.dbschema has its own copy of the database model in memory.

via VSTS: DB Best Practices : Right sizing the master.dbschema file for better design time performance.


Read Full Post »

I spent an embarrassingly long period of time trouble-shooting my Sql Server install only to find the problem was the Windows Firewall.

Firewall systems help prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.

To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. The firewall is a component of Microsoft Windows. You can also install a firewall from another company. This topic discusses how to configure the Windows firewall, but the basic principles apply to other firewall programs.

via Configuring the Windows Firewall to Allow SQL Server Access.

Read Full Post »

Worked like a charm!

If your Visual Studio either VS2005 or VS2008 is missing some default tempates, or whenever you want to add any new item and click add new item you are surprise to find that either your add new WebForm is missing or any other similar item is missing from the add new item list then your templates defaults are corrupted due to some reasons or latest updates or patches or any other software which you have recently installed.

via SmallWorkarounds: Visual Studio is missing default templates.

Read Full Post »

This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to identify the specific edition if you are using Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.

via How to identify your SQL Server version and edition.

Read Full Post »

This had nothing to do with what I’m supposed to be doing but it popped up in my Google results and the post looked so interesting I had to pass it on, especially since this is an issue I might be dealing with in the mid-term.

In an ongoing project, I had to struggle with quite a few dependencies between objects, mainly with regards to validation. As a result, I came up with a generic solution based on lambda expressions.

via hardcodet.net » Blog Archive » Tracking Inter-Object Dependencies using Expression Trees (Part 1).

Read Full Post »

Fantastic add-in for generating code comment templates, I use this constantly. Thanks Roland!

GhostDoc is a free add-in for Visual Studio that automatically generates XML

documentation comments for C#. Either by using existing documentation inherited

from base classes or implemented interfaces, or by deducing comments from

name and type of e.g. methods, properties or parameters.

via Roland Weigelt’s GhostDoc.

Read Full Post »

While I historically have used the excellent Daemon-Tools for mounting iso’s and other disk image formats this looks to be a lighter-weight and advert free alternative. I think I’ll give it a try.

Virtual CloneDrive works and behaves just like a physical CD/DVD drive, however it exists only virtually. Image files generated with CloneDVD or CloneCD can be mounted onto a virtual drive from your hard-disk or from a network drive and used in the same manner as inserting them into a normal CD/DVD drive.

Probably the best virtual drive software, Virtual CloneDrive allows you to enjoy the freedom of a virtual drive and is completely free.

via SlySoft Virtual CloneDrive.

Read Full Post »

Older Posts »