In our previous article MS SQL Logging and Recovery we showed how the logging mechanisms and recovery of MS SQL work. In this article we provide a demonstration of how log files work. The following steps demonstrates log file shrinking. Follow these steps in Microsoft SQL Management Studio. Step 1 Create database: create database [clounce] … Continue reading MS SQL Logging and Recovery Lab
Optional Parameters
When writing functions in C♯ sometimes one ends up putting parameters that might not be required all the time or when omitted would like to place a default value to these parameters. The way this is tackled is by using method overloads with different parameters. However, from the release of .NET 4.0 it is possible … Continue reading Optional Parameters
Named Parameters
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