Humble Bundle of Java Books
I try to keep an eye on the Humble Bundle bundles for books. The bundles serve two great purposes: I was able to grab the Cybersecurity bundle, but by...
2024-02-26
120 reads
Databases – Infrastructure – Security
David Kahn, legendary author, has passed away
I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...
2024-02-05
37 reads
Security Justifications for Infrastructure as Code (IaC)
Last week, the Cybersecurity & Infrastructure Security Agency (CISA) put out an emergency directive which ordered federal agencies to pull Ivanti Connect Secure and Ivanti Policy Secure installations from...
2024-02-23 (first published: 2024-02-05)
186 reads
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
16 reads
BI Training with Eugene Meidinger
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
56 reads
Videos from MITRE ATT&CKcon 4.0
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
9 reads
SQL Server documentation refresh: Logical and physical showplan operator reference
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
39 reads
T-SQL Tuesday #170 – Learning from Failure
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
Giving a Security Webinar this Wednesday
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
8 reads
Is that the right question to ask?
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)
243 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers