I am currently learning F# and am starting to amass a selection of useful links. I though it would be handy to collate them all in the one place:
C# and F# Equivalents
I have ReSharper installed and think it is a great tool for productivity, but occasionally I find it useful to temporarily disable it to speed up Visual Studio (especially so on my old, slow laptop). This is achieved in two different ways, depending on the version of ReSharper.
In versions prior to version 5, ReSharper appears in the
Add-in Manager dialog, accessed via the
Tools menu. Using this dialog, you can uncheck the ReSharper add-in which will suspend it (the menu will still be visible, but its functionality will be disabled).
Checking it again will re-enable it. Both of these actions can be performed without restarting Visual Studio.
In version 5, ReSharper no longer appears in the add-ins dialog. At first glance, I though the ability to disable ReSharper was no longer available. As it turns out, it is now part of ReSharper itself and is accessed via the
Tools -> Options -> ReSharper -> General dialog. Clicking the suspend button will suspend ReSharper and disable its functionality. Once suspended, clicking the resume button will re-enable it.
This applies to all versions of Visual Studio - the difference is based on the version of ReSharper only.
A few years ago, I posted about how to extract the contents of an MSI file without having to go through the process of installing it. The tool used to do this was called Less MSIerables. This tool does do the job, but the UI is a bit clunky to use, it has a few bugs, and occasionally fails to extract the contents of a file. On top of this, it looks like this tool is not actively developed (it was last updated in 2005), so I recently started to look for an alternative.
It turns out that Microsoft provide this functionality as part of MSIExec that comes as part of the Windows installer. To extract the contents of any MSI file, simply run the following:
This will extract the complete contents of the MSI file to the specified directory.
Following on from my last post on the MDSN Low Bandwidth View, Scott Hanselman recently tweeted about the beta version of MDSN Lightweight View.
In a similar way to adding
(loband) before the
.aspx part of the url, putting
(lightweight) before the
.aspx part of the url will use the new lightweight view of MSDN, meaning a much neater and streamlined version.
In addition, Scott has previously posted about the other modes of MSDN:
|-||The normal MSDN view||Example|
|(loband)||A minimal view, focussed on speed||Example|
|(lightweight)||A faster lightweight view, including quick links to switch between languages and .Net framework versions||Example|
|(pda)||Aimed at PDAs and phones. Turns off the tree and allows a 100% width||Example|
|(robot)||Optimised for search engines||Example|
|(printer)||A printable version||Example|
|(ide)||Used when viewing inside the IDE. Adds send and give feedback links||Example|
Note that the dev10ide view Scott mentions seems to have been removed, and that the lightweight view is currently in beta, so may be liable to change.
Several months ago, I read a tip about passing an extra parameter on the url to MSDN documentation to put it into “low bandwidth” mode. I remember doing it at the time, but almost immediately forgot the url switch. That was until last week when I read Eric Nelson’s post on how to do it.
The trick is to put
(loband) before the
.aspx part of the url. For example, the low bandwidth version of
Once you have accessed it, you can persist it by clicking on the “Persist low bandwidth view” link.
Since Eric wrote his post, it seems that a “Switch on low bandwidth view” link has been added into the normal MSDN pages to enable it to be switched on without hacking around with the url.
The bug occurs when trying to delete rows from a table that has a
NULL value for an
image column. This works fine normally, but if there is a foreign key referencing the table (to any of its columns), any rows that have had their image column updated to be
NULL fail to be deleted. This SQL demonstrates the problem:
Not all of the delete queries work correctly. The output of the script is four result sets with the count of how many rows are in the table at each point. All of them should be 0 (as is the case on SQL Server 2000), but in SQL Server 2005 without SP3 they are actually 0, 3, 3 and 0.
The simple delete query:
does not delete any rows after the values for the Data column have been updated to
NULL, even though a similar select query:
Notably, if either the foreign key is removed, or the:
query is not performed, the script behaves as expected. Additionally, using
ntext instead of
image does not work as well, but using the new
varbinary(max) data types does work.
Apparrently, the distinction between
NULL values stored as a result of an insert or an update has precendece in the
If the table does not have in row text, SQL Server saves space by not initializing text columns when explicit or implicit null values are added in text columns with INSERT, and no text pointer can be obtained for such nulls. To initialize text columns to NULL, use the UPDATE statement. If the table has in row text, you do not have to initialize the text column for nulls and you can always get a text pointer.
This points to the “text in row” option having a bearing on this behaviour. Indeed, altering this option after creating the tables:
results in the script working as expected. Useful as a potential workaround.
The bug is present in all versions of SQL Server 2005, but not in SQL Server 2000 or 2008.
I recently visited a customer site to diagnose some problems with an application deployed on a server. Because I was effectively “visiting blind” in not knowing what was wrong or even if I would have internet access, I had to pre-empt any potential problems and take whatever tools I would need to diagnose them with me.
The following is a list of the tools I took:
This is an equivalent to running
netstat -nabv 5from the command line, but wraps a nice GUI around it with the ability to look up the host names for connected IP addresses.
This is a simple log file viewer that can “tail” a running log and apply highlighting based on custom searches.
This is a tool that comes as part of the Visual Studio SDK and enables a .Net application to be forced to run as 32-bit on 64-bit hardware. Existing applications can be tweaked without re-compilation.
This is one of my own tools that can launch an .Net application using a different culture/language. The culture and UI culture can be set independently of each other.
This is a small tool that comes with Visual Studio (when you install the C++ components). It enables Win32 error codes to be translated into “meaningful” English error messages.
Managed Stack Explorer
This is a tool that can preiodically capture stack traces from running .Net applications. It also shows a variety of information about the managed processes and threads running on a machine.
Red Gate Diagnostics Tool
This is a tool from Red Gate that collects lots of system information from a computer. It is very useful because of the amount of data that it collects all in one place.
This is like a cut-down version of Visual Studio. It has an IDE-like editor (with only basic intellisense) and can compile and run .Net applications. The biggest plus is that it requires no installation.
This is a tool that gives a visual representation of disk usage for a whole drive. This version is an older version of the tool, but is the last version that is free.
This is the famous SysInternals Suite of tools, now owned by Microsoft, but still occasionally updated with new features and bug fixes. This contains lots of file, disk, network, process, registry and system utilities.
This toolset (along with a few custom-written SQL scripts) provided me with everything I needed to collect all the information I needed to get to the bottom of the problems.
I’ve recently been trying to get automatic Windows updates working on Vista. Every time it tried to fetch the updates, it reported an error code of 80070057. After getting more detailed information from the WindowsUpdate.log in the Windows directory, the problem turned out to be the proxy server in our office. Whilst my user profile has the correct proxy server settings, the Background Intelligent Transfer Service (BITS) that is used to download Windows updates doesn’t. The solution is to set the proxy server for the system.
To see the current proxy settings, run from the command line:
If it says “direct”, there are no proxy settings and Windows update probably will not work.
To set the proxy settings, run from the command line (you will probably need to run this with administrative permissions):
This will set the proxy server on the system to allow the BITS service to connect to the Windows updates servers.
If you have ever run some SQL within SQL Server Management Studio only to realise that you’ve run it against the master database by mistake, you’ll know that it can sometimes be hard to undo the damage.
A simple way to stop these accidental changes is to create a database trigger that will prevent any schema changes to the master database:
Any time you attempt to change the master database, SQL Server will fail with an error. If you do want to make a schema change, simply disable the trigger and then re-enable it once the schema change is complete.
(NB. this only works with SQL Server 2005 and above)
I was editing a large SQL script inside Visual Studio today and needed to insert several spaces into multiple lines to make the script more readable.
Turning something like this:
I thought of doing it manually by hand, but as there were lots of lines to alter, I thought there must be a better way. I then remembered a feature of a word processor called ProText that I had many years ago on the Atari ST that had a feature called “Box Selection”. This enabled you to select text across multiple lines without having to select the whole line (a bit like drawing a box with the mouse).
A quick search later and I found the instructions on how to do box selections in Visual Studio in an article on Sara Ford’s blog.
Just hold down the Alt key whilst selecting text with the mouse and Visual Studio will switch from its normal “stream selection” mode into “box selection” mode. Once selected, you can indent the text using the tab key as normal and it will insert space to get the desired effect.