Frederick Chapleau weBlog on IT.

Deleting without generating log entries in log files

2009-06-24T14:19:21Z

10000 rows at a time.

DECLARE @i INT
SET @i = 1

SET ROWCOUNT 10000

WHILE @i <> 0
BEGIN
DELETE FROM dbo.table

SELECT @i = @@ROWCOUNT
END

SET ROWCOUNT 0

-f.

One of the best way to disconnect Idle Sessions

2009-06-01T17:13:09Z

Go to Start - Programs - Administrative Tools - Terminal Services Configuration.
Right Click on the RDP Connection and go to the sessions tab.
That will create server wide settings and you can choose to over ride individual user settings.

Yesss, and it works even on a standalone server.

-f.

JSON Extension Methods

2009-05-31T02:55:00Z

Just a little sample, modified from the ScottGu…

public static class JSONHelper
{
    public static string ToJSON(this object obj)
    {
        JavaScriptSerializer serializer = new JavaScriptSerializer();
        return serializer.Serialize(obj);
    }

    public static string ToJSON(this object obj, int recursionDepth)
    {
        JavaScriptSerializer serializer = new JavaScriptSerializer();
        serializer.RecursionLimit = recursionDepth;
        return serializer.Serialize(obj);
    }
}

-f.

Windows 7 is Windows 6.1

2009-05-28T12:33:51Z

Hum... and then everybody imagine, that Windows 7 is a completely new operating system!

Really a great marketing boom.

-f.

Running Python 3 extensions on IIS 6

2009-05-28T04:19:00Z

Python files can be run, without using Iron Python on IIS.

The first step is to install... Python 3.

After that you must enable the extension by going to Web Service Extensions and Allowing “All unknown CGI Extensions”

Third and last step, is a modified version of the MS Article... that date back to 2006.

Verify that application mapping for .py files is set up. To do this, perform the following steps:

In the ISM, under Internet Information Server, right-click the computer name, and then click Properties.
From the Master Properties drop-down list, click WWW Service and then click Edit.
Click the Home Directory tab, and then click Configuration.
To add the application mapping, click Add, and then create a new mapping by using the following information (substituting the correct path on your computer):
- Executable: "C:\Python3\python.exe” %s %s (The two "%s" after the executable are required for console-based script interpreters but would not be required for an Internet Server API [ISAPI]-based script interpreter).
- Extension: .py
- Script engine: selected.
- Check that File Exists: selected (for security) Click OK.

-f.

"Object of type 'System.EventHandler' cannot be converted to type 'System.EventHandler`1"

2009-05-11T18:32:11Z

Ok, that really, really a big issue in the .NET Framework.

You cannot use a generic event handler, with a name ending by “changing”, when it is used as a data binding object on a form.

Really disappointing that those guy rely on event names.

No Comments.

-f.

Ref: http://social.msdn.microsoft.com/Forums/en-US/winforms/thread/51cce2f7-04c8-4703-882f-6c72ee6a1f8b

Did you know F# ?

2009-04-30T12:47:56Z

I found a great article comparing C# and F#… thanks to Brian McNamara.

-f.

Implementing an Extension to Sort ControlCollection in .NET 3.5

2009-04-24T15:50:54Z

public static class SortingExtension
{
    public static void Sort<T>(this System.Windows.Forms.Control.ControlCollection c) where T : class
    {
        for(int i=1; i<c.Count; i++)
        {
            IComparable<T> ctl = c as IComparable<T>;
            T pCtl = c[i - 1] as T;

            if (ctl != null && pCtl != null)
                if (ctl.CompareTo(pCtl) > 0)
                    c.SetChildIndex(c, c.GetChildIndex(c) - 1);
        }
    }
}

I will detailed a little more later this implementation.

-f.

Random error on ReportServer

2009-03-27T20:46:00Z

w3wp!processing!5!03/27/2009-15:24:24:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)

This is fixed in the Service Pack 3 release of SQL Server 2005…

-f.

The Web 3.0 is coming

2009-02-26T14:27:15Z

As stated in a previous post, the web 1.0 was the first plain version, the second the more dynamic one, with social networks and the famous buzzword "AJAX", and the version 3.0 buzzword is... (drum roll)... Cloud Computing.

The concept is simple: Develop your application and Deploy it using their resources.

There is many clouds available... the main three for the moment are:

Microsoft: Azure Services Platform

Google: AppEngine

SalesForce: Force.com

-f.

When unit tests are not recognized

2009-02-07T21:51:48Z

Yes, you can create unit tests inside a project, without creating another project. But there is a tweak, when VS 2008 create the Unit Test Project, the resulting project have two Project Types that are included in standard project. If you don't modify your project to include them, the unit test framework of VS 2008 is not recognizing your Tests, even if they are correctly formated (proabably because the engine is only checking the unit tests project types).

Here is the project types...

-f.

MSVCR71.dll

2008-12-31T18:22:46Z

If an error occured when running a program that is using the version 7.1 of the runtime, you must intall it to get it work.

But the problem is, where is the runtime?

Yes, it is only available/included with .NET 1.1! So get it, install it, and it should work. Also, guest what... it's not installed by default in Windows Vista ;)

-f.

Dundas Chart included in .NET 3.5

2008-12-09T18:10:03Z

There was a great new on ScottGu' Blog, that was stating that a new, and free Charting component, based on the Dundas Charting Component, which was bought by Microsoft a few month ago.

This is a really great suite of charting component, that is already included in SQL Server 2008.

http://weblogs.asp.net/scottgu/archive/2008/11/24/new-asp-net-charting-control-lt-asp-chart-runat-quot-server-quot-gt.aspx

-f.

Moving the Viewstate or a SEO technique

2008-12-09T17:06:25Z

Viewstate is a core concept of ASP.Net, but it can be a waste of bytes, when we know that some search engines are only indexing the top of the pages.

This can be done easily, and Scott Hanselman did a really good test on how to do that better.

http://www.hanselman.com/blog/MovingViewStateToTheBottomOfThePage.aspx

-f.

C.0.8.54 expected C.0.8.52

2008-11-19T22:20:58Z

Another Google Catcher page catcher.

When Installing Report Server and applying the SP2, this may occurred when you restore a backup from another SQL 2005 RS SP2 database.

The answer: you installed the CTP2 of the RS 2005 SP2, check out the latest one, and install it, this should be solved.

-f.