SQL


MS SQL Tricks   Recently updated !

Identify your server instance When working with SSMS it can sometimes be unclear which server you are querying. This can cause problems especially when working on test, dev and production systems as most developers do. How can you clearly, in the blink of an eye, identify the connections when using […]


downloading tMORE

How to Install

  After clicking on the download link, the first (of many…) “warning” from MS Windows will be displayed – proceed with clicking the Run button. On Systems that have the Windows SmartScreen enabled, the next warning will be displayed. Proceed.  If you haven’t local administrator permissions, an admin has to […]


Convert UTC to Local Time on MS SQL Server 4

Sometimes one has to convert a DateTime value stored in the DB to local DateTime.  Of course we have everything we need for this available in the .NET Framework.  But there may be situations where you have to convert on the database server side, for example within a Stored Procedure […]

VS 2013