Lazy Developers - Database Weekly (2008/07/28)
Developers tend to be lazy in Steve Jones' view. This week he examines some of the problems that this lack of effort can cause in applications.
2008-07-25
222 reads
Editorial - WMV
Service Accounts
A Friday poll from Steve Jones looks at service accounts and how you deal with passwords.
2008-07-24
59 reads
Virtual Conversions
Virtualization is becoming more and more popular, being implemented in many companies every day to replace the need to add more physical boxes to your data center. Steve Jones comments on some of the handy features of virtualization.
2008-07-23
48 reads
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
2008-07-22
65 reads
The IT Employee Benchmark
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow.
2008-07-21
54 reads
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
2008-07-19
48 reads
The Database Weekly Update for July 21, 2008
In this update from the past week Steve Jones looks at leaks in encrypted disks and Web 2.0 development.
2008-07-18
212 reads
Soft Skills
A guest Friday poll from Adam Angelini, DBA and member of the band Wakamojo, which was featured on some editorial podcasts. This week Adam wonders about soft skills for DBAs.
2008-07-17
207 reads
Pulling Together
When a co-worker is ill, what should the rest of the office do? How do you handle absences that might extend for weeks or months. Steve Jones comments on the responsibilities of the team.
2008-07-16
54 reads
Untouched Data
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
2008-07-15
66 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