The Bulldogs
Steve Jones talks about IT Project Failure and how you should re-evaluate things are you move forward.
2008-06-10
120 reads
Editorials
A Private Database
Having separate databases for each client? It's a common problem and Steve Jones wonders if this might be a feature coming in SQL Server at some point.
2008-06-09
313 reads
Open Source and SQL Server communities
The other day, I was chatting to a keen PostgreSQL user. We're used to having free databases, such as IBM DB2 Express-C, Microsoft SQL Server 2005 Express Edition, SQLite and Oracle XE, but PostgreSQL is different in that it is open source. It is a proper, dedicated community too, I was told...
2008-06-09
128 reads
The Bulldogs
Steve Jones talks about IT Project Failure and how you should re-evaluate things are you move forward.
2008-06-09
86 reads
The Software Comparison - Part 4
The final installment of Steve Jones' comparison between software developers and other professions looks at the most closely related: engineers.
2008-06-05
141 reads
The Software Comparison - Part 3
Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.
2008-06-04
101 reads
Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-03
189 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-02
262 reads
Job Specialization - Boon or Bane?
As the number of different software/technologies increases exponentially, does specializing limit an IT professional's ability to move around? This editorial is being republished due to technical issues from last week.
2008-06-02 (first published: 2008-05-29)
1,908 reads
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
2008-06-02
292 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers