Home
Snippets
Code Snippets
Hooked on the Cloud
Logout
Goto Hill Tech Studios

Snippets
- archive
- asp
- asp.net
- C-sharp
- CMD language (windows)
- css
- database
- ektron
- javascript
- jquery
- microsoft
- mobile
- powershell
- tools
- umbraco
- web design
- xml-xslt
- git
Code Snippets
Hooked on the Cloud
Logout
Goto Hill Tech Studios

database, sql and sqlserver

Key References

w3schools: SQL,

Snippets

ConnectionString: SqlClient
Create a row number
Create a user and grant dbreader/dbwriter
Fix "orphaned users"
Generating a GUID in DTS
Grant Execute on all stored procs to user
Kick SQL2008 locked users out for maintenance
Premium Search results
Quote to html entity
Row Length for each table

The Daily Grind

Search: Google, Bing, Yahoo,
Mail: Live, GMail, Roadrunner,
Social: delicious, twitter, linkedin, facebook
References: phone search, dictionary, grammar, maps, weather, radar

Web Dev/Admin

Support: DNSStuff, Netcraft, ServerMojo, Browser Stats, What Is My IP, MyBrowserInfo
Generators: GUID, Lorem Ipsum, Random Text, Random List, Passwords, Strings,
Domains: bustaname.com, namestation.com,
Validators: XHTML, W3C RSS, RSSBoard.org
References: HTTP Error Codes, SMTP Error Codes, Unix Commands, MIME Types, Roman Numerals, ASCII,
Calculators: Calculators/Converters, File Transfer Time, Broadband Speed

References

CSS v2, Javascript, HTML ( Entities), RGB, RegEx, MSSQL, XSLT
...by the way, Cheat Sheets rocks!!