Cláudio Tereso

I'm from the Spectrum generation. I started copying programs from books so I could play them when I wasn't even 10 years old. From there, programming my own programs was a leap. As a teenager I did programming work for university students and when I started working it was in programming.

My interests changed and I entered the area of databases, SQL programming and network administration, areas in which I obtained several Microsoft certifications. Along the way I also published the books, by the Portuguese Editor FCA, "Local Networks in Windows 98 & 95 - Complete Course" and the corresponding update for the hated Windows Me.

I now work with SQL Server, Power BI, Azure and related Microsoft technology. I'm also having some fun with Python.
  • Interests: orienteering and all things mountain :)

All authors

All authors

Blogs

10 Decisions to Make Before You Create A Fabric Workspace

By

Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...

Flyway Tips: Object History

By

It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...

Car Update September 2026

By

Software is hard. While I love our Lucid Gravity, I realize that they are...

Read the latest Blogs

Forums

Alamat BCA KCP Cempaka Putih Telp:08218520153

By layanan_Bca88

WhatsApp CS 628218520153 Jl. Letjen Suprapto No.30 EF, RT.7/RW.2, Harapan Mulya, Kec. Kemayoran, Kota...

Alamat BCA KCP Menteng Telp:08218520153

By m4rt1n4

WhatsApp CS 628218520153 Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat,...

Alamat BCA KCP Wahid Hasyim Telp:08218520153

By R4nt4u

WhatsApp CS 628218520153 Jl. K.H. Wahid Hasyim No.82, RT.15/RW.3, Kb. Sirih, Kec. Menteng, Kota...

Visit the forum

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 = 1

See possible answers