My presentation recordings of data architectures
Over the years I have presented a ton (see the list), and some of those presentations were recorded. I had put some of them on my YouTube channel, but...
2022-12-15
28 reads
Blog Posts
Daily Coping 14 Dec 2022
Today’s coping tip is to offer to help someone who is facing difficulties now. I’ve been very lucky in life. I find that success often has me associating with...
2022-12-14
35 reads
Default event_file path for Extended Events
Foreword
Have you ever wondered where the .xel file is saved when you create a new Extended Event session and don’t specify the full path (just the file name)?
Like so:
Well,...
2022-12-14 (first published: 2022-11-30)
217 reads
Encrypting Your SQL Data Should be Your Default Option
Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we hear news of large companies that have had data stolen with both financial and reputational...
2022-12-14 (first published: 2022-11-30)
401 reads
Daily Coping 13 Dec 2022
Today’s coping tip is to contact someone you can’t be with to see how they are. Maybe the one thing the pandemic did for me is make me think...
2022-12-13
34 reads
T-SQL Tuesday #157: End of Year Activity
T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Garry Bargsley (blog | twitter) wants to know what activities we...
2022-12-13
39 reads
Daily Coping 12 Dec 2022
Today’s coping tip is to look at life through someone else’s eyes and see their perspective. I have my own views, beliefs, and thoughts about the world. However, I...
2022-12-12
20 reads
How to Install Integration Services 2022
The title of this blog post is a bit misleading, because what we actually want to do is to install the SSIS development functionality in Visual Studio 2022. SSAS...
2022-12-12 (first published: 2022-11-25)
1,001 reads
Overview of SQL Server Encryption Features
SQL Server has had the native ability to encrypt data since SQL Server 2005. This included functionality that could be used to encrypt individual items and columns of data...
2022-12-12
160 reads
Power BI Embedded: Using Row-Level Security for Multilingual Reports
Making multilingual reports in Power BI requires a lot of different elements. Translations can be added to PBIX files to translate column names, visual titles, etc. but these translations...
2022-12-12 (first published: 2022-11-30)
224 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers