ASP.NET Development Server Problems Under Vista

0
1 year ago
in
Recently I have started to do a bit of web development using Microsoft Visual Studio 2008.  However, whenever I tried to view the site (which uses the ASP.Net Development Server as I am running it from the File System), I was always getting an “Unable to Connect” error in FireFox. However, after [...]

SQL function to highlight text that has been searched for

0
1 year ago
in
The SQL Server function below, can be used to highlight text (while preserving the case) that has been searched for within a web page. For example: Source: “This is the source text” Search: “source” Function call: SELECT dbo.fnHighlightSearchText('source', 'This is the source text') Return [...]

Count of values within every field in a table

0
1 year ago
in
The Transact-SQL script below (written for SQL Server 2005), returns a list of the values and a count for each and every field within a table. You just need to change the schema name and table name, and specify a limit (if needed) for the number of values returned for each field. For [...]

Problem with “WordPress Automatic Upgrade” plugin after upgrade to PHP 5.3

1
2 years ago
in
Last week, the company I use to host my website upgraded from PHP 5.2 to PHP 5.3. When this happened, my web site went completely blank . I couldn’t get anything to appear, and couldn’t even log in to the dashboard. However, after enabled PHP errors, I discovered that the “WordPress Automatic [...]

REPLACE Multiple Spaces with One

0
2 years ago
in
I have just found a very useful article from SQLServerCentral.com, that goes through the process of replacing multiple spaces with one. “Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here’s a set based method for replacing [...]

Remove HTML Tags and Escape Codes from an Excel selection

0
2 years ago
in
The code below can be used to remove HTML tags and escape codes from an Excel selection.  Simply page the code into a new module, select the relevant cells to be processed, and press run. I would suggest that you copy the original cells to another sheet and then try it on the copy first, just to [...]

Microsoft Certified IT Professional – Business Intelligence Developer 2008

0
2 years ago
in
As of Tuesday 1st September 2009, I have gained the Microsoft Certified IT Professional (MCITP) Business Intelligence Developer 2008 Certification. This is on top of my MCITP Database Administrator and MCITP Database Developer certification that I gained last year.

SSIS Error When Sending Mail Through SMTP

0
2 years ago
in
Today, I came across this error, that occurred when running an existing SSIS package: Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: “Syntax error in parameters or arguments. The server response was: 5.5.4 Invalid Address” After lengthy [...]
Go to Top