Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Transact-SQL, or T-SQL, is Microsoft Corporation’s powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS). You may already have a basic idea of what SQL is used for, but you may not…

Pro Full-Text Search in SQL Server 2008

Pro Full-Text Search in SQL Server 2008

Businesses today want actionable insights into their data—they want their data to reveal itself to them in a natural and user–friendly form. What could be more natural than human language? Natural–language search is at the center of a storm of ever–increasing web–driven demand for human–computer communication and information…

Professional SQL Server 2005 Performance Tuning

Professional SQL Server 2005 Performance Tuning

Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. In addition, the authors demonstrate how to make use of the key tools for SQL Server Performance tuning. Broken…

SQL Server 2008 Transact-SQL Recipes

SQL Server 2008 Transact-SQL Recipes

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact-SQL tasks and…

Beginning SQL Server 2005 Programming

Beginning SQL Server 2005 Programming

After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release. Once readers have grasped the fundamentals…

PowerShell for SQL Server Essentials

PowerShell for SQL Server Essentials

PowerShell for SQL Server Essentials helps us to manage and monitor server administration and application deployment. Use PowerShell along with SQL Server to perform common DBA tasks. Starting with a basic introduction to PowerShell, the initial chapters will provide the SQL Server professional PowerShell fundamentals, covering topics such…