Welcome to my blog, see my latest posts or use the search button.

  • How to protect your Intellectual Property in SQL server
    This is a blogpost inspired by T-SQL Tuesday invitation #167 by MATTHEW MCGIFFEN. Imagine a scenario where you need to deploy your application, which contains a significant amount of valuable know-how, to a SQL server that is not under your control or is managed by other DBAs. In most cases, you are deploying your application… Read more: How to protect your Intellectual Property in SQL server
  • Extended events
    This post about SQL server extended events was written based on the invitation 166 from scarydba.com. Still not sure why I haven’t noticed the invitation on the official web of tsqltuesday.com but found it by #tsql2sday They have been around since SQL 2012, what has changed? Microsoft have done some enhancements to the impact on… Read more: Extended events
  • NLOG write into database
    NLOG is a great framework to log errors to all kind of targets, I learned about it when I was working on including XESmartTarget into our product. There is a lot of sources to help out with initial implementation and logging to console was straight forward, the problem started when I wanted to log information… Read more: NLOG write into database
  • Gas next bill projection
    With a rising prices of utilities like gas and power and winter still being in progress it might be good to check your usage from time to time. With electricity and TOU meters, it is easy, retailer does that for you and you can check your consumption and projected bill at any time with a… Read more: Gas next bill projection
  • Is T-SQL case sensitive?
    By definition, T-SQL is not case sensitive, but there are scenarios where it can exhibit partial case sensitivity. Consider a scenario where you deploy a database for your application using a Case Insensitive (CI) collation. Initially, everything works fine, even if you occasionally deviate from naming guidelines or use different casings within your code, such… Read more: Is T-SQL case sensitive?