It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
2009-11-16
699 reads
It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
2009-11-16
1,261 reads
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
304 reads
There were tons of people taking pictures and video during the PASS Summit. I found a number of pictures on...
2009-11-13
1,372 reads
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
1,085 reads
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
348 reads
This Friday Steve Jones has a poll for the programmers and hybrid DBAs out there. If you work with code, why do you use C#? Or why not?
2009-11-13
329 reads
I’m not going to look back at the keynotes since I blogged about them. If you are interested, you can...
2009-11-12
770 reads
The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.
2009-11-12
6,494 reads
I think it went off well this year, and it looks like it will be around next year as well....
2009-11-12
892 reads
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
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