SQL Server: Schemas, DELETE vs. TRUNCATE, Generate INSERTs, and NOT IN vs. NOT EXISTS

Schemas Data Organization Using Schemas best explains with clear examples what schema in SQL Server is.  Important things to note are: Schemas were first introduced in SQL Server 2005. dbo in pre SQL Server 2005 was used as the default database owner but now it is used as the default schema. Schema is analogous to …

Continue reading SQL Server: Schemas, DELETE vs. TRUNCATE, Generate INSERTs, and NOT IN vs. NOT EXISTS

Advertisements

The Very Basic Syntax of Razor

If you have worked in ASP.NET MVC, you know that the default view engine (or templating engine) is Razor, much like the .aspx/.ascx/.master file templates in ASP.NET Web Forms.  One thing I like about Razor is that you can use C# or VB.NET as the programming language to code in Razor.  All you need to …

Continue reading The Very Basic Syntax of Razor