Monthly Archives: September 2021
-
A DBA horror story in database file extensions.
4September 30, 2021 by Kenneth Fisher
-
Audit Columns
3September 28, 2021 by Kenneth Fisher
One of the easiest ways to collect information about table activity is to add a series of audit columns to …
Continue reading -
#PowershellBasics: Bulk insert.
Leave a commentSeptember 21, 2021 by Kenneth Fisher
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql …
Continue reading -
#PowershellBasics: Running a .sql script file.
5September 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
7September 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
SQL Studies 