Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
2008-08-19
47 reads
Editorial - WMV
Epidemic Priority
As IT becomes more and more important to not only businesses but governments, what does that mean in the event of a disaster?
2008-08-18
54 reads
Telework Works
As a telecommuter Steve Jones has found it has increased his productivity, but he's not alone. Sun has examined their own telework program from the energy perspective.
2008-08-16
65 reads
The Training Value
Training is something that Steve Jones believes in for an successful IT career. However this Friday he asks how much should your employer help.
2008-08-14
70 reads
A Release from Data
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
2008-08-13
64 reads
Snooping
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
2008-08-12
58 reads
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-11
61 reads
The Starting Point
The Mojave Experiment is a marketing effort by Microsoft that is very interesting in looking at first impressions. Steve Jones comments.
2008-08-10
60 reads
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
2008-08-08
233 reads
2008-08-06
68 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