Named parameters are a handy tool to deal with parameters especially for readability as each parameter value can be marked with the parameter tag. The concept of Named parameters has been in .NET from the first version; however they were used only with Attributes as part of the ECMA-334 specifications. In .NET 4.0 the concept … Continue reading Named Parameters
MS SQL Logging and Recovery
A common question on mind of database administrators is to find out the best way how to back up and recover your data. This document describes some basic concepts about Microsoft SQL Server logging and recovery. MS SQL Server provides three recovery models – simple, full, and bulk-logged. The simple recovery model is best suited … Continue reading MS SQL Logging and Recovery
Working with WMI classes
One way of obtaining management data and operation related to the Windows operating system is to use the Windows Management Instrumentation (WMI) classes. WMI can be considered as a database while the classes are like tables in the database. Therefore WMI can be queried to obtain specific table/class information. To use WMI classes in .NET … Continue reading Working with WMI classes
Using ToString() on the same item multiple times
In article String concatenation and int indirect cast it was shown how the ToString() can be used to improve the performance of a program by eliminating the need for the boxing concept. However, the ToString() can still hinder the performance especially when used multiple times to convert a data type or object into a string … Continue reading Using ToString() on the same item multiple times
Shrinking the Log file
MS SQL stores database changes into a log file that as more activity occurs on the database the larger the log file grows. When it comes to disk space limitations and performance this becomes a considerable problem. MS SQL Server provides a command to truncate the log file DBCC SHRINKFILE(<log file>, 0, TRUNCATEONLY) The command … Continue reading Shrinking the Log file