Better Licensing
Licensing SQL Server used to be easy and could be again, though it is still better than licensing Oracle.
2007-12-17
247 reads
Editorials
What Would You Do?
If someone acts suspicious at work, do you report them? What if it's the CIO? What if data security is involved?
2007-12-14
101 reads
Another Reason to Hate Ads
Malicious code embedded inside advertisements served on the web. What's next?
2007-12-13
71 reads
The Downside of Real Time
Everyone wants real time reporting, or do they? Steve Jones talks about some of the downsides of implementing such a system.
2007-12-12
130 reads
Do We Need a PK?
A primary key is a must for every table. Or is it? Steve Jones examines the question.
2007-12-11
473 reads
Hipp, Hipp, Hooray
In an age where commercial interests seem to trump all, it's nice to see someone delivering content out there for free.
2007-12-10
126 reads
All I Want For Christmas Is ...
What do IT workers want for Christmas? Let us know in this Friday's poll.
2007-12-07
65 reads
A Smart Smartphone
Cell phones are great communication tools, but that's mostly what they do, even for IT folks. But Steve Jones talks about some other possibilities and potential problems.
2007-12-06
60 reads
Breaking Things Apart
Microsoft is unbundling their new hypervisor from Windows. Could this happen with SQL Server?
2007-12-05
47 reads
The Weekly Update for Dec 2, 2007
A few notes and comments on the database news from the previous week.
2007-12-03
26 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