Handy piece of code for updating extended property for a table:

Click here to download code

SQL Server t-sql

Search engine collects historical resources

History history

Have everything you could possibly need and deliver around Ireland...and no I am not affiliated in any way.

http://www.quickcrop.ie/

Gardening gardening

Photography photography

To encrypt sprocs and functions prior to deployment include the WITH ENCRYPTION option:

E.g. CREATE PROCEDURE [dbo].[USP_TEST_ENCRYPTION]…

WITH ENCRYPTION

Any encrypted sprocs will then have the lock symbol next to them. Functions will appear the same but you

will get an error message box if you try to access the code.

SQL Server sql server

Interesting story about how Sweny’s has evolved to keep going…they now have readings of Ulysses each Monday morning:

QI qi

To check if a database exists, use the DB_ID() function:

IF db_id('AdventureWorks') IS NOT NULL
Print 'Database Exists'
ELSE
Print 'Database Does Not Exists'

SQL Server t-sql

Read it here

CSS css

Read it here

jQuery jquery

I had a problem configuring this locally in an organisation, turned out that McAfee was blocking it. Did the following and this fixed it:

Ensure that “Prevent Mass Mails from Sending Worms” is turned off in McAfee on the webserver

BlogEngine.NET blogengine.net, email