Using a data lakehouse
As I mentioned in my Data Mesh, Data Fabric, Data Lakehouse presentation, the data lakehouse architecture, where you use a data lake with delta lake as a software layer...
2023-03-09
25 reads
Blog Posts
30 Interview Questions for a Database Administrator and Developer
This blog post summarizes the type of technical questions I would ask candidates for a Microsoft SQL Server data platform administrator and database developer role.Hopefully this helps both candidates...
2023-03-08 (first published: 2023-02-28)
1,231 reads
Daily Coping 8 Mar 2023
Today’s coping tip is ask someone how their day is going and really listen to them. I had the chance to do this with one of the kids I...
2023-03-08
11 reads
Documentation vs Automation
Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...
2023-03-08 (first published: 2023-03-01)
438 reads
T-SQL Tuesday #159– Resolutions
I missed T-SQL Tuesday last month. I got busy and distracted with some travel. For #159, Deepthi Goguri hosted. I’ve enjoyed watching her blog and grow her knowledge the...
2023-03-08
73 reads
Daily Coping 7 Mar 2023
Today’s coping tip is give positive comments to as many people as possible today. On a travel day, I made an effort here. Those are always better for me,...
2023-03-07
20 reads
Synapse Analytics workspace – deployment challenges
Azure Synapse Analytics is not just “another service” in the Azure. It’s very comprehensive set of tools rather than one-goal-tool (like Azure Key Vault or even Storage Account). On...
2023-03-07
35 reads
Daily Coping 6 Mar 2023
Today’s coping tip is to make plans with a friend and catch up with them. I decided to reach out to a friend and make time to catch up....
2023-03-06
14 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
51 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)
285 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers