T-SQL Tuesday #156–Ready for Production
It’s a busy time for me, but it’s also T-SQL Tuesday blog party day. I’m rushing a bit as I forgot about this (thanks for the reminder, Deb) and...
2022-11-08
16 reads
Blog Posts
Daily Coping 7 Nov 2022
Today’s coping tip is to identify three things that give you hope for the future. The creativity and passion of youth The drive from many people who build software...
2022-11-07
8 reads
The SQL Server Central Casino Party #SeattleSummitMoments
Redgate started a new marketing thing and I like it. They’re asking for memories of attending the Summit in Seattle. I’ve been lucky enough to go to many of...
2022-11-07 (first published: 2022-10-25)
890 reads
What can you do with a SELECT statement without a FROM clause?
Some people have shower thoughts, I have 1am thoughts. In this case it was the only keyword required in a ... Continue reading
2022-11-07 (first published: 2022-10-25)
654 reads
Daily Coping 4 Nov 2022
Today’s coping tip is to plan a fun or exciting activity to look forward to. I almost shouldn’t do this much, since I’ve had a great year with plenty...
2022-11-04
5 reads
From Manual to DevOps at the Data Community Summit
This year the annual PASS Data Community Summit is hybrid, both in-person and virtual. It’s exciting to have this coming back and I look forward to seeing people in...
2022-11-04 (first published: 2022-10-21)
113 reads
Goal Progress for Oct 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Another month of busy stuff. Prepping for the Data Community...
2022-11-04
6 reads
Notes on SQLSaturday Orlando 2022
First, the numbers. We registered 240 people, had about 110 on site. That’s definitely better than last year and still quite a bit under what it was pre-Covid. I’ll...
2022-11-04 (first published: 2022-10-19)
104 reads
The Way0utwest Joker #SeattleSummitMoments
I work for Redgate, who has been a great sponsor of the Summit in the past and now is charged with stewarding the event into the future. This post...
2022-11-04
9 reads
Validating Backups: PGSQL Phriday #002
It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. I’m very much just beginning...
2022-11-04
11 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