Tag Archives: Microsoft SQL Server
-
Code examples : T-SQL Tuesday #143
Leave a commentOctober 12, 2021 by Kenneth Fisher
It’s TSQL Tuesday! John Armando McCormack (blog|twitter) is our host this month and he’d like us to share some of …
Continue reading -
Dealing with foreign keys when deleting rows.
2October 7, 2021 by Kenneth Fisher
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of …
Continue reading -
SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?
Leave a commentOctober 5, 2021 by Kenneth Fisher
Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? …
Continue reading -
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 -
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 -
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 -
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 -
SQL Homework – August 2021 – Security Standards
1August 3, 2021 by Kenneth Fisher
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
Continue reading