MSBuild at sign and dollar sign and percentage sign

I found this great article that describes how these symbols works in Msmbuild

http://rationalgeek.com/blog/msbuild-propertygroup-itemgroup-item-metadata-and-crazy-syntax/

 

Searching all your functions and stored procedures

I found the INFORMATION_SCHEMA.ROUTINES truncates the data.

This however does the trick

select OBJECT_NAME(id) from sys.syscomments

where [text] like ‘%YourSearchString%’

Getting statistics on SQL queries for optimization

CHECKPOINT;
GO
DBCC DROPCLEANBUFFERS;
GO

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SET STATISTICS TIME ON

Wheels MCC Advanced bike training

Anybody that drives a motorized vehicle of ANY sort should go on a advanced training course.

I recently bought a bike (Honda VFR400 NC30) and got told about this event, that was run over 2 days.  It was organized by the Wheels Motor cycle club (http://www.wheels-mcc.co.za/).  It included information about first aid, traffic laws, maintenance of your bike, and most importantly helpfull advice and tips from people that have been doing this for a very long time.

It has made a tremendous impact, on my level of comfort in controlling my bike, especially in traffic.

Oh and being on the track is HIGHLY ADDICTIVE

Building and publishing your SSDT project, and building your SQL Metal classes

SET PathToDBCode=”C:\f1\cc\Data Layer”

@Echo Starting Deploy at %time%
@Echo ———————————————————————–
@Echo Off

REM Setting up enviroment variables
path = %path%;%systemroot%\Microsoft.NET\Framework\v4.0.30319;”c:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin”
CALL msbuild.exe /v:q /t:Clean,Build,Publish /p:SqlPublishProfilePath=local.publish.xml %PathToDBCode%\DB\CloudCoreDB\CloudCoreDB.sln”
@Echo Starting SQL Metal at %time%
@Echo ———————————————————————–
CALL %PathToDBCode%\Data\BuildBase\createdb.bat
@Echo All Done
@Echo ———————————————————————–
@Echo Giving permissions %time%
@Echo ———————————————————————–
CALL sqlcmd.exe -S. -E -dCloudCoreDb -Q “EXEC sp_addrolemember N’db_owner’, N’diauser’”
@Echo All Done
@Echo ———————————————————————–
pause

How to get GPS coordinates from google maps

I found this good post at this location:(http://forums.gpsreview.net/viewtopic.php?t=3632) the Author is David B. Robert

Hello everyone. I look forward to getting acquainted with this forum. This is my first post. I hope most of you will find it useful.
As a GPS owner I often like to find the coordinates of a location I’m traveling too beforehand. I’ve used Google Earth and Delorme Street Atlas USA in the Past.
Google Maps is so convenient, but unfortunately does not conveniently show the Latitude and Longitude of locations. However I’ve found this method that works real nice.
1. I open Google Maps to the vicinity of where I would like coordinates.
2. I use my right click mouse button and select “center map here” from the drop down button.
3. I past this javascript code that I keep saved somewhere convenient on my computer into my browser’s URL address window.
Here’s the code:
Code:
javascript:void(prompt(”,gApplication.getMap().getCenter()));

4. I click the “go to the address in the location bar” button usually to the right of the address.
5. A popup appears showing the coordinates of the center of the map like this: (43.60336, -110.7362)
6. I right click on the coordinates the copy and click either “OK” or “Cancel”
7. I then paste the coordinates into google’s “search maps” text box, remove the parenthesis and click “Search Maps”
8. A popup appears with a marker for the centered spot. The popup has the coordinates in both Decimal Degrees and Degrees, Minutes, Seconds.
9. I refine as and if necessary and I have my way point for inserting into my GPS.

I hope some of you find this useful. I know I do.

Best Regards,
David B. Robert founder of ProximityCast.com

t4 templating

A good article about t4 templating that I don’t want to lose

http://msdn.microsoft.com/en-us/magazine/hh882448.aspx