Category Archives: Settings
-
Help, not all of my column is displaying in the output of the query!
1February 22, 2022 by Kenneth Fisher
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we …
Continue reading -
Remote Desktop: Force the resolution to match the screen size.
1September 9, 2021 by Kenneth Fisher
One of the things I hate most about using remote desktop is when the resolution for the remote server is …
Continue reading -
Auditing with “C2 Auditing” and “Common Criteria Compliance”
Leave a commentSeptember 7, 2021 by Kenneth Fisher
I’m going to be fairly high level on these because to be honest, if you are going to use them …
Continue reading -
What account is xp_cmdshell using?
3May 25, 2021 by Kenneth Fisher
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
Continue reading -
Change the size of the grid results view in SSMS
3March 4, 2020 by Kenneth Fisher
After my post last month about configuring your tools I’ve been on a make my life easier kick and one …
Continue reading -
SQL Homework – March 2020 – Database Configurations.
Leave a commentMarch 2, 2020 by Kenneth Fisher
A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this …
Continue reading -
What version of SQL is SSMS scripting for?
Leave a commentMarch 25, 2019 by Kenneth Fisher
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
Continue reading -
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 -
SQL Homework – January 2019 – Baselines
Leave a commentJanuary 2, 2019 by Kenneth Fisher
Happy New Year! Every year for New Years we all make a big deal of coming up with New Years …
Continue reading -
SQL Homework – December 2018 – Configure SSMS
Leave a commentDecember 3, 2018 by Kenneth Fisher
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
Continue reading
