I just got back from a Microsoft conference and I heard the following:

- Use RS on VS 2003

- it will installon VS 2002 without any error, but it won't work

So...

SELECT LOUD_COLUMN1, LOUD_COLUMN2, LOUD_COLUMN3

FROM LOUD_TABLE

WHERE LOUD_COLUMN1 = "SOME LOUD DATA"

Don't you think this is how code was written, say 20 years ago? And beside lower visual functionality, it's just plain...

Don't ever manipulate date through varchar without using a defined style, because it depends on the regional settings. This way it may or may not work on different servers.

Do it...

This is not a commercial, but check out mssqlXpress at http://www.mssqlxpress.com.

It's a great IDE for SQL Server with tons of goodies Microsoft will never implement. It also has it's...

While briefly reviewing your code I saw something funny. You are using varchar for date variable. This may work, but you mus be aware that SQL Server has to do...

Maybe this will help a bit: I have seen instructions on how to attach a read only database to SQL Server, but I don't remember the details.

So you could...

I have found out that SQL Server does a correct implicit conversion from varchar to datetime if you use XML date format:

'yyyy-mm-ddThh:mm:ss' (note the letter T between date and...

Instead of insert trigger works only when inserting new records. I won't do anything about UPDATE.

Doing constraints with UDF is easy. Just make a scalar UDF with one or more...

You may use SQL Server's internal locking semaphores by using sp_getapplock and sp_releaseapplock. This way you can delay second execution of SP. You can even set a timeout to wait...

Naming convention depends on the aspect, the way you "see" your objects through your code.

If you have an IDE that doesn't differentiate between table, view, sp, function, you have to...

I have a rule to allways create objects with encryption, but in development it is commented out: /*WITH ENCRYPTION*/ AS

At deployment time I just do a replace /*WITH ENCRYPTION*/ with...

Talking about Mission Impossible.

Data in the database is usually linked and dependant and any change affects it.

How do you think you can bring archived data back without affecting existing...

I agree that using lots of varchar(8000) for field definitions is generally bad. But I have some configuration or other special purpose tables where varchars may get very long, but...

Interesting article.

I just started using context_info a while ago when I found about it in the forum. I developed a UDF that I use in trigger to check for bypass....

My argument against it would be: you have to give the user permission to create objects. Do you want to do that?