SQL Server 2022 Query Performance Tuning
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
243 reads
Blog Posts
Attending and presenting at conferences
I have attended and presented at a ton of conferences over the years (see the entire list at Presentations | James Serra’s Blog). If you are looking to learn...
2022-11-10
9 reads
Daily Coping 10 Nov 2022
Today’s coping tip is to respond to a difficult situation in a different way. There are plenty of difficult situations I find myself in, some of which create lots...
2022-11-10
6 reads
Thursday is #sqlkilt Day
At the PASS Data Community Summit, Thursday is the day when the Women in Technology (WIT) luncheon takes place. This is an event I’ve come to enjoy as I...
2022-11-10
65 reads
Webinar: Enhancing Your ETL Pipelines with Custom Data Cleansing and Matching
At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa Data. This is a 30-minute webinar, sponsored by Melissa...
2022-11-10
8 reads
Daily Coping 9 Nov 2022
Today’s coping tip is to make time for a friend and have a coffee, meal, or just spend time. It’s been a busy few months for me. Since Sept...
2022-11-09
11 reads
SQL Server Registered Servers
Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.
2022-11-09 (first published: 2022-10-28)
448 reads
The Reason We Use Only One Git Repo For All Environments of an Azure Data Factory Solution
I’ve seen a few people start Azure Data Factory (ADF) projects assuming that we would have one source control repo per environment, meaning that you would attach a Git...
2022-11-09 (first published: 2022-10-31)
304 reads
Daily Coping 8 Nov 2022
Today’s coping tip is to set a goal that brings a sense of purpose for the coming month. For me, I’m going away from primary work to secondary work....
2022-11-08
9 reads
Deciding to Submit to Conferences–#NewStarNovember
I wrote about getting started last week, with invitations from others. I think the first time I actually made my own submission was to the Indy Tech Fest in...
2022-11-08
23 reads
Blogs
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Forums
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
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?
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