Webinar: How to Harden SQL Server
On November 29, 2023, at 11 AM Eastern Standard Time, I'm presenting a webinar on how to harden SQL Server.
2023-11-15
172 reads
Databases – Infrastructure – Security
Product Review: DataVeil
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
37 reads
Restarting What’s Important
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
15 reads
Appalachian State Cyber Summit – September 8, 2023
Looking to attend a security summit in cooler weather that will benefit students? Applachian State holds an annual cybersecurity summit and this year it is scheduled for September 8,...
2023-08-17
26 reads
TOGAF 9 Certified Exam Breakdown
In the last post I hadn’t found the breakdown of questions for the exam. The Open Group does publish the TOGAF 9 Certified Study Guide (link goes to the...
2023-03-06
46 reads
Understanding the TOGAF 9 Foundation Exam
When I teach the ISACA Certified Information Systems Auditor (CISA) course, one of the things I walk candidates through is how the test is structured and how much each...
2023-03-06 (first published: 2023-02-28)
270 reads
Preparing for TOGAF Certification
The Open Group Architecture Framework (TOGAF) is one of the most well-known architectural frameworks in our industry. TOGAF is a framework that helps organizations implement enterprise architecture as a...
2023-02-27
104 reads
Two Percent, Five Percent, More?
I was reading Seth Godin today and he makes this claim: If 2% of a population takes coordinated action, it makes a difference. If 5% do, it can change...
2022-06-03 (first published: 2022-05-12)
288 reads
Reading more efficiently
In IT, we have to read a lot. For instance, understanding how to set something in Azure or Okta or vSphere may mean we are consuming 5 or more...
2022-03-18 (first published: 2022-03-07)
302 reads
Architecture – Commonality is an accelerator
In IT, commonality is an accelerator. When I say commonality, I mean commonality of: Components, like libraries Object models Interface definitions Tools Let me give you an example. Imagine...
2022-03-02
147 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