There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...

The Microsoft SQL Server team has made incremental updates to SQL Server Data Tools (SSDT), updating the Schema Compare utility, improving Microsoft Azure SQL Database security and supporting Parallel ...

Queries work well if the databases are designed correctly. Here's what you need to know to build the foundations for your SQL Server databases. Most IT professionals and developers understand the ...

Microsoft has made SQL Server 2025 generally available. The latest version of the database focuses on built-in AI functionality and developer ...

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Last month I told you about the overall set of features which Microsoft plans to release when SQL Server 2014 (SQL2014) is released to manufacturing. Microsoft has three major feature sets that they ...

Almost 4000 people from 48 different countries congregated in Seattle to mark the beginning of the most attended PASS Summit ever. Thousands more attended via the first ever live-streaming of the ...