Andrea Dottor's Avatar

Andrea Dottor

@andrea.dottor.net

-- Podcast .NET in pillole -- -- Microsoft MVP Developer Technologies -- .NET & Web Consultant | Developer | Speaker

78 Followers  |  89 Following  |  49 Posts  |  Joined: 11.11.2024  |  2.1809

Latest posts by andrea.dottor.net on Bluesky

Preview
305 - TickerQ, un'ottima idea di base, ma potrร  competere con Hangfire e Quartz? In questa puntata scopriamo TickerQ, un nuovo Job Scheduler che entra in competizione con Hangfire e Quartz.NET. In questa puntata andiamo a vedere cosa lo differenzia dagli altri, ed il come lo si utilizza. - https://github.com/Arcenox-co/TickerQ - https://tickerq.arcenox.com/ #dotnet #tickerq #jobscheduler #taskscheduler #podcast #dotnetinpillole

๐Ÿ“ฃ New Podcast! "305 - TickerQ, un'ottima idea di base, ma potrร  competere con Hangfire e Quartz?" on @Spreaker #dotnet #taskscheduler #tickerq

11.08.2025 05:00 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
304 - Dalle password alle passkey: lโ€™evoluzione di ASP.NET Identity In questa puntata esploriamo lโ€™evoluzione di ASP.NET Identity: dalle origini con Membership fino al supporto alle passkey che arriverร  in .NET 10. Un viaggio tra sicurezza, autenticazione moderna e API REST per gestire al meglio lโ€™identitร  degli utenti nelle applicazioni .NET. - https://learn.microsoft.com/en-us/aspnet/core/security/authentication/identity - https://devblogs.microsoft.com/dotnet/dotnet-10-preview-6/ - https://learn.microsoft.com/en-us/aspnet/core/release-notes/aspnetcore-10.0 #dotnet #aspnet #aspnetidentity #dotnet10 #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "304 - Dalle password alle passkey: lโ€™evoluzione di ASP.NET Identity" on @Spreaker #aspnet #dotnet #dotnet10 #identity

04.08.2025 05:01 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
303 - Dal caos al controllo: riduci il rumore nei log con .NET 9 In questa puntata scopriamo come ottimizzare il logging in .NET grazie a due potenti funzionalitร  introdotte in .NET 9: log sampling e log buffering. Vedremo come ridurre il rumore, migliorare le performance e mantenere il controllo sui log, anche in ambienti ad alto carico. Meno log, piรน valore. - https://devblogs.microsoft.com/dotnet/emit-logs-on-demand-with-log-buffering/ - https://devblogs.microsoft.com/dotnet/finetune-the-volume-of-logs-your-app-produces/ - https://learn.microsoft.com/en-us/dotnet/core/extensions/log-sampling - https://learn.microsoft.com/en-us/dotnet/core/extensions/log-buffering #dotnet #logging #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "303 - Dal caos al controllo: riduci il rumore nei log con .NET 9" on @Spreaker #dotnet #log #optimization

28.07.2025 05:01 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Release Stable Release v6.1.0 ยท dotnet/SqlClient Release Notes Stable Release 6.1.0 - 2025-07-25 This update brings the following changes since the 6.0.2 stable release: Added Added dedicated SQL Server vector datatype support What Changed: Opti...

Finally here: Microsoft .Data.SqlClient 6.1!
- huge perf improvements to async blob read
- new Vector data type support
- other perf and bug fixes
#dotnet #sqlserver
github.com/dotnet/SqlCl...

26.07.2025 08:22 โ€” ๐Ÿ‘ 9    ๐Ÿ” 4    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
302 - CQRS in .NET con Brighter e Darker: alternativa a MediatR? In questa puntata esploriamo Brighter e Darker, due librerie open-source progettate per applicare il pattern CQRS in modo chiaro e scalabile su .NET. Confronteremo inoltre Brighter con MediatR, analizzando vantaggi, differenze e scenari dโ€™uso, per capire se possono essere una valida alternativa. - https://github.com/BrighterCommand/Darker - https://github.com/BrighterCommand/Brighter - https://brightercommand.gitbook.io/paramore-brighter-documentation - https://mareks-082.medium.com/a-brighter-alternative-to-mediatr-and-masstransit-69d46d10b4b8 #dotnet #cqrs #cqs #Brighter #Darker #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "302 - CQRS in .NET con Brighter e Darker: alternativa a MediatR?" on @Spreaker #brighter #cqrs #cqs #dotnet #masstransit #mediatr

21.07.2025 05:02 โ€” ๐Ÿ‘ 2    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland
YouTube video by TEDx Talks Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland

I just wanted to say, Iโ€™m probably more proud of this Ted talk than just about anything Iโ€™ve ever done so Iโ€™m gonna be absolutely useless for the next couple of weeks as I promote the shit out of this because I want you to watch it because it matters in the moment we are in youtu.be/dVG8W-0p6vg

17.07.2025 20:37 โ€” ๐Ÿ‘ 983    ๐Ÿ” 270    ๐Ÿ’ฌ 83    ๐Ÿ“Œ 91
Preview
301 - Arrivata la versione commerciale di Mediatr e AutoMapper, che fare ora? Il 2 luglio Jimmy Bogard ha annunciato il rilascio delle versioni commerciali delle sue librerie Mediatr e AutoMapper. In questa puntata vediamo quali sono i prezzi e i termini di licenza, fino a trarne delle conclusioni a riguardo. - https://www.jimmybogard.com/automapper-and-mediatr-commercial-editions-launch-today/ - https://mediatr.io/ - https://automapper.io/ #dotnet #automapper #mediatr #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "301 - Arrivata la versione commerciale di Mediatr e AutoMapper, che fare ora?" on @Spreaker #automapper #commercial #dotnet #mediatr

14.07.2025 05:01 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Microsoft MVP per il 17ยฐ anno!! Oggi si festeggia alla grande #microsoft #mvp #microsoftmvp

10.07.2025 15:52 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
300 - UnitsNet: gestire le unitร  di misura in .NET non รจ mai stato cosรฌ facile In questa puntata ti presento UnitsNet, una libreria .NET che ti permette di lavorare con grandezze fisiche in modo sicuro, leggibile e senza errori di conversione. Dalle lunghezze alla temperatura, dalla pressione alla velocitร : scopri come puรฒ semplificarti la vita (e il codice). E se lavori anche in frontend, ti sorprenderร  sapere che esiste anche una versione JavaScript: `unitsnet-js`! - https://github.com/angularsen/UnitsNet - https://github.com/haimkastner/unitsnet-js #dotnet #unitsnet #csharp #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "300 - UnitsNet: gestire le unitร  di misura in .NET non รจ mai stato cosรฌ facile" on @Spreaker #csharp #dev #dotnet #unitsnet

07.07.2025 05:01 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
299 - Parallelismo e zero allocazioni: LINQ non รจ mai stato cosรฌ veloce In questa puntata esploriamo due modi per portare LINQ al livello successivo: PLINQ, per sfruttare il parallelismo e velocizzare l'elaborazione dei dati, e ZLinq, per ottenere performance elevate senza allocazioni e con supporto AOT. Due approcci diversi, stessi obiettivi: scrivere codice piรน efficiente e performante. - https://learn.microsoft.com/en-us/dotnet/standard/parallel-programming/introduction-to-plinq - https://github.com/Cysharp/ZLinq #dotnet #plinq #zlinq #tpl

๐Ÿ“ฃ New Podcast! "299 - Parallelismo e zero allocazioni: LINQ non รจ mai stato cosรฌ veloce" on @Spreaker #dotnet #plinq #tpl #zlinq

30.06.2025 05:01 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
298 - Stop! In nome del Token - La cancellazione cooperativa in C# In questa puntata parliamo di CancellationToken in C#: cosโ€™รจ, come funziona e perchรฉ รจ fondamentale per scrivere codice asincrono e reattivo. Vediamo come usarlo per annullare operazioni in modo cooperativo, come gestire timeout, come combinare piรน token con LinkedTokenSource e quali errori evitare. Un episodio per chi vuole fermare le coseโ€ฆ nel modo giusto! - https://learn.microsoft.com/en-us/dotnet/standard/threading/cancellation-in-managed-threads - https://medium.com/@mitesh_shah/a-deep-dive-into-c-s-cancellationtoken-44bc7664555f - https://learn.microsoft.com/en-us/dotnet/api/system.threading.cancellationtokensource #dotnet #cancellationtoken #asyncawait #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "298 - Stop! In nome del Token - La cancellazione cooperativa in C#" on @Spreaker #asyncawait #cancellationtoken #dotnet

23.06.2025 05:01 โ€” ๐Ÿ‘ 0    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

GitHub Copilot Bootcamp in corso! Una serata diversa dai classici meeting, e a quanto pare รจ stata ben apprezzata #xedotnet #github #copilot #community

20.06.2025 18:39 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
297 - Task Parallel Library: metti il turbo al tuo codice C# In questa puntata parliamo della Task Parallel Library (TPL) in C#: cosa offre, quando usarla, e come sfruttare strumenti come Task, Parallel.For, Task.WaitAll e Task.WhenAll per scrivere codice piรน veloce ed efficiente. Unโ€™introduzione pratica e discorsiva al mondo del parallelismo, con consigli su come evitare gli errori piรน comuni. - https://learn.microsoft.com/en-us/dotnet/standard/parallel-programming/task-parallel-library-tpl - https://www.youtube.com/watch?v=18w4QOWGJso - https://www.youtube.com/watch?v=18w4QOWGJso #dotnet #tpl #TaskParallelLibrary #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "297 - Task Parallel Library: metti il turbo al tuo codice C#" on @Spreaker #dotnet #taskparallellibrary #tpl

16.06.2025 05:00 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
.NET 10 Preview 5 is now available! - .NET Blog Find out about the new features in .NET 10 Preview 5 across the .NET runtime, SDK, libraries, ASP.NET Core, Blazor, C#, .NET MAUI, and more!

๐Ÿš€ .NET 10 Preview 5 is out!

Check out these updates & more:
๐Ÿ”’ Post-Quantum Cryptography
๐Ÿ“ƒ OpenAPI 3.1 updates
โž• User-defined compound assignment operators
๐Ÿ“Š Blazor metrics & tracing
๐ŸŒ XAML global namespaces for MAUI

devblogs.microsoft.com/dotnet/dotne...

#dotnet10 #csharp

10.06.2025 18:33 โ€” ๐Ÿ‘ 17    ๐Ÿ” 7    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 1
Preview
.NET 10 Preview 5 is now available! Find out about the new features in .NET 10 Preview 5 across the .NET runtime, SDK, libraries, ASP.NET Core, Blazor, C#, .NET MAUI, and more! The post .NET 10 Preview 5 is now available! appeared first on .NET Blog.

.NET 10 Preview 5 is now available!

10.06.2025 19:15 โ€” ๐Ÿ‘ 0    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Release v2.3.0 ยท ZiggyCreatures/FusionCache ๐Ÿ”‘ Access the cache key in the factory context Community user @posledam and others asked for the ability to access the cache key in the factory context, to be able to work with it while going to the...

FusionCache v2.3.0 is out ๐Ÿฅณ

Juicy things in this release:
๐Ÿ”‘ Access cache key in factory context
โš™๏ธ New InternalStrings options
โš™๏ธ New FusionCacheEntryOptionsProvider
๐Ÿž Fix for read-only methods
โœ… Better tests + update to xUnit v3
๐Ÿ“• Docs

github.com/ZiggyCreatur...

09.06.2025 08:52 โ€” ๐Ÿ‘ 2    ๐Ÿ” 3    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
296 - Lโ€™arte dellโ€™attesa: async e await senza segreti Ok, quante volte hai scritto await senza davvero sapere cosa sta succedendo dietro? In questa puntata ci facciamo una bella chiacchierata su come funziona lโ€™asincronia in C#: parliamo di Task, ValueTask, TaskCompletionSource.ย  Ecco alcune risorse per approfondire il tutto: - https://github.com/davidfowl/AspNetCoreDiagnosticScenarios/blob/master/AsyncGuidance.md - https://learn.microsoft.com/en-us/archive/msdn-magazine/2013/march/async-await-best-practices-in-asynchronous-programming - https://github.com/meysamhadeli/awesome-dotnet-tips/blob/main/docs/csharp/async/async-and-await.md - https://github.com/meysamhadeli/awesome-dotnet-tips/blob/main/docs/csharp/async/async-best-practice.md Video di Marco Minerva: - https://youtu.be/23oyxTAutsQ?si=ZC2JWTG2IU3M3X_7 - https://youtu.be/L4J-m45NWSo?si=wy2emxJwFMvBJ_63 #dotnet #asyncawait #dotnetinpilloleย 

๐Ÿ“ฃ New Podcast! "296 - Lโ€™arte dellโ€™attesa: async e await senza segreti" on @Spreaker #asyncawait #dotnet #task #valuetask

09.06.2025 05:00 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
295 - C# si fa leggero! Scripting in C#: un file, nessun progetto, zero scuse C# si fa leggero! In questa puntata esploriamo 'dotnet run app.cs', la nuova funzionalitร  di .NET 10 che permette di scrivere ed eseguire script C# senza creare un progetto. Un solo file .cs, niente .csproj, e puoi partire subito: perfetto per prototipi, automation e piccoli tool da riga di comando. Scopri come funziona, cosa puoi farci e perchรฉ potrebbe diventare il tuo nuovo modo di usare C#. - https://devblogs.microsoft.com/dotnet/announcing-dotnet-run-app/ - https://youtu.be/98MizuB7i-w?si=pguTqEmNOECnssPu - https://devblogs.microsoft.com/visualstudio/agent-mode-has-arrived-in-preview-for-visual-studio/ #dotnet #copilot #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "295 - C# si fa leggero! Scripting in C#: un file, nessun progetto, zero scuse" on @Spreaker #agent #copilot #csharp #dotnet #run #scripting

02.06.2025 05:00 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Announcing dotnet run app.cs - A simpler way to start with C# and .NET 10 - .NET Blog Run C# files instantly with dotnet run app.cs, no project file needed! Coming to .NET 10, try it out today in Preview 4.

Announcing `dotnet run app.cs`: A simpler way to start with C# and .NET 10

devblogs.microsoft.com/dotnet/annou...

28.05.2025 16:02 โ€” ๐Ÿ‘ 44    ๐Ÿ” 15    ๐Ÿ’ฌ 6    ๐Ÿ“Œ 4
Preview
Enhance productivity with AI + Remote Dev Enhance your developer productivity with AI and Remote Development.

code.visualstudio.com/blogs/2025/0...

28.05.2025 19:43 โ€” ๐Ÿ‘ 3    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Running SQL Server 2025 on Linux Containers in WSL Hey there! Ready to dive into the awesome world of SQL Server 2025? This latest release is packed with cool new features and enhancements that you won't want to miss. Curious to know more? Check out the SQL Server on Linux release-notes for all the exciting details! In this blog post, I will show you how quick and easy it is to get SQL Server 2025 up and running in a container on Windows Subsystem for Linux (WSL). Weโ€™ll create a test database, set up some tables, and even play around with a few REGEX functions using the latest SQL Server Management Studio! Running SQL Server in containers on WSL is super flexible for development and testing. Itโ€™s perfect for developers who want to experiment with Linux-native features on a Windows machine without needing a separate Linux system. Letโ€™s get started! For detailed instructions on setting up WSL, check out the Install WSL guide. You can also deploy SQL Server as a systemd service by following the SQL Server Installation on WSL guide. First things first, install WSL and a SQL Server 2025 compatible distro. For this demo, I went with Ubuntu 22.04. Iโ€™ve already got Docker Desktop installed on my machine to manage the containers. With this setup, you can install any supported SQL Server on the WSL-compatible distro for testing or demo purposes. Itโ€™s super handy for any development work too. wsl --install wsl -l -o wsl --install Ubuntu-22.04 Heads up! The above step might need a system restart and will automatically download Ubuntu if itโ€™s not already on your system. Next, letโ€™s deploy SQL Server 2025 on Ubuntu 22.04. I ran a simple docker run command, and ta-da! I can connect to it using SQL Server Management Studio, as shown in below: docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=DontUseThisSmartPwd:)" \ -e "MSSQL_PID=Developer" -e "MSSQL_AGENT_ENABLED=true" \ -p 14333:1433 --name sqlcontainerwsl --hostname sqlcontainerwsl \ -d mcr.microsoft.com/mssql/server:2025-latest I tried out the new SQL Server Management Studio and had some fun testing few REGEX functions: /*Here are some SQL scripts to create some tables with sample records for the demo. These tables contain sample data for testing the regular expression functions.*/ --- 1. **employees Table: For REGEXP_LIKE Example** -- Create employees table with some records DROP TABLE IF EXISTS employees CREATE TABLE employees ( ID INT IDENTITY(101,1), [Name] VARCHAR(150), Email VARCHAR(320), Phone_Number NVARCHAR(20) ); INSERT INTO employees ([Name], Email, Phone_Number) VALUES ('John Doe', 'john@contoso.com', '123-4567890'), ('Alice Smith', 'alice@fabrikam@com', '234-567-81'), ('Bob Johnson', 'bob.fabrikam.net','345-678-9012'), ('Eve Jones', 'eve@contoso.com', '456-789-0123'), ('Charlie Brown', 'charlie@contoso.co.in', '567-890-1234'); GO -- 2. **customer_reviews Table: For REGEXP_COUNT Example** DROP TABLE IF EXISTS customer_reviews CREATE TABLE customer_reviews ( review_id INT PRIMARY KEY, review_text VARCHAR(1000) ); INSERT INTO customer_reviews (review_id, review_text) VALUES (1, 'This product is excellent! I really like the build quality and design.'), (2, 'Good value for money, but the software could use improvements.'), (3, 'Poor battery life, bad camera performance, and poor build quality.'), (4, 'Excellent service from the support team, highly recommended!'), (5, 'The product is good, but delivery was delayed. Overall, decent experience.'); GO -- 3. **process_logs Table: For REGEXP_INSTR Example** DROP TABLE IF EXISTS process_logs CREATE TABLE process_logs ( log_id INT PRIMARY KEY, log_entry VARCHAR(1000) ); INSERT INTO process_logs (log_id, log_entry) VALUES (1, 'Start process... Step 1: Initialize. Step 2: Load data. Step 3: Complete.'), (2, 'Begin... Step 1: Validate input. Step 2: Process data. Step 3: Success.'), (3, 'Step 1: Check configuration. Step 2: Apply settings. Step 3: Restart.'), (4, 'Step 1: Authenticate. Step 2: Transfer data. Step 3: Log complete.'), (5, 'Step 1: Initiate system. Step 2: Check logs. Step 3: Shutdown.'); GO -- 4. **transactions Table: For REGEXP_REPLACE Example** DROP TABLE IF EXISTS transactions CREATE TABLE transactions ( transaction_id INT PRIMARY KEY, credit_card_number VARCHAR(19) ); INSERT INTO transactions (transaction_id, credit_card_number) VALUES (1, '1234-5678-9101-1121'), (2, '4321-8765-1098-7654'), (3, '5678-1234-9876-5432'), (4, '9876-4321-6543-2109'), (5, '1111-2222-3333-4444'); GO -- 5. **server_logs Table: For REGEXP_SUBSTR and Data Cleanup Example** DROP TABLE IF EXISTS server_logs CREATE TABLE server_logs ( log_id INT PRIMARY KEY, log_entry VARCHAR(2000) ); INSERT INTO server_logs (log_id, log_entry) VALUES (1, '2023-08-15 ERROR: Connection timeout from 192.168.1.1 user admin@example.com'), (2, '2023-08-16 INFO: User login successful from 10.0.0.1 user user1@company.com'), (3, '2023-08-17 ERROR: Disk space low on 172.16.0.5 user support@domain.com'), (4, '2023-08-18 WARNING: High memory usage on 192.168.2.2 user hr@office.com'), (5, '2023-08-19 ERROR: CPU overload on 10.1.1.1 user root@system.com'); GO -- 6. **personal_data Table: For REGEXP_REPLACE (Masking Sensitive Data) Example** DROP TABLE IF EXISTS personal_data CREATE TABLE personal_data ( person_id INT PRIMARY KEY, sensitive_info VARCHAR(100) ); INSERT INTO personal_data (person_id, sensitive_info) VALUES (1, 'John Doe - SSN: 123-45-6789'), (2, 'Jane Smith - SSN: 987-65-4321'), (3, 'Alice Johnson - Credit Card: 4321-5678-1234-8765'), (4, 'Bob Brown - Credit Card: 1111-2222-3333-4444'), (5, 'Eve White - SSN: 111-22-3333'); GO /*These tables contain realistic sample data for testing the regular expression queries. You can modify or extend the records as needed for additional complexity. */ /* Let's see the use cases for `REGEXP_LIKE`, `REGEXP_COUNT`, `REGEXP_INSTR`, `REGEXP_REPLACE`, and `REGEXP_SUBSTR` in SQL. These examples are designed to handle real-world scenarios with multiple conditions, nested regex functions, or advanced string manipulations.*/ /* 1. **REGEXP_LIKE to filter based on Complex Pattern** Scenario #1: find all the employees whose email addresses are valid and end with .com */ SELECT [Name], Email FROM Employees WHERE REGEXP_LIKE(Email, '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.com$'); GO /* Scenario #2: Recreate employees table with CHECK constraints for 'Email' and 'Phone_Number' columns */ DROP TABLE IF EXISTS Employees CREATE TABLE Employees ( ID INT IDENTITY(101,1), [Name] VARCHAR(150), Email VARCHAR(320) CHECK (REGEXP_LIKE(Email, '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$')), Phone_Number NVARCHAR(20) CHECK (REGEXP_LIKE (Phone_Number, '^(\d{3})-(\d{3})-(\d{4})$')) ); INSERT INTO employees ([Name], Email, Phone_Number) VALUES ('John Doe', 'john@contoso.com', '123-456-7890'), ('Alice Smith', 'alice@fabrikam.com', '234-567-8100'), ('Bob Johnson', 'bob@fabrikam.net','345-678-9012'), ('Eve Jones', 'eve@contoso.com', '456-789-0123'), ('Charlie Brown', 'charlie@contoso.co.in', '567-890-1234'); GO -- CHECK Constraints - Ensure that the data fulfills the specified criteria. -- FAILURE - Try inserting a row with INVALID values: INSERT INTO Employees ([Name], Email, Phone_Number) VALUES ('Demo Data', 'demo@contoso.com', '123-456-7890'); GO SELECT * FROM Employees; --- /* 2. **`REGEXP_COUNT` to Analyze Word Frequency in Text** Scenario: Counting Specific Words in Large Text Data Suppose you have a `customer_reviews` table, and you want to count the number of occurrences of specific words like "excellent", "good", "bad", or "poor" to evaluate customer sentiment. */ SELECT review_id, REGEXP_COUNT(review_text, '\b(excellent|good|bad|poor)\b', 1, 'i') AS sentiment_word_count, review_text FROM customer_reviews; GO --- /* 3. **`REGEXP_INSTR to Detect Multiple Patterns in Sequence** Scenario: Identify the Position of Multiple Patterns in Sequence Imagine you have log data where each entry contains a sequence of steps, and you need to find the position of a specific pattern like "Step 1", "Step 2", and "Step 3", ensuring they occur in sequence. */ SELECT log_id, REGEXP_INSTR(log_entry, 'Step\s1.*Step\s2.*Step\s3', 1, 1, 0, 'i') AS steps_position FROM process_logs WHERE REGEXP_LIKE(log_entry, 'Step\s1.*Step\s2.*Step\s3', 'i'); GO --- /* 4. **`REGEXP_REPLACE` for replacing string based on the pattern match** Scenario: Redacting Sensitive Information with Variable Lengths You need to redact sensitive data from a table that contains personal information like Social Security Numbers (SSNs) and credit card numbers. The challenge is that the data might be in different formats (e.g., `###-##-####` for SSNs and `####-####-####-####` for credit cards). */ SELECT sensitive_info, REGEXP_REPLACE(sensitive_info, '(\d{3}-\d{2}-\d{4}|\d{4}-\d{4}-\d{4}-\d{4})', '***-**-****') AS redacted_info FROM personal_data; GO --- /* 5. **REGEXP_SUBSTR to Extract Nested Information** Scenario: Extract Specific Parts of a Complex String Format */ SELECT [Name], Email, REGEXP_SUBSTR(email, '@(.+)$', 1, 1,'c',1) AS Domain FROM employees; GO --- /* 6. **Combining Multiple REGEXP Functions for Data Transformation** Scenario: Log Cleanup and Transformation You have raw server logs that contain noisy data. Your goal is to: 1. Extract the date. 2. Count how many times the word "ERROR" appears. 3. Replace any email addresses with `[REDACTED]`. */ SELECT log_entry, REGEXP_SUBSTR(log_entry, '\d{4}-\d{2}-\d{2}', 1, 1) AS log_date, REGEXP_COUNT(log_entry, 'ERROR', 1, 'i') AS error_count, REGEXP_REPLACE(log_entry, '[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}', '[REDACTED]') AS cleaned_log FROM server_logs; GO --- --*TVFs* /* 7. **REGEXP_MATCHES - Find all the match in the string and return in tablular format***/ SELECT * FROM REGEXP_MATCHES ('Learning #AzureSQL #AzureSQLDB', '#([A-Za-z0-9_]+)'); /* 8. **REGEXP_SPLIT_TO_TABLE - Split string based on regexp pattern**/ SELECT * FROM REGEXP_SPLIT_TO_TABLE ('192.168.0.1|80|200|Success|192.168.0.2|443|404|Not Found', '\|') There are lot of exciting features in SQL Server 2025! The Linux version includes all engine features from the SQL Server 2025 on Windows. Check out the Whatโ€™s New for SQL Server 2025 Preview on Linux for all the details. Here are a few highlights: Set custom password policy for SQL logins in SQL Server on Linux Enable and run tempdb on tmpfs for SQL Server 2025 Preview on Linux Connect to ODBC data sources with PolyBase on SQL Server on Linux These features make SQL Server on Linux super versatile and powerful, giving you the same robust experience as on Windows. Conclusion SQL Server 2025 on Linux is a game-changer, offering flexibility and power for developers and IT pros alike. Whether you're developing, testing, or deploying in production, this setup has got you covered. ๐Ÿ”— References aka.ms/sqlserver2025 https://aka.ms/Build/sql2025blog. https://aka.ms/IntroMirroringSQL http://aka.ms/optimized-hp-blog https://aka.ms/tempdb-rg-blog https://aka.ms/sqlserver2025-ctp-diskann SQL Server on Linux FAQ

Running SQL Server 2025 on Linux Containers in WSL

28.05.2025 11:42 โ€” ๐Ÿ‘ 0    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Converting a docker-compose file to .NET Aspire In this post I describe how I converted the deployment method of the mailing-list manager lismonk from a docker-compose.yml file to an Aspire app host project

Blogged: Converting a docker-compose file to .NET Aspire

andrewlock.net/converting-a...

In this post I describe how I converted the deployment method of the mailing-list manager lismonk from a docker-compose.yml file to an Aspire app host project

#dotnet #Aspire #csharp

27.05.2025 16:01 โ€” ๐Ÿ‘ 11    ๐Ÿ” 6    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
294 - Liste, dizionari e collezioni: tutto il mondo .NET in una puntata Oggi ci tuffiamo nel fantastico (e affollatissimo) mondo delle collezioni in .NET: liste, dizionari, set, stack, queue, versioni concorrenti e persino quelle immutabili. Ma cosa cambia tra una List e un Array? Quando ha senso usare un HashSet? E che differenza cโ€™รจ tra Dictionary e ConcurrentDictionary? In questa puntata ti spiego tutto in modo semplice e concreto. - https://learn.microsoft.com/en-us/dotnet/api/system.collections - https://learn.microsoft.com/en-us/dotnet/api/system.collections.immutable - https://learn.microsoft.com/en-us/dotnet/standard/collections/thread-safe/ - https://learn.microsoft.com/en-us/dotnet/standard/collections/when-to-use-generic-collections #dotnetย  #list #collection #dictionary #dotnetinpillole

๐Ÿ“ฃ New Podcast! "294 - Liste, dizionari e collezioni: tutto il mondo .NET in una puntata" on @Spreaker #dotnet #immutable #threadsafe

26.05.2025 05:00 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Easily setup dev environments with WinGet and Microsoft DSC V3 | DEM572
YouTube video by Microsoft Developer Easily setup dev environments with WinGet and Microsoft DSC V3 | DEM572

WinGet Configuration Export. Demo from Microsoft Build: www.youtube.com/watch?v=vvdn...

24.05.2025 18:18 โ€” ๐Ÿ‘ 8    ๐Ÿ” 4    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
MSSQL Extension for VS Code: Introducing Schema Designer (Preview) - Azure SQL Devsโ€™ Corner Overview Database design can often feel like navigating a maze of tables, relationships, and data types โ€” especially when working directly with T-SQL scripts. But what if you could map out your databa...

MSSQL Extension for VS Code: Introducing Schema Designer (Preview) - Azure SQL Devsโ€™ Corner devblogs.microsoft.com/azure-sql/vs...

21.05.2025 17:34 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
.NET Aspire 9.3 is here and enhanced with GitHub Copilot! - .NET Blog .NET Aspire 9.3 is the biggest release of .NET Aspire yet, with the introduction of GitHub Copilot directly into the .NET Aspire Dashboard, updates for integrations, app model enhancements, and more.

.NET Aspire 9.3 is here with copilot.

devblogs.microsoft.com/dotnet/intro...

#dotnet #aspire #copilot

19.05.2025 18:23 โ€” ๐Ÿ‘ 45    ๐Ÿ” 17    ๐Ÿ’ฌ 3    ๐Ÿ“Œ 1
Preview
293 - Diagnosi senza stress: tracciare le operazioni in .NET con ActivitySource e Activity Scopri come Activity e ActivitySource ti aiutano a tracciare le operazioni allโ€™interno delle tue applicazioni .NET in modo semplice e standard. Vedremo come usarli al meglio, quali vantaggi offrono per il monitoraggio e la diagnosi, e come si integrano facilmente con OpenTelemetry e altri sistemi di osservabilitร . - https://learn.microsoft.com/en-us/dotnet/core/diagnostics/distributed-tracing - https://learn.microsoft.com/en-us/dotnet/core/diagnostics/distributed-tracing-instrumentation-walkthroughs - https://www.jimmybogard.com/building-end-to-end-diagnostics-activitysource-and-open/ - https://opentelemetry.io/docs/languages/dotnet/ - https://youtu.be/3JnMfJM9K0c?si=ymc-6tcw87geqHHw #dotnet #ActivitySource #observability #OpenTelemetry #dotnetinpillole #podcast

๐Ÿ“ฃ New Podcast! "293 - Diagnosi senza stress: tracciare le operazioni in .NET con ActivitySource e Activity" on @Spreaker #activitysource #dotnet #observability

19.05.2025 05:00 โ€” ๐Ÿ‘ 0    ๐Ÿ” 2    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Evaluating content safety in your .NET AI applications Announcing content safety evaluations and other imporvements in the Microsoft.Extensions.AI.Evaluation libraries. The post Evaluating content safety in your .NET AI applications appeared first on .NET Blog.

Evaluating content safety in your .NET AI applications

Announcing content safety evaluations and other imporvements in the Microsoft.Extensions.AI.Evaluation libraries. The post Evaluating content safety in your .NET AI applications appeared first on .NET Blog.

15.05.2025 17:17 โ€” ๐Ÿ‘ 0    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

GitHub Copilot Agent mode in Visual Studio with Model Context Protocol (MCP) support! ๐ŸŽ‰

14.05.2025 18:35 โ€” ๐Ÿ‘ 1    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
spot art.
text reads: ๐ŸŽ‰ Visual Studio 2022 v17.14 is now generally available!
See what's new, and don't forget to download it.

spot art. text reads: ๐ŸŽ‰ Visual Studio 2022 v17.14 is now generally available! See what's new, and don't forget to download it.

Visual Studio 2022 v17.14 is now generally available! โœจ Dive into AI-assisted development with GitHub Copilot's new agent mode, enhanced debugging tools, and more. Update today and experience the future of coding! Check it out. https://msft.it/6186SZGgq
#VisualStudioNews #GitHubCopilot #AI #DevTools

13.05.2025 18:25 โ€” ๐Ÿ‘ 13    ๐Ÿ” 5    ๐Ÿ’ฌ 2    ๐Ÿ“Œ 0

@andrea.dottor.net is following 20 prominent accounts