SQL Query to get product and version details of installed SQL Server

Not a long post but very handy query that can be used when you need to know the installed SQL Server product's version, edition, flavour, server name details. SQL Query to get version details for installed Microsoft SQL Server: SELECT SERVERPROPERTY('productversion') AS 'Product Version', SERVERPROPERTY ('productlevel') AS 'Product Level',…

MySQL error 1449: The user specified as a definer does not exist

I was recently working with a sidekick thing where I was using MySQL as my backend database. This was accessed from the application with hostname - localhost and username dev. I had created one view and was using it in the thing I was working on. It was originally scripted…

Install SQL Server 2012 Express Step by Step

This steps will guide you to install SQL Server 2012 Express edition, code name “Denali”. The express edition is free version of SQL Server 2012 and is available for download from Microsoft site. Download the installer and run. Step 1: The installer will create a temporary folder in your C…