2014-12-25 (first published: 2014-12-04)
1,132 reads
Scripts
PowerShell Query to remove backup folders against multiple servers
Remove backup folders from multiple servers.
2014-12-23 (first published: 2014-12-09)
640 reads
2014-12-22 (first published: 2014-11-23)
1,238 reads
DB memory/RAM consumption
This script is used to get the memory or RAM consumption for the database(s).
2014-12-19 (first published: 2014-11-20)
2,808 reads
2014-12-12 (first published: 2014-11-19)
1,124 reads
dbWarden - Purge old data
helps you manage dbWarden history.
No warranty given it will do what you expect, so test it !
2014-12-11 (first published: 2014-11-19)
1,012 reads
2014-12-08 (first published: 2014-11-18)
1,385 reads
2014-12-04 (first published: 2014-11-17)
1,446 reads
2014-12-02 (first published: 2014-11-12)
2,300 reads
Create Table At Runtime
With the help of this script we can generate Create Table Script At Run Time.
2014-11-27 (first published: 2014-11-06)
1,184 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