-
#PowershellBasics: Running a .sql script file.
2September 16, 2021 by Kenneth Fisher
As with all programming tasks there are a number of ways to do something, this is just one that I …
Continue reading -
Database Sizes
Leave a commentSeptember 14, 2021 by Kenneth Fisher
Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure …
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 -
SQL Homework – September 2021 – How good is your recovery plan?
Leave a commentSeptember 2, 2021 by Kenneth Fisher
Last month I had you create a security standards document. This month we are going to document our recovery plan. …
Continue reading -
Rule 1: Be kind, be polite.
2August 31, 2021 by Kenneth Fisher
In my house, this is rule one. Sometimes it’s my wife or I reminding our kids, sometimes it’s them reminding …
Continue reading -
The sysname datatype defaults to not NULL.
3August 26, 2021 by Kenneth Fisher
The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
Continue reading -
Error: Cannot continue the execution because the session is in the kill state.
Leave a commentAugust 24, 2021 by Kenneth Fisher
This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to …
Continue reading -
A new presentation on Auditing your databases
Leave a commentAugust 19, 2021 by Kenneth Fisher
I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be …
Continue reading -
Experiment: Does sp_recompile on a table update associated views.
2August 17, 2021 by Kenneth Fisher
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the …
Continue reading
SQL Studies
Live, Learn, Share
