Advice I Like: Rewards from Work
The greatest rewards come from working on something that nobody has words for. If you possibly can, work where there are no names for what you do.” – from...
2026-04-10
36 reads
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but I’ve also watched teams stumble during adoption. FinOps sounds simple in theory: collaborate, track costs,...
2026-04-09
882 reads
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes. Somewhere in the business, a decision maker is sitting on a question that the data...
2026-04-17 (first published: 2026-04-07)
338 reads
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new to this blog party, I encourage you to check out the rules. If you are...
2026-04-07
45 reads
Voxxed Days Zurich
That was my first experience at a Voxxed Days event. Obviously I like Oracle-focussed events, but that can give you a blinkered view of the world. There’s a lot...
2026-04-07
34 reads
Did You Really Name That Default?
Ten years (and a couple jobs) ago, I wrote about naming default constraints to avoid having SQL Server name them for you. I closed with the following statement:
SQL Server...
2026-04-17 (first published: 2026-04-06)
416 reads
Monday Monitor Tips: A New Analysis Page
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard Edition, a few on the Enterprise Edition, and others handling core work, like the Linux/PostgreSQL...
2026-04-13 (first published: 2026-04-06)
212 reads
Case Studies: Real-World Success Stories of FinOps Implementation
Learning any kind of theory is easy, but adapting FinOps and watching it rescue a chaotic cloud environment is where it gets interesting. FinOps is about building a culture...
2026-04-15 (first published: 2026-04-06)
1,027 reads
SQL Server Security: Always Encryption
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE which is introduced on SQL Server 2008, TDE is at rest has limitation as data...
2026-04-13 (first published: 2026-04-04)
292 reads
SQL Server Security – TDE Encryption
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this feature encrypts a physical layer of Database files Data/log files protection at Disk / storage...
2026-04-04 (first published: 2026-04-03)
57 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
Alamat BCA KCP Mall Grand Indonesia Telp:08218520153
WhatsApp Cs 628218520153 Gedung Grand Indonesia Mall A, Lower Ground No. 20-21, Jl. M.H....
Alamat Kantor BCA KCP Senen Telp:08218520153
WhatsApp Cs 628218520153 Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....
BCA KCU PANGERAN JAYAKARTA Tlp:08218520153
WhatsApp Cs 628218520153 Jl. P Jayakarta Komp. No.127, RT.7/RW.7, Mangga Dua Sel., Kecamatan Sawah...
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