Code Better
-
Recent Posts
Categories
Category Archives: Tools
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
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 assembly versions, visual studio, visual studio 2010
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
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
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
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
Moving a SQL Server Database with Encrypted Content: SMK, DMK, and You
Moving a SQL Server database with encrypted data is challenging, because the Service Master Key (SMK), which encrypts the Database Master Key (DMK) which encrypts the certificates and symmetric keys, uses local-PC information. Without the password, you can’t alter it; but you CAN back it up and restore it (with caveats). This article describes the encryption hierarchy, and the process to backup and restore the SMK. Continue reading
Generating a Build.Number File for NAnt
NAnt requires a build.number file. How do you generate or create this file? Simply create a file with a .NET assembly-style number, eg. 1.0.0.0, and you’re good to go. Continue reading
Adding Templates to Visual Studio Express 2010
You’ve probably read about Jeff Wilcox’s unit testing framework for Silverlight. It depends on a couple of templates being installed (one class, and one project). How do you install templates in Visual Studio Express versions? First, browse to %My Documents%\Visual … Continue reading
Installing XNA Game Studio for Windows XP 32-Bit
Looking for the 32-bit version of XNA Game Studio’s installer for Windows XP? Look no further — we have links here, both from the horse’s mouth (Microsoft’s MSDN) and from Travis Gockel. Continue reading