SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

Technology Toolbox: VB.NET, C#, SQL Server "Yukon" All versions of SQL Server prior to SQL Server "Yukon" provide two ways to write procedural code that executes inside the database. The usual way is ...

SQL Server 2025 gives developers new ways to work with text, JSON, real-time data changes and AI-ready vector data. Microsoft MVP Leonard Lobel explains why he considers it the most significant SQL ...

Devart today launched Devart SQL Formatter Online, a browser-based SQL Server code formatter that provides immediate ...

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation. I once was pulled into a discussion about the ...

The migration tool rewrites complex routines into PostgreSQL cursors, but application teams must also change testing and data access for cursor-based outputs.