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 […]
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 […]
With wsSqlSrvDoc you can fully document Microsoft SQL Server databases with just a few mouse clicks.
VS2012 SQL Server Object Explorer not working after SQL Server 2012 SP1 Update and how to fix it.
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 […]
This nice little SQL script creates a table [Countries] in your MS SQL Database. The generated table contains all countries of the world with their 2 digit ISO short-codes (this is: ISO 3166-1 alpha-2) and both english and german full names.
How to add comments to tables and fields The preperation of your database will be done directly in the SQL Server Management Console. You will need to create a custom attribute on the table (or field) that you want to comment. Name this custom attribute either Description Descr and use […]
At times, we developers need to run SQL scripts from our .NET applications, in, say Installer Applications. This is not always easy since large SQL scripts typically contain a GO statement to separate individual batches and our ADO.NET classes under System.Data namespace do not know how to handle it. The […]
In the first page of the wizard you’ll have to provide the logon information for the MS SQL Server database: