Category Archives: Settings
-
Copying formatted text out of a grid column.
7August 27, 2018 by Kenneth Fisher
I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, …
Continue reading -
What are my permissions?
1August 16, 2018 by Kenneth Fisher
Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
Continue reading -
The default filegroup, and why you should care.
2February 19, 2018 by Kenneth Fisher
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
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 -
Saving and restoring session options settings
4September 25, 2017 by Kenneth Fisher
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations. …
Continue reading -
Default Instance Reports – Configuration Changes History
Leave a commentJuly 17, 2017 by Kenneth Fisher
Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured …
Continue reading -
Changing what SSMS opens on startup
Leave a commentFebruary 1, 2017 by Kenneth Fisher
When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and …
Continue reading -
My SQL logins don’t work. Again.
Leave a commentJanuary 25, 2017 by Kenneth Fisher
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one …
Continue reading -
Why won’t my SQL Logins work?
11January 12, 2017 by Kenneth Fisher
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
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
SQL Studies 