The March 2009 Car Update
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
2009-03-31
153 reads
Editorials
Are We Wasting Too Much Time Social Networking?
The advent of social networking has excited many DBAs, but is that a good thing? Does social networking help or hurt you in your career?
2009-03-30
179 reads
The Visit of the Recovery Testers.
Phil has a nasty surprise when a team of testers turn up to test an n-tier system
2009-03-30
110 reads
Almost Like a Service Pack
Microsoft recently laid off a number of people and made a mistake that they handled poorly. Steve Jones comments about what could have been done better.
2009-03-24
150 reads
A Better English Query
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
2009-03-23
185 reads
Do DBAs Still Read Technical Books?
Despite my misgivings about the fall from favor of technology books, I was heartened to hear from the developers at Red Gate that the classic books on the art of programming are still important to them. What are the equivalent books for DBAs?
2009-03-23
451 reads
Being More Productive
This Friday's poll looks at your productivity. Is there some technology that has really helped you do your job better?
2009-03-20
152 reads
Guest Editorial: Short Transactions
It is ingrained in many developers and DBAs to keep transactions in SQL Server "as short as possible". Why does this mindset exist? Does it imply a deep-seated lack of confidence in the scalability of SQL Server's locking and concurrency models?
2009-03-18
181 reads
Software Licensing Cuts - Database Weekly (Mar 16, 2009)
In the news this week, Microsoft is cutting some licensing costs for larger companies. A good move for them as the economy slows.
2009-03-16
84 reads
Downtime
One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.
2009-03-13 (first published: 2009-02-20)
311 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