ISACA Journal Article on AI
The first issue of 2024 for the ISACA Journal has been published and the articles are available both in written and on-line format. I have a regular column on...
2024-02-02
9 reads
The first issue of 2024 for the ISACA Journal has been published and the articles are available both in written and on-line format. I have a regular column on...
2024-02-02
9 reads
I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...
2024-01-31
55 reads
If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...
2024-01-29
8 reads
Understanding query plans is key to successful query tuning in Microsoft SQL Server. Randolph West of the Microsoft docs team posted on Thursday that the logical and physical showplan...
2024-01-26
29 reads
So what did I learn? I think a better question is, "What did I re-learn?"
2024-01-26 (first published: 2024-01-09)
233 reads
This is not a “clickbait” title, but an important consideration when it comes to developing technical solutions. Let me give you an example between two questions for SQL Server...
2023-11-29 (first published: 2023-11-17)
241 reads
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern Standard Time, I’m presenting a webinar on how to harden SQL Server. Link to Register...
2023-11-27
7 reads
On November 29, 2023, at 11 AM Eastern Standard Time, I'm presenting a webinar on how to harden SQL Server.
2023-11-15
166 reads
If you’re looking at data masking tools, I recently was able to review the DataVeil solution. Quite simply, getting production data out of non-production environments is still a big...
2023-09-19
28 reads
I’m currently in Enterprise Architecture in my organization and as a result, I blogged earlier about putting up study notes with regards to preparing for the two TOGAF (The...
2023-09-13
14 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers