Daily Coping 3 Nov 2022
Today’s coping tip is to ask yourself, will this matter a year from now? It’s easy to get caught up in short term things. I’m behind on a few...
2022-11-03
7 reads
Blog Posts
The PASS Data Community Summit
I’m looking forward to attending the PASS Data Community Summit this year in Seattle, Washington. I’m also glad to have the opportunity to speak with fellow Microsoft MVPs Josh...
2022-11-03
12 reads
The PASS Summit 2022 DevOps Devour Hour from Redgate
At the Data Community Summit this year, Redgate is hosting a couple of lunchtime sessions, the Summit 2022 DevOps Devour Hour. A creative name, for sure. These are Thursday...
2022-11-03
14 reads
Create a Community Event at the Summit
There are a few community events at the Summit this year, but fewer than in the past. I know we’re all rebooting our conference experiences, and that can make...
2022-11-02
4 reads
Daily Coping 2 Nov 2022
Today’s coping tip is to be kind to yourself today. Remember, progress takes time. I am usually good at this. I work on many things that take time, so...
2022-11-02
4 reads
Getting Help Online
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
142 reads
Organize Your Tabs in SQL Server Management Studio
I blogged about this in August, but wanted to do this video as well: Thanks for reading and/or watching! Kevin3NF Follow @Dallas_DBAs
The post Organize Your Tabs in SQL Server...
2022-11-02
134 reads
Tales From The Field Weekly Wrap Up for the Week of 10-17-2022
Hello Dear Reader! I hope you had a fantastic weekend. This weekend we celebrated my parents 50th wedding anniversary, my oldest daughter flew into town for an early birthday,...
2022-11-02 (first published: 2022-10-24)
113 reads
Daily Coping 1 Nov 2022
Today’s coping tip is to be kind to yourself. Remember progress takes time. I’ve spent most of this year trying to better manage my weight and become healthier. I...
2022-11-01
6 reads
SQL Kilts #SeattleSummitMoments
This is another memory of the PASS Summit, this one an idea from Grant Fritchey, who wanted support the Women in Technology (WIT) events. And have a few laughs...
2022-11-01
27 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