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
241 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
61 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
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers