Security Basics: The Principle of Least Privilege
Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...
2017-07-17 (first published: 2017-06-30)
2,957 reads
Recording of PASS Security VC Webinar
If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has...
2017-06-29
570 reads
The Three A’s: Auditing
Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...
2017-07-13 (first published: 2017-06-28)
1,631 reads
The Three A’s: Authorization
Having covered authentication yesterday, let’s move on the second A, authorization. Authentication was about proving identity. Now that we know...
2017-07-10 (first published: 2017-06-27)
1,673 reads
The Three A’s: Authentication
When I start talking with folks about security, one of the areas of confusion I often find has to do...
2017-07-05 (first published: 2017-06-26)
1,832 reads
#SQLChat on Performance Issues
Twitter can often be a great source of information for the SQL Community, especially with the #SQLHelp hashtag. Another resource...
2017-06-23
380 reads
PASS Security VC Presentation – The Dirty Business of Auditing
On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.
Registration...
2017-06-19
375 reads
Speaking at Charleston PASS on May 18, 2017
During the day of the 18th I’ll be at the Syntax Code and Craft Conference in Charleston, SC. That evening...
2017-05-12
326 reads
Slides from 24 Hours of PASS – Data Security
As promised, here are my slides from the 24 Hours of PASS on Data Security:
S1 – Brian Kelley_WhatYouAbsolutelyMustKnowAboutSQLServerSecurity (.pptx – 733 KB)
S7 – Brian...
2017-05-09
392 reads
Slides from SSWUG 2017 Spring Virtual Conference
As promised, here are the slides for my two presentations from SSWUG’s 2017 Spring Virtual Conference:
SSWUG_Spring_Building an Auditing Framework for...
2017-05-08
329 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers