No, I do not provide childcare at my technology events...
A guest editorial from Julie Yack looks at the difference between men and women from the perspective of one very successful woman in technology.
2010-10-05
297 reads
Editorials
The One True Script
Phil Factor less-than-fond memories of the days of the One True Source Script. However, despite recent advances, he wonders just how much smoother team-based database development really is.
2010-10-04
244 reads
Women and Men - Same or Different?
Today we have a guest editorial from Wendy Pastick, co chair of the Women in Technology Virtual Chapter. Today Wendy takls about how men and women handle their careers.
2010-10-04
378 reads
Planning for Failure
Today Steve Jones reminds us that the small disasters are likely to occur, and that you need to be sure that you're planning for them, and practicing for the recovery that will be needed.
2010-09-30
151 reads
Hot Skills
What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about.
2010-09-28
703 reads
Can Wives Shorten Work Hours?
This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.
2010-09-27
266 reads
SQL Server's implementation of Window Functions
Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.
2010-09-27
798 reads
Great Service – All About Attitude
today we have a guest editorial from Andy Warren that talks about how attitude can influence the impression you make can have a huge impact on how your service is viewed.
2010-09-24
144 reads
Community Direction
Steve Jones wishes that Microsoft had a way for the community to give better feedback about what we see as a priority in the next version of SQL Server.
2010-09-23
68 reads
What Do We Need in SQL Server?
Steve Jones asks us today about what we might like to see in the next few versions of SQL Server.
2010-09-22
288 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers