SQL : How to use SQL Profiler with SQL Server Express Edition

SQL Server Express is a free edition of Microsoft SQL Server family that although fully functional, it has some technical limitations like maximum database size per database. It also has some features missing from paid editions. One of those features not available with Express edition is SQL Profiler. In this post I will list the alternative tools for SQL Profiling that can be used with either SQL Server Express or can be used as the SQL Express replacement.

SQL : How to solve Northwind Database Install Error in SQL Server

Recently I was going through a database programming tutorial that used Northwind Database in code examples, so I thought "No problem, I'll quickly add that database to my SQL Server 2012". I assumed this would be easy but to my surprise that wasn't the case.

In this post, I will show you what problems I encountered while trying to install the Northwind database and how I finally managed to make it work.