Tag Archives: database settings
-
SQL Homework – April 2020 – Continuity planning.
3April 1, 2020 by Kenneth Fisher
Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world …
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 -
SQL Homework – June 2018 – Alter a database
Leave a commentJune 4, 2018 by Kenneth Fisher
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL …
Continue reading -
SQL Homework – May 2018 – Create a database
4May 2, 2018 by Kenneth Fisher
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as …
Continue reading -
Do you check for TRUSTWORTHY databases as part of your security audits?
7December 30, 2015 by Kenneth Fisher
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do …
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 -
What is the database property “Compatibility Level”
7July 8, 2015 by Kenneth Fisher
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in …
Continue reading -
Multiple Windows Groups with different default databases
2May 28, 2015 by Kenneth Fisher
A question came up at work the other day, mostly as a mind game, but you never know it might …
Continue reading -
Default database
4May 26, 2015 by Kenneth Fisher
What? The default database is one of the options when creating a login in SQL Server. This is the initial …
Continue reading
