SQL Server Express and MySQL are both free relational databases for smaller or embedded apps, yet they differ in important ways. Here is how they compare.
SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
My first article on Simple-Talk introduces Change Data Capture in SQL Server 2008, which records INSERTs, UPDATEs and DELETEs in simple relational change tables.
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
SQL Server 2008 lets you copy database with data: turn on Script Data in the Generate Scripts wizard to get INSERT statements for the rows in your tables.
SQLAuthority News – SQL Server Value Calculator
The SQL Server Value Calculator estimates what an organization could save with SQL Server 2008, based on team size, servers, security, audits and more.
SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
What is the difference between Line Feed (\n) and Carriage Return (\r)? Why Windows, Mac and Unix read a new line differently, and what it means in T-SQL.
SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1
The Risk and Health Assessment Program for SQL Server Scoping Tool v1.1 helps Microsoft Premier customers prepare their environment for a RAP engagement.
SQLAuthority News – Download – SQL Server 2008 Developer Training Kit
Download the SQL Server 2008 Developer Training Kit by Microsoft to learn how to build web applications with the new data types in SQL Server 2008.