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 have a good understanding of the concepts behind relational databases and the purpose of SQL. This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications. ...
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 have a good understanding of the concepts behind relational databases and the purpose of SQL. This book will help you build a solid foundation of understanding, beginning with core relational database concepts and continuing to reinforce those concepts with real-world T-SQL query applications. ...
Microsoft Windows Small Business Server 2003
Get your mission-critical network, messaging, and collaboration systems up and running quickly with the essential guide to administering Windows Small Business Server 2003. This reference details the features, capabilities, and technologies for both the standard and premium editions - including Microsoft Windows Server 2003, Exchange Server 2003, Windows SharePoint Services, SQL Server 2000, and Internet Information Services - in one volume. Packed with easy-to-follow procedures, real-world troubleshooting tactics, and under-the-hood insights, this Administrator's Companion delivers the expert information you need for everyday, on-the-job results. ...
Get your mission-critical network, messaging, and collaboration systems up and running quickly with the essential guide to administering Windows Small Business Server 2003. This reference details the features, capabilities, and technologies for both the standard and premium editions - including Microsoft Windows Server 2003, Exchange Server 2003, Windows SharePoint Services, SQL Server 2000, and Internet Information Services - in one volume. Packed with easy-to-follow procedures, real-world troubleshooting tactics, and under-the-hood insights, this Administrator's Companion delivers the expert information you need for everyday, on-the-job results. ...
Sams Teach Yourself SQL in 24 Hours, 5th Edition
In just 24 sessions of one hour or less, you'll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you'll learn hands-on through practical examples. Each lesson builds on what you've already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques - including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server! ...
In just 24 sessions of one hour or less, you'll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you'll learn hands-on through practical examples. Each lesson builds on what you've already learned, giving you a strong real-world foundation for success. The authors guide you from the absolute basics to advanced techniques - including views, transactions, Web data publishing, and even powerful SQL extensions for Oracle and Microsoft SQL Server! ...
Pro T-SQL Programmer's Guide, 4th Edition
Pro T–SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success. Transact–SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. Support for in-memory stored procedures running queries against in-memory tables is new in the language and gets coverage in this edition. Also covered are ...
Pro T–SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success. Transact–SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. Support for in-memory stored procedures running queries against in-memory tables is new in the language and gets coverage in this edition. Also covered are ...
Exam Ref 70-413 Designing and Implementing a Server Infrastructure, 2nd Edition
Prepare for Microsoft Exam 70-413 - and help demonstrate your real-world mastery designing, and implementing Windows Server infrastructure in an enterprise environment. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Designed for IT professionals responsible for designing, implementing, and maintaining a Windows Server 2012 infrastructure in an enterprise-scaled, highly virtualized environment. ...
Prepare for Microsoft Exam 70-413 - and help demonstrate your real-world mastery designing, and implementing Windows Server infrastructure in an enterprise environment. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Designed for IT professionals responsible for designing, implementing, and maintaining a Windows Server 2012 infrastructure in an enterprise-scaled, highly virtualized environment. ...
Exam Ref 70-696 Managing Enterprise Devices and Apps
Prepare for Microsoft Exam 70-696--and help demonstrate your real-world mastery of managing enterprise devices and apps. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Assumes you have experience with Windows Server, System Center 2012 R2 Configuration Manager, Microsoft Intune, and enterprise client management - plus basic Microsoft SQL Server, Windows PowerShell, and application configuration skills. ...
Prepare for Microsoft Exam 70-696--and help demonstrate your real-world mastery of managing enterprise devices and apps. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Assumes you have experience with Windows Server, System Center 2012 R2 Configuration Manager, Microsoft Intune, and enterprise client management - plus basic Microsoft SQL Server, Windows PowerShell, and application configuration skills. ...
Microsoft Azure SQL Database Step by Step
Your hands-on guide to Azure SQL Database fundamentals. Expand your expertise - and teach yourself the fundamentals of Microsoft Azure SQL Database. If you have previous programming experience but are new to Azure, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques. Understand the differences between SQL Server and Microsoft Azure SQL Database. ...
Your hands-on guide to Azure SQL Database fundamentals. Expand your expertise - and teach yourself the fundamentals of Microsoft Azure SQL Database. If you have previous programming experience but are new to Azure, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques. Understand the differences between SQL Server and Microsoft Azure SQL Database. ...
SQL: A Beginner's Guide, 3rd Edition
Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. ...
Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. ...
Dynamic SQL
This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It's also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure. Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond instantly to changing user needs as those users explore their data and view the results. Yet dynamic SQL is feared by many due to concerns over SQL injection attacks. Reading Dynamic SQL: Applications, Performance, and Security is your opportunity to learn and master an often misunderstood feature, including security and SQL injection. All aspects of security relevant to dynamic SQL are discussed in this book. You will learn many ways to save time and develop code more efficiently, and you will practice ...
This book is an introduction and deep-dive into the many uses of dynamic SQL in Microsoft SQL Server. Dynamic SQL is key to large-scale searching based upon user-entered criteria. It's also useful in generating value-lists, in dynamic pivoting of data for business intelligence reporting, and for customizing database objects and querying their structure. Executing dynamic SQL is at the heart of applications such as business intelligence dashboards that need to be fluid and respond instantly to changing user needs as those users explore their data and view the results. Yet dynamic SQL is feared by many due to concerns over SQL injection attacks. Reading Dynamic SQL: Applications, Performance, and Security is your opportunity to learn and master an often misunderstood feature, including security and SQL injection. All aspects of security relevant to dynamic SQL are discussed in this book. You will learn many ways to save time and develop code more efficiently, and you will practice ...
Exam Ref 70-765 Provisioning SQL Databases
Prepare for Microsoft Exam 70-765 - and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Implement SQL in Azure; Manage databases and instances; Manage storage. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills. ...
Prepare for Microsoft Exam 70-765 - and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Implement SQL in Azure; Manage databases and instances; Manage storage. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills. ...