SQL
A while ago I was looking at versions of SQL Server Express (I forget why), and wondered when a 2008 version was going to be available. Well it seems there is a CTP version available now. Tags: SQL
Often when coding I’ll search for a snippet of code to avoid reinventing the wheel. Code re-use is good, right? From now on, whenever a search like that ends up sending me over to experts-exchange.com (which is a signup, members only site that shows the question text for all to see but masks the answers to entice people to sign up) I’m going to make an effort to write up a free version of the answer here. I really dislike that site, because all hits from there are a complete waste of time for a non member....
Way back when I was using the 2000 version of SQL Profiler I would always apply a filter to restrict my profiling by database id. On busy servers it’s simply the only way to fly. When I moved to using the SQL 2005 version of profiler I was quite shocked to find this option wasn’t visible. I did a bit of searching, but found nothing, and was in a hurry to get my profiling done - so I gave up. Whenever I’m using profiler there’s usually a...
Every time I go to install the non-express SQL 2005 Management Studio I end up fighting with the installer for quite some time. It's pretty tedious, and there are plenty of other people out there having this problem.
Previously I've managed to get the install process to work through various means, each time forgetting to document the steps I took. Turns out it doesn't matter, as there's a much easier method: "SQL 2005 Tools Install Experience is the suck" details an obvious and simple fix:
But I did find the answer! The trick is to browse to the Tools folder...
About a year back I wrote a quick post detailing a problem (and a fix) for an issue I was having with the SQL Server Web Report Viewer on Windows 2008 Server/IIS7 (the 'RSClientController is undefined' error). Most of the comments implied that the article helped people, however a few people weren't able to follow what was written. Partly because I wrote it very quickly at the time it was happening, and didn't grab a screenshot at the time. So I've just gone back and made a quick update to the article so that it now includes a bit...
LINQPad is a handy tool for anyone who works with LINQ: LINQPad is more than just a LINQ query tool: it's a code snippet IDE. Instantly execute any C# 3 or VB 9 expression or statement block! Best of all, LINQPad is free and needs no installation: just download and run. The executable is under 2MB and is self-updating. Fun! Tags: ASP.NET , SQL , LINQ
I love working with LLBLGenPro. However sometimes I go through a process of adapting what I want to do into LLBL speak. I'm still pretty new to using the tool, so I figured I'd throw up some of the more useful chunks of code relating to real world problems just in case someone else finds them useful. The Problem You have a list of entities, lets call them "Categories". You're dynamically creating a total related to these categories, lets say "the number of images in each category". Finally, you want to filter your result set (using LLBLGenPro -...
As a headline, it sounds pretty serious, but it's only support for Service Pack 0 (RTM) that's finishing on the 10th. The only people who should be concerned are people who have some specific reason for not being able to move to either SP1 or SP2. For 2000 shops, support for SQL2000 SP3a also ends on the 10th.
Tags:
SQL
SQL Server 2005 SP2 is now available for all versions.
Link: Microsoft SQL Server 2005 Service Pack 2
Link: What's New in SQL Server 2005 SP2
Tags:
Microsoft,
SQL
If you've ever had to work with reference data across multiple instances of the same application, or have simply needed to script data contained in a table, then you'll know what I'm talking about here. I've needed to do this a few times recently, and finally managed to come across something which does exactly what I needed. Here's the blurb from the description, which sums it up better than I have here:
This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data....
Full SQL Archive
About me
My name is Ross Hawkins and I'm a developer, consultant, business owner and writer based in Auckland,
New Zealand (pictured below!). My current work revolves around ASP.NET, C#, jQuery, Ajax,
SQL Server, and a mix of other Microsoft development technologies.
I also have about 15 years of experience with IBM Lotus Notes/Domino and associated technologies. While Notes/Domino
is no longer my primary focus I still like to dabble and keep my skills up to date.
I own and run 2 businesses - Hawkins Consulting Services,
and Ignition Development.
Search
Popular Content
Troubleshooting WebResource.axd
The .NET 2.0 framework changed the way clientside JavaScript is
delivered to the browser. Previously, ASP.NET 1.1 used the
aspnet_client directory whereas now 2.0 uses WebResource.axd.
Published on October 8, 2006
Microsoft AJAX Extensions: Sys.Debug is null or not an object
One of the breaking changes which was made with
the 1.0 release of the Microsoft Ajax Extensions was the renaming
of the 'Debug' class to 'Sys.Debug' for reasons of compatiability
with other frameworks. Breaking changes like this can often be a source of frustration..
Published on May 22, 2007
Simple ASP.NET Character Counter
A textbox character counter is a pretty simple piece of functionality, and there's a lot of different ways to apply one to your application. The following method is nice and simple, and can be done using only clientside JavaScript if required, or combined with server side code in order to create a more dynamic effect
Published on December 4, 2006
Adding Tooltips to Gridview Headers
As the title says, this is a very simple but dynamic way of achieving tooltip text on a header column. It's not overly flash, but it's lightweight and quick to implement.
Published on April 15, 2007
Archives
January, 2012 (3)
December, 2011 (3)
November, 2011 (8)
October, 2011 (9)
September, 2011 (8)
August, 2011 (5)
July, 2011 (4)
June, 2011 (7)
May, 2011 (5)
April, 2011 (3)
March, 2011 (8)
February, 2011 (4)
January, 2011 (3)
December, 2010 (8)
November, 2010 (5)
October, 2010 (6)
September, 2010 (7)
August, 2010 (11)
July, 2010 (12)
June, 2010 (8)
May, 2010 (8)
April, 2010 (4)
March, 2010 (8)
February, 2010 (6)
January, 2010 (12)
December, 2009 (13)
November, 2009 (11)
October, 2009 (12)
September, 2009 (12)
August, 2009 (2)
July, 2009 (7)
June, 2009 (12)
May, 2009 (9)
April, 2009 (9)
March, 2009 (9)
February, 2009 (8)
January, 2009 (7)
December, 2008 (6)
November, 2008 (7)
October, 2008 (9)
September, 2008 (12)
August, 2008 (9)
July, 2008 (6)
June, 2008 (24)
May, 2008 (13)
April, 2008 (16)
March, 2008 (8)
February, 2008 (10)
January, 2008 (1)
December, 2007 (14)
November, 2007 (11)
October, 2007 (11)
September, 2007 (13)
August, 2007 (11)
July, 2007 (5)
June, 2007 (15)
May, 2007 (11)
April, 2007 (9)
March, 2007 (9)
February, 2007 (10)
January, 2007 (8)
December, 2006 (18)
November, 2006 (11)
October, 2006 (14)
September, 2006 (9)
August, 2006 (10)
July, 2006 (4)
June, 2006 (4)
May, 2006 (6)
April, 2006 (3)
February, 2006 (6)
January, 2006 (10)
September, 2005 (2)
August, 2005 (4)
Post Categories
ASP.NET
AJAX
Amusing
NZ
NZ Trains
Notes/Domino
Visual Studio
Web Development
Miscellaneous
Me
Rugby
C#
SQL