The Identity Debate
Using the Identity Property might be one of the more debated features of SQL Server. This editorial was originally published on Mar 5, 2008. It is being re-run as Steve is on vacation.
2008-02-11
289 reads
Editorials
2008-02-08
46 reads
Feedback
Corporate management often asks for feedback and buy-in with their ideas and programs. Why don't they get it?
2008-02-06
61 reads
Compensation
Employee compensation is more than just salary. Steve Jones talks about how you might look at building more effective compensation plans for workers.
2008-02-05
100 reads
2008-02-04
50 reads
More Layers
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
2008-02-04
56 reads
2008-02-01
343 reads
The January Car Update
The bimonthly update looks at a compressed air car, the X-Prize, daily rentals, and hybrid pickups.
2008-01-31
169 reads
Fixing SQL Server
If we will get a new version of SQL Server every 3 years, how can we make the process smoother.
2008-01-30
236 reads
The Mistake
SQL Server 2008 has been delayed and Steve Jones thinks the entire process of building this version has been poorly handled.
2008-01-29
446 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...
Alamat BCA KCU BEKASI | Tlp/WA:0817819444
Wa:0817819444 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Alamat BCA KCU TUBAN | Tlp/WA:0817781222
Wa:0817819444 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
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