How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)

In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.

SSMS Copilot is Messing With Your AI Prompts

You might notice that the advice you get from Copilot in SSMS isn’t very good, but it isn’t necessarily AI in general. Part of the problem is something specific about SSMS Copilot and the way it prompts LLMs, and I wish I could tell you exactly what it is, but I can’t because I don’t have access to how SSMS is changing your prompts.

Microsoft are retiring role-based certifications. Here’s why they shouldn’t

In this Simple Talk opinion piece, Microsoft certification veteran Dr Greg Low considers – and shares his thoughts on – the recent announcement that many role-based Microsoft certifications are being retired.

Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data

This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection.

• Printed book:
  • US
• Kindle book:
  • US

Vibe coding and databases: the hidden risks of AI-generated database code

Explore how Andrej Karpathy’s “vibe coding” trend reached databases. Uncover risks, real incidents, and 5 critical failure patterns

What should you move first in a cloud migration? 5 key guidelines

Learn how to choose which application to move first in a cloud migration with five practical guidelines

How to run SQL Server on Amazon Elastic Container Service

Learn how to efficiently run SQL Server using Amazon Elastic Container Service for a hassle-free Docker container experience.

Local vs remote MCP servers – which should you choose?

Should you choose a local or remote MCP server? The best option depends on your security needs, performance goals, and deployment model. This guide explains the differences between local and remote Model Context Protocol (MCP) servers, including privacy, scalability, latency, and integration trade-offs.

You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.

When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually executed. It’s easy to miss whole swaths of code that didn’t happen to execute one particular time.

Improve Query Performance in the Fabric Warehouse with Clustering

Learn how to improve performance issues in Microsoft Fabric Warehouse and leverage cloud-based data analytics effectively.