#tsql2sday – A Letter to My 20 Year-Old Self
Self, I am writing this to you in my mid 40s. I know when I was 20, I wasn’t thinking about 30, much less 40. Here’s some advice I’d...
2019-06-11
34 reads
Databases – Infrastructure – Security
Basic SQL Server Configuration Help for Involuntary DBAs
After my presentation at the Techno Security and Digital Forensics conference, I had a information security professional stop by to ask a few questions. He’s in the position where...
2019-06-24 (first published: 2019-06-10)
1,189 reads
Mitre’s ATT&CK Security Framework
Mitre’s ATT&CK security framework was mentioned often at the Techno Security and Digital Forensics Conference. I admit that I’m not well-versed on it, yet. However, its purpose makes sense....
2019-06-07
53 reads
Sysinternals – A Swiss Army Knife for IT Pros
I’m at the Techno Security and Digital Forensics conference in Myrtle Beach again this year. I sat in on a presentation about performing malware analysis. The analyst began with...
2019-06-06
444 reads
Why Security Through Obscurity Is Bad (Alone)
Security through (by) obscurity is where we try to protect an asset by hiding it. Anyone who has ever played the game Capture the Flag knows that a motivated...
2019-06-21 (first published: 2019-06-05)
393 reads
Security Controls: CISA vs. CISSP
When looking at the Certified Information Systems Auditor (CISA) exam, we focus on teaching 3 types of controls: Preventative – keeps an incident from occurring Detective – Identifies the...
2019-06-04
302 reads
Mini-Rant: Spoofed Phone Numbers and Trust
I’ve seen this more and more over the last year: I receive a phone call with a number that indicates it’s coming from a town or city near me....
2019-05-24
184 reads
Building Your Brand Right
I was interviewed yesterday by Stephen Wynkoop (twitter) for the upcoming SSWUG Virtual Conference on May 23rd. One of the questions was about how to keep management engaged on...
2019-06-07 (first published: 2019-05-21)
476 reads
Same Webcast, New Name: Introduction to Auditing Features in SQL Server
I’m giving another webcast through MSSQLTips.com. This one is on May 9, 2019, at 3 PM EDT. It’s called Introduction to Auditing Features in SQL Server. We renamed it...
2019-05-07
22 reads
Midlands PASS – Next Meeting and Summit Discount Code
Midlands PASS is an official PASS chapter located in Columbia, SC, USA. Here’s an update about our schedule, as well as the PASS discount code. No May or June...
2019-05-06
64 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers