• Don’t Rely On a Static IP Address for Your SQL Database

    Posted 9 months ago
    by SQL Server Support Content}
    I’ve seen a number of customers open support incidents because they couldn’t connect to their SQL Database server which was ultimately due to the incorrect assumption that the server’s IP address is static. In fact, the IP address of your logical server...

  • SQL Nexus 4.0 Released to codeplex

    Posted 9 months ago
    by SQL Server Support Content}
    We have just released SQL Nexus 4.0 ( https://sqlnexus.codeplex.com/) which supports latest SQL Server (2012) with enhanced reports. In addition to read release notes, make sure you also read the top issues . Please report any issues under the Issues...

  • sp_reset_connection – Rate Usage (Don’t fight over the grapes)

    Posted 9 months ago
    by SQL Server Support Content}
    Discussions surrounding sp_reset_connection behavior and usage come up all the time and over the years I have discussed the subject 100s of times with customers.  Blogs, API documentation and Books Online describe SQL Server, pooled connections behavior...