Tag Archives: instance settings

  1. How to: Create an Azure VM with SQL Server using a default template

    1

    December 14, 2017 by Kenneth Fisher

    One of the really cool things about the cloud is how quickly you can spin up a new machine to …
    Continue reading

  2. Running code on the startup of SQL Server

    1

    February 1, 2016 by Kenneth Fisher

    Every now and again you need to run code when your instance starts up. For example you might want to …
    Continue reading

  3. TSQL Tuesday #68: What is my configuration?

    2

    July 14, 2015 by Kenneth Fisher

    It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just …
    Continue reading

  4. Port numbers and SQL Server

    Leave a comment

    March 30, 2015 by Kenneth Fisher

    I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
    Continue reading

  5. Database default locations

    4

    September 29, 2014 by Kenneth Fisher

    One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
    Continue reading

  6. Changing configuration settings with sp_configure

    5

    September 22, 2014 by Kenneth Fisher

    I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
    Continue reading

  7. What port is my instance listening on?

    8

    January 8, 2013 by Kenneth Fisher

    I just had the interesting task of finding the port number that one of the instances I deal with is …
    Continue reading

  8. Funny results from OPTIMIZE FOR AD HOC WORKLOADS

    2

    September 18, 2012 by Kenneth Fisher

    I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers.  When I …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,423 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013