#SQL Server
19 posts from Sep 20, 2008 to Oct 13, 2013, newest first.
Creating a Compound NULLIF in AVG Function With SqlServer
My use case is I’ve got a session survey column on the Silicon Valley Code Camp session evaluation page.& 160; The results of a question like “How is this course overall” can be 0,1,2,3,4,5 where 0…
Using Redgate’s ANT .net Profile, Nails Memory Problem in 5 Minutes!
I recently added a cool new feature to our Silicon Valley Code Camp web site that lets attendees authenticate their accounts with the meetup OAuth api and then we track the meetups that add us (SVCC)…
Using IntelliTrace With Entity Framework In Visual Studio 2012
This is not a big deal, but I have recently bumped into several people that did not know about it so I thought I’d do a blog post just to show what it is and how is just trivial to use for useful…
Why I Can Never Leave ORCSWeb as My Web Hosting Company
1 min read #SQL Server#Sql Server 2008#hosting
Using Redgates Sql Compare for Complex Migrations with EF’s CodeFirst
2 min read #Best Practices#SQL Server#Entity Framework
Entity Framework Code First From Microsoft, Best and Worst Practices
3 min read #Visual Studio#SQL Server#Entity Framework
Gaining Some Control Back From Microsoft’s Entity Framework Code First, Name Your Own Foreign Keys!
3 min read #SQL Server#Entity Framework#Microsoft
Entity Framework CodeFirst Important Tip For SQL Execution Efficiency
2 min read #SQL Server#Sql Server 2008#Entity Framework
When Using EF CodeFirst With Visual Studio, How to Live With Cannot drop database because it is in use error.
2 min read #SQL Server#Entity Framework#SQL
Tip for Using SQLServer To Count By Alpha Names in a list
1 min read #SQL Server#Sql Server 2008#TSQL
My First Experience With SqlServer CE 4.0
2 min read #SQL Server#Sql Server 2008#.NET 4.0
Connecting To SqlServer From Web.Config Without a Password (Trusted Connection)
1 min read #SQL Server#Sql Server 2008#.NET 4.0
SqlAzure and a Best Practices way to deal with the Required Retries on Connections
7 min read #Best Practices#C##web
Writing A Transact SQL (TSQL) Procedure For SQL Server 2008 To Delete Rows From Table Safely
2 min read #SQL Server#Sql Server 2008#TSQL
Bravo for ORCSWeb! On so many fronts
3 min read #ASP.NET 2.0#ASP.NET 3.5#Code Camp Web Site Series
Load Balancing IIS Web Farm with EC2
1 min read #WebFarm#SQL Server#Cloud Computing
A Great New Book on Business Intelligence Solutions and Sql Server 2008 by Lynn Langit
1 min read #Best Practices#Book Reviews#SQL Server
First Experience with Visual Studio 2008 Database Edition, I love it!!!
4 min read #Best Practices#Visual Studio#SQL Server
LINQPad is Totally Awesome at Testing and Writing LINQ Queries
1 min read #ASP.NET 3.5#LINQ#Tools