The T-SQL Paradigm
This Friday, Steve Jones looks for opinions on what you think of the T-SQL language. Is it well structured or does it really need help?
2009-04-02
560 reads
Editorial - WMV
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-30
460 reads
Annoyances
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
2009-03-26
304 reads
The Need for Tape
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
2009-03-25
745 reads
It Depends
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
2009-03-24
71 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-23
642 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-22
785 reads
Secure Programming
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
2009-03-18
477 reads
SQL Server Knockoffs
Will we see a low-cost SQL Server knock-off at some point? Steve Jones thinks it could happen as the RDBMS becomes a commodity product.
2009-03-16
568 reads
Letting People Go Securely
Having employees leave your company is a reality of life. But how do you handle letting your IT workers go and protect your systems? Steve Jones isn't sure there is much you can do to prevent issues, but you can deal with them.
2009-03-15
780 reads
Blogs
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Forums
Adding new column with DEFAULT II
Comments posted to this topic are about the item Adding new column with DEFAULT...
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
You Need a DBA Pipeline
Comments posted to this topic are about the item You Need a DBA Pipeline
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers