Denny Figuerres

I started with computers about 24 years back. First PC was a Commodore VIC 20 and my “Mass Storage” was a cassette tape deck from my stereo gear with a home made A/D converter built from a 555 timer IC. I have worked at a large ISP for several years www.inreach.com based in Stockton California, I was there with the founder John Keagy in the 95-98 time frame when it went from 2,000 subs to 30,000 subs. I ran the support desk for a while and then the IT support including the adoption of RadiusNT form IEA software that logged dialup use form the modem banks to the tune of about 6 million SQL database records per month using SQL 6.5. For the last 4 years I have been working with a Billing and Ops’ system company www.internetsupportsystems.com in florida; I also do custom stuff for different folks in the local area. I have spent many hours with many levels of engineers from Cisco and Motorola. For a while I was on the IETF “Anti Spam Working Group”. I heard a lot of ideas about spam and was able to make some good points about the problem of the internet and the way things work.

All authors

SQLServerCentral Article

Port Blocking, SQL Server, and the Internet

The SQL Server ports 1433, was blocked recently by an ISP. New Author Denny Figuerres read our release and decided to bring you some comments about why this isn't such a bad idea. Read on and see if you agree that blocking the SQL Server ports shouldn't present you any problems.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-06-18

9,267 reads

All authors

Blogs

T-SQL Tuesday #192: What career risks have you taken?

By

I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...

AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source

By

Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...

How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment

By

Quite the title, so let me set the stage first. You have an Azure...

Read the latest Blogs

Forums

how to write this query?

By water490

hi everyone I am not sure how to write the query that will produce...

Rollback vs. Roll Forward

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Rollback vs. Roll Forward

Foreign Keys - Foes or Friend?

By utsav

Comments posted to this topic are about the item Foreign Keys - Foes or...

Visit the forum

Question of the Day

Fun with JSON I

I have some data in a table: 

CREATE TABLE #test_data
(
    id INT PRIMARY KEY,
    name VARCHAR(100),
    birth_date DATE
);

-- Step 2: Insert rows  
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned? 
SELECT *
FROM OPENJSON(
     (
         SELECT t.* FROM #test_data AS t FOR JSON PATH
     )
             ) t;

See possible answers