Skip to content

Blog

Little SQL Server Tricks: The WITH (NOLOCK) Hint

Consistency is an important part of data storage. That is why READ COMMITTED is the default transaction isolation level in SQL Server. This level prevents you from retrieving values that modified inside a transaction but not committed. However, what is great for consistency is a pain for debugging.

Pre-Compile Your Views in ASP.Net MVC

The default behaviour for views in ASP.Net MVC up to version 5 is that they are compiled when the first user requests them in IIS. When the view isn't that complicated, the user only experiences a minimal delay before the web page is displayed in the browser. That is true as long as the view compiles. If not, your users will get a page like this one:

Compilation Error

Do Something Good for You: Use a Password Manager

A year went by since I blogged about "How many of your Accounts have been Compromised in a Data Breach?". At this time there where ~4 billion usernames and passwords collected on the site "Have I been pwned?" (or short HIBP). Since then, Troy Hunt could add another 1,500,000,000 accounts to the list. That is an enormous number and shows how big the problem of “lost” usernames and passwords is.

This post should help you to minimise the effect of a data breach. They happen all the time and when you reuse your passwords, those criminals cannot only access the site with the leak, but all sites where you used the same password.