Discover SQL Server Filegroup Separation Secrets: What and Why?

sql server filegroup

The default settings in SQL Server are not always the best. Such is the case when we are working with new user databases; usually we get a single data (*.mdf) and transaction log (*.ldf) file. The data file resides within the PRIMARY file group; the only one we have so far, and it will store … Read more

5 SQL Server Isolation Level: The Usual Suspect Cheat sheet

sql server isolation level

SQL Server isolation levels are used to define the degree to which one transaction must be isolated from resource or data modifications made by other concurrent transactions. The different Isolation Levels are: Read Uncommitted (or nolock) Read Committed Repeatable Read Serializable Snapshot Read Committed is the default isolation level. The write behaviour of all transaction … Read more

Thunk and Currying – Know Your JavaScript!

thunk

Thunk A thunk usually refers to a small piece of code that is called as a function; does some small thing; and then JUMPs to another location; which is usually a function; instead of returning to its caller. Assuming the JUMP target is a normal function, when it returns, it will return to the thunk’s caller. The word … Read more

Inheritance/ Interface/ Composition – Releasing the Ever Confusing Knot!

interface

Terminology In layman’s terms: Interface is for “can do/can be treated as” type of relationships. Abstract ( as well as concrete ) classes are for “is a” kind of relationship. Look at these examples: Bird, Mosquito and Horse are Animals. They are related. They inherit common methods from Animal like eat(), metabolize() and reproduce(). Maybe … Read more

Dependency Injection Life Cycle: The more you know!

dependency injection

Dependency Injection (DI) is a pattern that can help developers decouple the different pieces of their applications. “Dependency Injection” is a 25-dollar term for a 5-cent concept. It means giving an object its instance variables. Really. That’s it. Classes have these things they call methods on. Let’s call those “dependencies.” Most people call them “variables.” Sometimes, … Read more