Join me at VS Live Las Vegas 2023
I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited...
2022-12-27
41 reads
Blog Posts
More DevOps with the SQL Solutions Group
I’m doing another webinar on Jan 18, 2023 with the SQL Solutions Group. You can register here and reserve a spot. Scott Klein and I did a webinar last...
2022-12-27
36 reads
Seeking Home Network Happiness
TL;DR: My home firewall/router is slow, please help me pick out a new one.
After replacing my firewall/router/WiFi access point one too many times, I’m ready to get off the...
2022-12-27
105 reads
Book Review – SQL Server Query Tuning and Optimization (2nd Edition)
The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...
2022-12-26 (first published: 2022-12-02)
331 reads
Daily Coping 26 Dec 2022
Today’s coping tip is to see how many people you can smile at today. Easy one for me. I find this makes me happier and my day better when...
2022-12-26
10 reads
My Stats from 2022
I wrote last week about my travel, 23 trips in 2022. However, I’ve been gathering some other stats about my life and what I do, so I wanted to...
2022-12-26
18 reads
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The type of engagement you choose affects the pace and deliverables of the project, and the...
2022-12-26 (first published: 2022-12-06)
217 reads
A Big Year for Travel
I do tend to travel a good amount as my kids have gotten older. The pandemic slowed things for a year, but only then. Someone remarked on this year...
2022-12-23
11 reads
Advent of Code 2022
Foreword
Advent of Code is an annual event in which participants solve a series of coding puzzles. It typically begins on December 1 and runs through the end of the...
2022-12-23 (first published: 2022-12-08)
157 reads
Daily Coping 23 Dec 2022
Today’s coping tip is to be generous. Feed someone with food, love, or kindness today It’s often a family day today, as work ends and we prepare for Christmas....
2022-12-23
7 reads
Blogs
Data Viz in Fabric Notebooks
Lots of people have created Power BI reports, using interactive data visualizations to explore...
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers