A book aimed at developers who know how to program, but who don’t know SQL Server. An interesting proposition. This is the third edition of Robin Dewson's book for developers who are new to SQL Server ...

This book aims “…to provide a comprehensive introduction to SQL Server that is friendly to beginners.” How does it fare? The book’s introduction suggests that both new and existing SQL Server users ...

After reading SQL Server Forensic Analysis, you can answer "Yes, I can!" The other useful SQL Server book I've been digesting recently is Microsoft SQL Server 2008 Reporting Services Unleashed (SAMS ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here are ...

If you want to really enjoy reading a technical book or learning a new computer skill set, you just have to check out O’Reilly’s “Head First” series. These books fully earn their “brain-friendly” ...

SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...

SQL Server Management Studio can help take the guesswork out of creating connection strings for PowerShell applications.

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them. Initially created in the 1970s, ...