Category Archives: Tools

Posts related to third-party and Microsoft tools, such as NUnit and Part Cover.NET

Building C# (not .NET Core) Apps in VSCode on Linux

You can use mono and xcode to build, run, and debug your C# applications natively on Linux (Ubuntu), through Visual Studio Code (VSCode) — without using the .NET Core Continue reading

Posted in Tools | Tagged , , | Leave a comment

Generating a Random DateTime in a Range in SQL Server

You can generate a random datetime (date and time) in SQL Server; you just need to use DATEADD a few times (once per component). The result is a truly random date and time. Continue reading

Posted in Tools | Tagged | Leave a comment

Powershell + InstallUtil: Unable to get installer types Error

Powershell gives an “unable to get installer types” error if you reference the v3.0 DLL instead of the v1.0 DLL in your project. Switch your reference to the 1.0 DLL and it should install without any issue. Continue reading

Posted in Core .NET, Tools | Tagged , | Leave a comment

Simple Strategies to Boost SQL Server Performance

SQL Server can be a beast on your disk. Two easy ways to help raise performance for high-volume databases: Use a drive other than the Windows partition for the SQL Server DB files, and split the MDF and LDF files onto different drives if possible. Continue reading

Posted in Platform, Tools, Topic, Web | Tagged , | Leave a comment

SQL Server Indexed Views and View Performance

SQL Server allows you to index views, which caches the results; what’s more, indexed views may automatically be included in queries at SQL Server’s discretion — no application changes required. Wow! Continue reading

Posted in Tools, Web, Wndows Forms | Tagged | Leave a comment

Visual Studio Automatic Version Numbering

Visual Studio (2010+) allows you to specify that it should generate (incremental) build versions for your projects. The syntax is quite simple (for AssemblyInfo.cs), but there are a few caveats to know. Continue reading

Posted in Silverlight, Tools, Web, Wndows Forms, WPF | Tagged , , | Leave a comment

Integrating NUnit with CruiseControl.NET

Interested in using CruiseControl.NET to execute NUnit tasks and integrate the results in the dashboard, without using the nunit task type? You can do it through exec, if you merge the results. This article outlines how. Continue reading

Posted in Silverlight, Tools, Web, Wndows Forms | Tagged , | Leave a comment

Dropping an Active Database in SQL Server

How can you close open/active connections in SQL Server and drop the database? With a little statement like SET SINGLE USER. You can also abort transactions and force the database to drop immediately. Continue reading

Posted in Tools | Tagged | Leave a comment

Searching the Entire SQL Server Database

How can you search every row and column in a SQL Server database for a specific string? Well, we link you to a handy dandy SQL stored procedure that does just that! Invoke it, and be amazed! Continue reading

Posted in Tools, Web, Wndows Forms | Tagged , | Leave a comment

Selecting Encrypted Columns in SQL Server

Decrypting columns in SQL Server requires a security key and security certificate. You need to convert the resulting value into the correct type; we explain the process, and summarize what you need and how to do what you need to do. Continue reading

Posted in Tools, Web, Wndows Forms | Tagged , | Leave a comment