It is Work to Live not Live to Work
In the United States, we have our Thanksgiving this month. This is a time where families come together for a huge meal. For many, it is a time to...
2024-11-11
3 reads
Blog Posts
Mastering the ORDER BY Clause in SQL Window Functions
This article provides a comprehensive overview of the ORDER BY clause within SQL window functions. We'll explore how it interacts with PARTITION BY and the standard ORDER BY clause,...
2024-11-11 (first published: 2024-10-24)
590 reads
Monday Monitor Tips: Projecting Disk Space
One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are...
2024-11-11 (first published: 2024-10-28)
440 reads
Social Anxiety and Events Like the PASS Summit
If you are an introvert like me, events like the PASS Summit can call forth your social anxiety. I know this past week, I definitely felt it, even though...
2024-11-11
57 reads
A New Word: Skidding
skidding – v. intr. the practice of making offhand comments that sound sarcastic but are actually sincere and deeply felt. I used to make lots of sarcastic comments. Some...
2024-11-08
12 reads
PASS Summit – Thursday
Let’s start with the keynote. The biggest take away was how having to support multiple data platforms is growing and becoming the norm. This has been my experience and...
2024-11-08
16 reads
Tell me the positives of your solution
I still have a tendency to talk about all the cons of a proposed solution I don’t believe is the optimal one. There’s an old saying that “no one...
2024-11-08 (first published: 2024-10-29)
163 reads
Using SQL Compare in Read-Only Databases
Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...
2024-11-08 (first published: 2024-10-21)
166 reads
PASS Summit 2024 – Wednesday
A common theme in the PASS Summits I've attended is community and that's definitely true this year. It's one of the reasons I have loved coming when I can....
2024-11-07
28 reads
Taming Database Challenges: Insights from Redgate Keynote
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying Complexity – Making the Database Work in the Real World. As the database landscape grows...
2024-11-07
17 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
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
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