↓ Skip to main content

Uncategorized

Fastest way to find the number of records in MS SQL

·1 min
Have you ever had a table to a lot of rows, when I mean a lot I mean over 1,000,000 records. If you try and perform a row count like SELECT COUNT(ID) FROM table it just takes forever.

LINQ to SQL v LINQ to Entities

·2 mins
Whatare the differences between LINQ to SQL v LINQ to Entities, well: LINQ to SQL uses tables as entities LINQ to Entities allows me to write C# LINQ queries that run against a conceptual data model.

LINQ Entity Framework

·3 mins
Microsoft has released it’s Entity Framework to the work, so does this mean the death of LINQ to SQL? Check out my blog on this, Death of LINQ to SQL So why is LINQ so good, well the problems with data has always been around the different and many way you need to know to interface and programme to. For example if you conntect to a Microsoft SQL Server database, you need to know SQL, to read and write to XML files you need to learn XPath or XQuery, to query Active Directory you need to know LDAP (Lightweigth Directory Access Protocol). To know all of these are more is quite a task.

Easy way to go from C# to VB

·1 min
Programming in different languages is not an easy process, often getting confused at which syntax to use. There are many online code converters

Woops, dropped iPhone

·1 min
Well it just had to happen, on Friday my iPhone slipped out of my hand and hit the floor flat on the screen. So a call to Apple support informed me that it will cost £206 to get repaired 🙁

Create SubVersion on an Internet machine via port 80

·2 mins
 It’s nice to use SubVersion locally, after seeing that CodePlex now supporting SVN over HTTP, I thought I’d give it ago. Here all all the steps for allowing you to use SVN via port 80 and SVN:

Simple LINQ 2 SQL example

·1 min
I’ve been using LINQ to SQL for some time, and each time I come back to the same example, so it’s about time I shared the example: // Create a DataContext. Northwind db = new Northwind();

Windows 7 available for download

·1 min
Following all the hype at PDC last year, Microsoft have not released Windows 7 Beta, download Cut to the chase and go directly to the download I’ve also managed to download a copy and place it on my server, but you’ll need a username and password to get the ISO file.

Windows 7

·1 min
We’ll I’ve not started with Windows 7 yet, but I’d thought I’d kick off with a cartoon

Development software for small startups

·1 min
Microsoft has released BizSpark, produced for the new start up development businesses that need to get going with all the latests technology. Providing the software, support and visibility required for a small business. http://www.microsoft.com/bizspark/Default/

Tracking Server Logins

·1 min
It’s nice to know who and when people are logging on to your servers, here is a very simple way of recording someone logging on and logging off the server Create a file called: logon.cmd

Googles hidden gems

·1 min
Chrome In the Google Chrome’s address bar type: about:internets (XP only) about:stats about:memory about:network about:histograms about:dns about:cache about:plugins about:version

How to create a Carousel in a webpage

·2 mins
The latest fad is to create Carousels to display images, and allow for easy navigation. I have not been able to find any .NET controls to enable you to create a Carousel on a web page.

Embedding javascript in an assembly

·1 min
I've always been able to create a standalone DLL control that can be reused in other web applications. I've never really found out how to embed other resources, or more to the point JavaScript files.

Generating an Audit for LINQ

·1 min
One of the tasks Jon was given was to create an Audit module for LINQ, and came across this link which seems to provide a solution. I’ve not had time to go over the solution, but it appears to do a very good job at first glance.

Small free and replacement for Notepad

·2 mins
Do you still use Notepad that ships with Windows? I did, until I found NotePad2, it’s fast, it’s easy to use, and more to the point it works. I’ve been using it for the past 2 months, and I have not got any clue to the features, but what I like about it is it just works and is a very good replacement for the standard Windows Notepad.