Copilot vs ChatGPT vs Gemini AI

 

 

Choosing between Microsoft Copilot, ChatGPT, and Gemini AI depends on your environment and what you need the AI to do.

• Microsoft Copilot is the best fit for organizations deeply using the Microsoft 365 ecosystem. It excels at structured, context-based tasks such as automating Power BI workflows, assisting in Teams, and enhancing productivity and collaboration across Office apps.

• ChatGPT is the most versatile and flexible option. It suits creatives, educators, developers, and businesses needing customizable solutions for content creation, brainstorming, coding, or general problem-solving. Its adaptability makes it ideal for both individuals and startups across many industries.

• Gemini AI shines with its multimodal strengths and smooth integration into Google Workspace. It’s excellent for multimedia content creation, real-time insights, and team collaboration—making it a great choice for marketing teams, creative professionals, and companies already using Google’s ecosystem.

Ultimately, the right tool depends on your tech stack, your workflow, and the type of AI assistance you require.

Cheers

Samitha

GitHub Copilot

 GitHub Copilot is an AI-powered coding companion that helps with code completion, editing, reviewing, documenting, and managing projects, while offering customization, enterprise control, and integration across multiple development environments.

Core Coding Features

• Code Completion:
  Autocomplete-style code suggestions in supported IDEs (VS Code, Visual Studio, JetBrains, etc.).
  VS Code also supports next edit suggestions to predict your next likely edit.

• Copilot Chat:
  AI chat assistant for coding help, available in IDEs, GitHub.com, GitHub Mobile, and Windows Terminal.
  Supports “skills” for specialized tasks.

• Copilot Edits:
  Lets Copilot modify code directly across multiple files.

  • Edit Mode: User controls files and iterations (for precise updates).

  • Agent Mode: Copilot autonomously edits and iterates to complete complex tasks.

• Copilot Coding Agent:
  An autonomous AI that can make code changes, resolve issues, and create pull requests automatically.

• Copilot CLI (Public Preview):
  Command-line tool for asking Copilot questions, editing local files, and managing GitHub issues or pull requests.

Collaboration & Review

• Copilot Code Review:
  AI-generated code review feedback and suggestions.

• Copilot Pull Request Summaries:
  Automatically summarizes PR changes and areas to review.

• Copilot Text Completion (Preview):
  Writes pull request descriptions quickly and clearly.

• Copilot in GitHub Desktop:
  Suggests commit messages and descriptions automatically.

Customization & Extensions

• Copilot Extensions:
  Integrate third-party tools into Copilot Chat; available on GitHub Marketplace.

• Copilot Custom Instructions:
  Tailor Copilot responses based on personal or project-specific preferences.

• Copilot Spaces:
  Centralize project resources (code, docs, specs) for contextualized Copilot responses.

• Copilot Knowledge Bases (Enterprise):
  Add organization-specific docs as context for Copilot Chat queries.

Advanced Tools

• GitHub Spark (Preview):
  Build and deploy full-stack apps using natural language prompts.

• Copilot Coding Agent (Advanced):
  Executes multi-step coding tasks, handles errors, and integrates with external systems.

Enterprise & Admin Features

• Policy Management:
  Control which Copilot features are enabled across orgs and enterprises.

• Access Management:
  Define who can use Copilot within organizations.

• Usage Data & Audit Logs:
  Track adoption, usage metrics, and user activity for governance.

• Exclude Files:
  Prevent Copilot from accessing sensitive or irrelevant files.

Cheers

Samitha

Securing Connection Strings & AppSettings in ASP.NET Core

 ASP.NET Core apps use appsettings.json to store configuration like connection strings, API keys, and secrets. If unprotected, these can expose sensitive data.

Why Security Matters

• Connection strings often include DB usernames & passwords.

• API keys/secrets can unlock external services.

• Misconfigurations may leak data in logs or errors.

• Compromised values can lead to data theft, privilege escalation, or abuse.

Default Configuration Sources

• appsettings.json

• appsettings.{Environment}.json

• Environment variables

• User Secrets (development)

• Key vaults/Secrets managers (production)

Security Options

1. User Secrets (Dev Only)

   • Stored locally, not in source control.

   • dotnet user-secrets set "ConnectionStrings:DefaultConnection" "..."

2. Environment Variables

   • Safer than JSON files, follows 12-factor app principles.

   • Example (PowerShell):

     $env:ConnectionStrings__DefaultConnection="..."
     

3. Cloud Secret Managers (Production)

   • Azure Key Vault

     builder.Configuration.AddAzureKeyVault(
         new Uri($"https://{builder.Configuration["KeyVaultName"]}.vault.azure.net/"),
         new DefaultAzureCredential());
     

   • AWS Secrets Manager

     var secret = await secretsManager.GetSecretValueAsync(
         new GetSecretValueRequest { SecretId = "MyApp-DbConnection" });
     

Best Practice: 

Use User Secrets for local dev, Environment Variables for staging, and a Cloud Secret Manager for production.

Cheers

Samitha

SQL Server 2025 (preview) working with JSON

 

Working with JSON in SQL Server

SQL Server allows you to store JSON text in database tables and use built-in functions to query or modify it using standard T-SQL.

1. Extract Values from JSON

You can extract values using:

JSON_VALUE: Returns a scalar value (e.g., string, number).

JSON_QUERY: Returns an object or array.

E.g.

SELECT JSON_VALUE(jsonCol, '$.info.address.Town') AS Town

FROM People

WHERE ISJSON(jsonCol) > 0;

SELECT JSON_QUERY(jsonCol, '$.info.skills') AS Skills

FROM People;

2. Modify JSON Data

Use JSON_MODIFY to update parts of a JSON string.

E.g

DECLARE @json NVARCHAR(MAX);

SET @json = '{"city":"Paris"}';

SET @json = JSON_MODIFY(@json, '$.city', 'London');

SELECT @json AS ModifiedJson;

-- Result: {"city":"London"}

3. Convert JSON to Rowset

Use OPENJSON to transform JSON arrays into tabular data.

E.g

DECLARE @json NVARCHAR(MAX) = N'[

  {"id": 1, "name": "Alice"},

  {"id": 2, "name": "Bob"}

]';

SELECT *

FROM OPENJSON(@json)

WITH (

    id INT,

    name NVARCHAR(100)

);

4. Validate JSON

E.g

Checks if a string is valid JSON (returns 1 if true).

SELECT ISJSON('{"name":"value"}') AS IsJson; -- Returns 1

SELECT ISJSON('invalid') AS IsJson;          -- Returns 0

5. Combined JSON

SELECT 

  Name,

  JSON_VALUE(jsonCol, '$.info.address.Town') AS Town,

  JSON_QUERY(jsonCol, '$.info.skills') AS Skills

FROM People

WHERE ISJSON(jsonCol) = 1

  AND JSON_VALUE(jsonCol, '$.info.address.Town') = 'Belgrade';

Cheers

Samitha

SQL Sever Introduces Copilot (preview)

 Copilot in SSMS helps you ask questions about your database and environment, and assists in writing T-SQL with AI. It doesn’t retain or use your data for training. Copilot works with SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL Database in Fabric. Query execution respects your login permissions—if you lack access to certain objects, Copilot can generate queries but cannot execute them.

read here for more information.

Cheers

Samitha

C# 14 Extension members

 C# 14 introduces new syntax for defining extension members, expanding on traditional extension methods. Key additions include:

• Extension properties and indexers alongside extension methods.

• Ability to define static extension members, making them appear as if they are static members of the extended type

Two Types of Extension Blocks:

Instance-like extension members (e.g., sequence.IsEmpty):

 

extension<TSource>(IEnumerable<TSource> source)

{

    public bool IsEmpty => !source.Any();

    public TSource this[int index] => source.Skip(index).First();

    public IEnumerable<TSource> Where(Func<TSource, bool> predicate) { ... }

}

Static-like extension members (e.g., IEnumerable<int>.Identity):

 

extension<TSource>(IEnumerable<TSource>)

{

    public static IEnumerable<TSource> Combine(IEnumerable<TSource> first, IEnumerable<TSource> second) { ... }

    public static IEnumerable<TSource> Identity => Enumerable.Empty<TSource>();

}

These features allow more natural syntax and better integration with existing types by simulating both instance and static members via extensions.

Cheers

Samitha

ASP.NET Core changes in .NET 9 MapStaticAssets

 MapStaticAssets is a new feature that enhances the delivery of static assets in web applications. It is intended as a  replacement for UseStaticFiles.  

MapStaticAssets offers key advantages over UseStaticFiles, including:

• Build-time compression:

  • Uses gzip during development and gzip + Brotli during publish, minimizing asset sizes.

• Content-based ETags:

• Generates ETags from the SHA-256 hash of each file’s content, ensuring browsers only re-download files when their content changes

Read more here.

Cheers

Samitha