Classes vs Structs

Classes Only: Can support inheritance Are reference (pointer) types The reference can be null Have memory overhead per new instance class SampleClass { } Structs Only: Cannot support inheritance Are value types Are passed by value (like integers) Cannot have a null reference (unless Nullable is used) Do not have a memory overhead per new... » read more

C# Method Overloading

In c#, Method Overloading means defining a multiple methods with same name but with different parameters. By using Method Overloading, we can perform a different tasks with same method name by passing different parameters. Suppose, if we want to overload a method in c#, then we need to define another method with same name but with different signatures. In c#,... » read more

C# Inheritance

Basic Inheritance public class Animal{ public void Greet() { Console.WriteLine("Hello, I'm some sort of animal!"); }} public class Dog : Animal{ } Animal animal = new Animal(); animal.Greet(); Dog dog = new Dog(); dog.Greet();

Access Modifiers and Access Levels

The following access modifiers are available: C# Modifier Definition public The type or member can be accessed by any other code in the same assembly or another assembly that references it. private The type or member can only be accessed by code in the same class. protected The type or member can only be accessed... » read more

Windows Presentation Foundation (WPF)

Windows Presentation Foundation (WPF) is a graphical subsystem by Microsoft for rendering user interfaces in Windows-based applications. WPF, previously known as “Avalon”, was initially released as part of .NET Framework 3.0 in 2006. WPF uses DirectX and attempts to provide a consistent programming model for building applications. It separates the user interface from business logic, and resembles similar XML-oriented object models, such as those implemented... » read more

Model–View–ViewModel (MVVM)

View Model – Data View – XAML, bind to data-model Model – Business Logic MVVM facilitates a separation of development of the graphical user interface from development of the business logic or back-end logic (the data model) The Model View ViewModel (MVVM) is an architectural pattern used in software engineering that originated from Microsoft which is specialized in the Presentation... » read more

Domain Driven Design

Domain-driven design (DDD) is an approach to software development for complex needs by connecting the implementation to an evolving model. The premise of domain-driven design is the following: placing the project’s primary focus on the core domain and domain logic; basing complex designs on a model of the domain; initiating a creative collaboration between technical and domain experts to iteratively refine a conceptual... » read more

SQL Server Utility Explorer

Utility Explorer works inside of Management Studio, so it uses the same familiar interface that you already know. In Management Studio, to switch to the Utility Explorer, go up to the View menu, and then click on Utility Explorer. Using the SQL Server Utility application, they can gather information about the status, health and performance... » read more

SQL Server Activity Monitor

The SQL Server Activity Monitor gathers information about the monitored instance and displays the data in a series of collapsible panes.  Right Click Server -> Activity Monitor The Activity Monitor is split up into a couple of different panes. Overview Processes Resource Waits data file input output Recent expensive queries Active expensive queries

Database Waits and Deadlocks

Waits Waits occur when system resources are busy processing other tasks, and new tasks are placed into a holding queue until resources free up. Locks on data are the only reason a task will encounter a wait. Bottlenecks and hardware resources are also common contributors to a task having to wait before proceeding. A dynamic... » read more