Natural Born Coder

Category: SQL

  • How to Configure SQL Server to Use Let’s Encrypt Certificates

    —

    by

    doozer
    in ,

    If you have a SQL Server that is accessible in anyway outside your network you really should ensure that connections to it are encrypted. In this article I will do my best to give a comprehensive guide on how to configure SQL Server 2017 to use free certificates from Let’s Encrypt. Be warned, this is…

  • Fastest Updates in SQL Server

    —

    by

    doozer
    in , ,

    The project I’m working on at the moment requires me to achieve the fastest updates I can into a moderate sized SQL Server database table. My initial attempts were adequate for the testing I was doing on my development machine but when I came to do a more thorough test in a production like environment…

  • Setting the SQL Server Default Backup Locaton

    —

    by

    doozer
    in

    I seem to end up looking this one up everytime I install a new instance of SQL Server so I’m sure I can’t be the only one. The default backup path for SQL Server is somewhere deep in the Program Files directory which, if you are a software developer, is a pain in the rear.

  • MySQL Triggers and UUID

    —

    by

    doozer
    in ,

    One of the applications I maintain currently only runs against Microsoft SQL Server. For the most part this hasn’t proven to be that much of a problem as everyone who uses the application also runs MS SQL. The problem comes when I want to deploy and test it on one of the company servers because…

  • SQL Having

    —

    by

    doozer
    in

    The having clause is used when filtering has to be performed on aggregate functions since the where clause can not be used in this situation. Since the having clause is often used in conjunction with the group by clause the examples on this page use the same data as was used in the group by article…

  • SQL Group By

    —

    by

    doozer
    in

    The group by statement is generally used in conjunction with the various aggregate functions in order to produce results that are grouped by one or more columns. This is a very powerful way to report results for groups of results that share some common trait – in the example below the shared trait we are…