Having been married to Microsoft for most of my professional career doesn’t mean I drink the Kool-Aid. I have had the distinct privilege to grow up in interesting times. I loved DOS. As a BBS operator DOS was the de facto OS for most BBSes that ran on..
2009-06-19
3,001 reads
Learn how you can create your own data types in this SQL School video. MVP Andy Warren explains the process of setting up user-defined data types.
2009-06-18
3,977 reads
Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.
2009-06-18
6,582 reads
This Friday Steve Jones asks about advice for other DBAs. What's the best way for those intermediate and accidental DBAs to handle maintenance on their servers?
2009-06-18
724 reads
This Friday Steve Jones asks about advice for other DBAs. What's the best way for those intermediate and accidental DBAs to handle maintenance on their servers?
2009-06-18
678 reads
This Friday Steve Jones asks about advice for other DBAs. What's the best way for those intermediate and accidental DBAs to handle maintenance on their servers?
2009-06-18
987 reads
Learn to enable the FILESTREAM feature in SQL Server 2008 and configure your database to support it.
2009-06-18
2,817 reads
As I've related previously (Part 1, Part 2, Part 3, Part 4, Part 5) I've been working author and speaker Don Gabor on my networking skills. We recently did our final call of the six hours coaching planned, and thought I'd share some final thoughts.
2009-06-18
1,274 reads
Recent installments of our series dedicated to the most prominent features of SQL Server 2005 Express Edition have discussed its reporting capabilities. This article illustrates another approach to generating reports, relying on the Report Server Project template, which offers a considerably wider range of flexibility than its wizard-driven counterpart does.
2009-06-18
2,151 reads
People don't plan to fail; they fail to plan. Single node clustering provides organisations with a ready made scale-up or high availability platform from the beginning of the deployment.
2009-06-17
6,918 reads
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
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...
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