Tag Archives: instance settings
-
SQL Homework – February 2019 – Instance configurations
5February 4, 2019 by Kenneth Fisher
This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not …
Continue reading -
How to: Create an Azure VM with SQL Server using a default template
1December 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 -
Running code on the startup of SQL Server
1February 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 -
TSQL Tuesday #68: What is my configuration?
2July 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 -
Port numbers and SQL Server
Leave a commentMarch 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 -
Database default locations
4September 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 -
Changing configuration settings with sp_configure
5September 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 -
What port is my instance listening on?
8January 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 -
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
2September 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
