Beginning Microsoft SQL Server 2012 Programming

DOWNLOAD NOW »

Author: Paul Atkinson,Robert Vieira

Publisher: John Wiley & Sons

ISBN: 1118236211

Category: Computers

Page: 864

View: 4919

Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012. You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications. Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

Abfragen von Microsoft SQL Server 2012 - Original Microsoft Training für Examen 70-461

Praktisches Selbststudium und Prüfungsvorbereitung

DOWNLOAD NOW »

Author: Itzik Ben-Gan,Dejan Sarka,Ron Talmage

Publisher: Microsoft Press Deutschland

ISBN: 3848301679

Category: Computers

Page: 700

View: 8492

Erlernen Sie das Abfragen von Microsoft SQL Server 2012 und bereiten Sie sich gleichzeitig auf das Examen 70-461 vor. Das vorliegende Buch bietet Ihnen einen umfassenden Lehrbuchteil, mit dem Sie selbständig lernen und anhand praktischer Übungen die prüfungsrelevanten Fähigkeiten erwerben. Die anschließende Lernzielkontrolle ermöglicht Ihnen, anhand von Fragen und Antworten Ihre Kenntnisse zu überprüfen. Das Buch eignet sich auch als Nachschlagewerk für die tägliche Arbeit. Auf CD finden Sie eine Testprüfung mit 200 Fragen (englischsprachig). Verbessern Sie Ihre Kenntnisse und Ihre beruflichen Chancen mit diesem Original Microsoft Training.

Professional Windows 8 Programming

Application Development with C# and XAML

DOWNLOAD NOW »

Author: Nick Lecrenski,Doug Holland,Allen Sanders,Kevin Ashley

Publisher: John Wiley & Sons

ISBN: 1118228529

Category: Computers

Page: 504

View: 2371

Beginning SQL Server 2012 for Developers

DOWNLOAD NOW »

Author: Robin Dewson

Publisher: Apress

ISBN: 1430237503

Category: Computers

Page: 720

View: 2795

Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012. Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012. Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code. Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server 2012. Takes you through the entire database application development lifecycle Includes brand new coverage of SQL Server 2012 features Introduces the freely-available Express Edition What you’ll learn How to install SQL Server 2012 How to build a database application from start to finish How to create tables and indices to manage your data How to write stored code to execute directly in the database server How to back up, recover, and otherwise maintain your database How to connect to your database from client languages such as C# and VB .NET Who this book is for Beginning SQL Server 2012 for Developers is ideal for developers starting out with SQL Server 2012. There is no prerequisite background in developing database applications. Developers from other platforms and those brand new to database programming alike will find in Beginning SQL Server 2012 for Developers an excellent introduction to using and programming Microsoft’s database platform. Table of Contents Overview and Installation SQL Server Management Studio Database Design and Creation Security and Compliance Defining Tables Creating Indexes and Database Diagramming Database Backups and Recovery Database Maintenance Inserting and Deleting Data Selecting and Updating Data Building a View Stored Procedures, Functions, and Security Essentials for Effective Coding Advanced T-SQL Triggers Connecting from Client Code

SQL Server Security

DOWNLOAD NOW »

Author: Thomas Glörfeld

Publisher: MITP-Verlags GmbH & Co. KG

ISBN: 3826694236

Category: Computers

Page: 400

View: 9179

Alles Wissenswerte rund um Security mit SQL-Datenbanken Für Datenbankentwickler, Betriebswirte und Projektleiter Stand SQL Server 2012 Aus dem Inhalt: Aufwand vs. Sicherheit - Was ist angemessen? Sprich »Freund« und tritt ein – Authentifizierung Benutzer und Rollen Rechte – Der Unterschied zwischen Wollen und Dürfen Softwarearchitektur und Datenbank-Sicherheit Rechteprüfung in der Anwendung SQL-Injection Verschlüsselung mit Zertifikaten und asymmetrischen Schlüsseln Symmetrische Verschlüsselung Daten hashen und signieren Security-Features rund um gespeicherte Prozeduren Auditing Andere bewährte Vorgehensweisen Umgang mit Meldungen über Sicherheitslücken In diesem Buch geht es um typische Angriffe, zu denen Schwächen und Sicherheitslücken in Datenbank-Anwendungen möglicherweise geradezu einladen. Das Themenspektrum, das in diesem Buch abgehandelt wird, reicht von Einsteigerthemen wie die effektive Nutzung von Rechten, Logins, User und Gruppen über die verschiedenen Verschlüsselungsmöglichkeiten der Daten bis hin zu Expertenthemen wie die Signierung von SQL-Code. Die bekannt gewordenen Angriffe der letzten Jahre zeigten zwar, dass auch bei der Administration von IT-Systemen eklatante Mängel vorkamen, dass die wirklich gravierenden und entscheidenden Sicherheitsprobleme aber durch die Anwendungen selbst verursacht wurden. Es geht also vorrangig darum, die Möglichkeiten und Grenzen bei der Entwicklung von Datenbank-Anwendungen aufzuzeigen, zumal mit den Mitteln, die SQL bereit stellt, bereits viele Schwierigkeiten umschifft werden können. Das Buch richtet sich vornehmlich an Software-Entwickler, darüber hinaus aber auch an Betriebswirte, die verstehen wollen, warum manche »einfache« Vorgaben einen immensen Aufwand verursachen, sowie an Projektleiter, die schon bei der grundlegenden Architektur der Anwendung Sicherheitsaspekte berücksichtigen wollen. Sowohl Einsteiger, die sich mit den Grundlagen der SQL-Security vertraut machen wollen, als auch Fortgeschrittene, die tiefer in die Materie eintauchen möchten, werden von diesem Buch profitieren. Thomas Glörfeld studierte Informatik mit Schwerpunkt Datenbanksysteme. Seit 1995 beschäftigt er sich als Berater mit der Sicherheit rund um SQL-Datenbank-Anwendungen, seit der Version 4.21 für den Microsoft SQL Server, inkl. Abstecher zum Sybase SQL Anywhere.

Beginning SQL Server 2012 Administration

DOWNLOAD NOW »

Author: Robert Walters,Grant Fritchey

Publisher: Apress

ISBN: 1430239824

Category: Computers

Page: 440

View: 5786

Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It’s an ideal book for those new to database administration, as well for those moving to SQL Server from other database brands such as Oracle and IBM DB2. SQL Server is more than just a database. It's situated within a larger context that includes solutions for reporting, for integrating data from other systems, for business intelligence and analysis, and more. Beginning SQL Server 2012 Administration paints the big picture to help you understand SQL Server’s place in the grand scheme. Then you’ll move into the nuts and bolts of installing the product, learning the management tools at your disposal, creating your first database, and maintaining that database in an ongoing state of readiness. Beginning SQL Server 2012 Administration goes beyond teaching just the core competencies of effective database administration. You will also learn the latest trends in SQL Server such as virtualizing and consolidating of servers, and using SQL Server in the cloud as a service. Administrators experienced on other platforms will find insight from comparisons of key features between SQL Server and other platforms. Beginning SQL Server 2012 Administration lays an excellent foundation for success as an SQL Server database administrator. Provides the essentials of successful SQL Server administration Covers the latest trends such as virtualization and cloud computing Paints the big picture of Microsoft’s data platform

Beginning ASP.NET for Visual Studio 2015

DOWNLOAD NOW »

Author: William Penberthy

Publisher: John Wiley & Sons

ISBN: 1119077230

Category: Computers

Page: 792

View: 5275

The complete guide to the productivity and performance enhancements in ASP.NET Beginning ASP.NET for Visual Studio 2015 is your ultimate guide to the latest upgrade of this historically popular framework. Fully updated to align with the vNext release, this new edition walks you through the new tools and features that make your workflow smoother and your applications stronger. You'll get up to speed on the productivity and performance improvements, and learn how Microsoft has committed itself to more continuous innovation by increasing its release cadence for all products and services going forward. Coverage includes Async-aware debugging, ADO.NET idle connection resiliency, managed return value inspection, ASP.NET app suspension, on-demand large object heap compaction, multi-core JIT and more. The news of an off-cycle update to ASP.NET came as a surprise, but its announcement garnered cheers at the 2014 Microsoft BUILD conference. This guide shows you what all the fuss is about, and how Microsoft overhauled the latest ASP.NET release. Get acquainted with the new developer productivity features Master the new tools that build better applications Discover what's new in Windows Store app development Learn how Microsoft fixed the issues that kept you from v5 Over 38 million websites are currently using ASP.NET, and the new upgrade is already leading to increased adoption. Programmers need to master v6 to remain relevant as web development moves forward. Beginning ASP.NET for Visual Studio 2015 walks you through the details, and shows you what you need to know so you can get up and running quickly.

Microsoft SQL Server 2008 Internals

Insiderwissen zur Verbesserung der Systemleistung von Microsoft SQL Server 2008

DOWNLOAD NOW »

Author: Kalen Delaney

Publisher: N.A

ISBN: 9783866456563

Category: Database management

Page: 818

View: 924

Microsoft SQL Server 2012 Step by Step

DOWNLOAD NOW »

Author: Patrick LeBlanc

Publisher: Pearson Education

ISBN: 073567003X

Category: Computers

Page: 432

View: 8584

Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012 Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems. Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply techniques for building high-performing applications Use clustering, database mirroring, and log shipping

Beginning ASP.NET 4.5.1: in C# and VB

DOWNLOAD NOW »

Author: Imar Spaanjaars

Publisher: John Wiley & Sons

ISBN: 1118846966

Category: Computers

Page: 864

View: 3063

Build your ASP.NET 4.5.1 skills with real-worldinstruction In this comprehensive guide to getting started with ASP.NET 4.5.1,best-selling author Imar Spaanjaars provides a firm foundation forcoders new to ASP.NET and key insights for those not yet familiarwith the important updates in the 4.5.1 release. Readers learn howto build full-featured ASP.NET websites using Visual Studio Express2013 for Web, Microsoft’s free development tool for ASP.NETweb applications. Beginning ASP.NET 4.5.1 guides you throughthe process of creating a fully functional, database-drivenwebsite, from creation of the most basic site structure all the waydown to the successful deployment of the website to a productionenvironment. Beginning ASP.NET 4.5.1: in C# and VB: Explains how to get started with ASP.NET 4.5.1, including anintroduction to Microsoft’s Visual Studio Express 2013 forWeb Features helpful examples for designing websites with CSS andHTML and how to overcome common formatting problems Shares techniques for managing server controls in ASP.NET,including standard controls, HTML controls, and data controls Provides real-world tips for creating consistent page layoutsthroughout your websites Covers practical functionality issues like validating userinput, sending e-mail from your website, and processing data at theserver Details what the ASP.NET state engine is and why it isimportant Shows how to access and modify data in a SQL Serverdatabase Includes coverage of jQuery, LINQ, and the EntityFramework Explores measures to take for optimal security

Einführung in SQL

DOWNLOAD NOW »

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 8057

SQL kann Spaß machen! Es ist ein erhebendes Gefühl, eine verworrene Datenmanipulation oder einen komplizierten Report mit einer einzigen Anweisung zu bewältigen und so einen Haufen Arbeit vom Tisch zu bekommen. Einführung in SQL bietet einen frischen Blick auf die Sprache, deren Grundlagen jeder Entwickler beherrschen muss. Die aktualisierte 2. Auflage deckt die Versionen MySQL 6.0, Oracle 11g und Microsoft SQL Server 2008 ab. Außerdem enthält sie neue Kapitel zu Views und Metadaten. SQL-Basics - in null Komma nichts durchstarten: Mit diesem leicht verständlichen Tutorial können Sie SQL systematisch und gründlich lernen, ohne sich zu langweilen. Es führt Sie rasch durch die Basics der Sprache und vermittelt darüber hinaus eine Reihe von häufig genutzten fortgeschrittenen Features. Mehr aus SQL-Befehlen herausholen: Alan Beaulieu will mehr vermitteln als die simple Anwendung von SQL-Befehlen: Er legt Wert auf ein tiefes Verständnis der SQL-Features und behandelt daher auch den Umgang mit Mengen, Abfragen innerhalb von Abfragen oder die überaus nützlichen eingebauten Funktionen von SQL. Die MySQL-Beispieldatenbank: Es gibt zwar viele Datenbankprodukte auf dem Markt, aber welches wäre zum Erlernen von SQL besser geeignet als MySQL, das weit verbreitete relationale Datenbanksystem? Der Autor hilft Ihnen, eine MySQL-Datenbank anzulegen, und nutzt diese für die Beispiele in diesem Buch. Übungen mit Lösungen: Zu jedem Thema finden Sie im Buch gut durchdachte Übungen mit Lösungen. So ist sichergestellt, dass Sie schnell Erfolgserlebnisse haben und das Gelernte auch praktisch umsetzen können.

Beginning Visual C# 2012 Programming

DOWNLOAD NOW »

Author: Karli Watson,Jacob Vibe Hammer,Jon D. Reid,Morgan Skinner,Daniel Kemper,Christian Nagel

Publisher: John Wiley & Sons

ISBN: 111833194X

Category: Computers

Page: 912

View: 1135

Step-by-step beginner’s guide to Visual C# 2012 Written for novice programmers who want to learn programmingwith C# and the .NET framework, this book offers programming basicssuch as variables, flow control, and object oriented programming.It then moves into web and Windows programming and data access(databases and XML). The authors focus on the tool that beginnersuse most often to program C#, the Visual C# 2012 developmentenvironment in Visual Studio 2012. Puts the spotlight on key beginning level topics witheasy-to-follow instructions for Microsoft Visual C# 2012 Explores how to program for variables, expressions, flowcontrol, and functions Explains the debugging process and error handling as well asobject oriented programming, and much more Beginning Microsoft Visual C# 2012Programming offers beginners a guide to writing effectiveprogramming code following simple step-by-step methods, eachfollowed by the opportunity to try out newly acquired skills.

Beginning T-SQL 2012

DOWNLOAD NOW »

Author: Scott Shaw,Kathi Kellenberger

Publisher: Springer

ISBN: 143023704X

Category: Computers

Page: 456

View: 4037

Each book aims to teach an important technology or programming language and is designed to take a person from being a novice to a professional by including the most essential information and explaining step by step how to put together real-world projects.

Microsoft SQL Server 2012

das Handbuch

DOWNLOAD NOW »

Author: Thomas Joos

Publisher: N.A

ISBN: 9783866451513

Category: Database management

Page: 1022

View: 8264

Oracle PL/SQL Programmierung

DOWNLOAD NOW »

Author: Steven Feuerstein,Bill Pribyl

Publisher: O'Reilly Verlag DE

ISBN: 9783897211841

Category: ORACLE 9i

Page: 1058

View: 4762

Pro SQL Server 2012 BI Solutions

DOWNLOAD NOW »

Author: Randal Root,Caryn Mason

Publisher: Apress

ISBN: 1430234881

Category: Computers

Page: 836

View: 6355

Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete! Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business intelligence solutions for their companies and departments. Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft's SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need. Provides recipes for multiple business intelligence scenarios Progresses from simple to advanced projects using several examples Shows Microsoft SQL Server technology used to complete real-world business intelligence projects What you’ll learn How to plan and implement cost-effective business intelligence projects How to create practical data warehouse databases How to extract, transform, and load data with Integration Services How to develop OLAP cubes and dimensions on Analysis Server How to create Reporting Server reports using both SQL and MDX How to apply performance-tuning techniques to get the most from your solutions Who this book is for Pro SQL Server 2012 BI Solutions is aimed at database administrators, SQL programmers, and report developers who create business intelligence solutions for midsized businesses and departments. Table of Contents BI Solutions A Big Picture Overview Planning Solutions Designing Data Warehouses Implementing Data Warehouses with SQL ETL Processing with SQL Beginning an SSIS Project Additional SSIS Configurations Beginning an SSAS Project Configuring Dimensions with SSAS Creating and Configuring SSAS Cubes Additional Cube and Dimension Configurations Reporting with SQL Queries Reporting with MDX Queries Reporting with Microsoft Excel Beginning an SSRS Project Configuring Reports with SSRS Testing and Tuning BI Solutions Approve, Release, and Prepare

Beginner SQL Programming Using Microsoft SQL Server

DOWNLOAD NOW »

Author: Kalman Toth

Publisher: Createspace Independent Pub

ISBN: 9781479335565

Category: Computers

Page: 290

View: 3971

Beginning level SQL (Structured Query Language) programming teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are new to relational database and client/server technologies. Practical SQL Server based training for database developers, database designers and database administrators (DBA), who know some SQL programming and database design, and who wish to refresh & expand their RDBMS development technology horizons. Familiarity with at least one computer programming language, Windows file system & Excel is assumed. Since the book is career advancement oriented, it has a great number of practical SQL queries (over 1,100 SELECT queries) and T-SQL scripts, plenty to learn indeed. The queries are based on historic and current SQL Server sample databases: pubs (PRIMARY KEYs 9, FOREIGN KEYs 10) , Northwind (PRIMARY KEYs 13, FOREIGN KEYs 13) and the latest AdventureWorks series. Among them: AdventureWorks, AdventureWorks2008, AdventureWorks2012 (PRIMARY KEYs 71, FOREIGN KEYs 90), & AdventureWorksDW2012 (PRIMARY KEYs 27, FOREIGN KEYs 44). The last one is a data warehouse database. The book teaches through vivid T-SQL queries how to think in terms of sets at a very high level, focusing on set-based operations instead of loops like in procedural programming languages. The best way to master T-SQL programming is to type the query in your own SQL Server Management Studio Query Editor, test it, examine it, change it and study it. Wouldn't it be easier just to copy & paste it? It would, but the learning value would diminish rapidly. You need to feel the SQL language in your DNA. SQL queries must "pour" out from your fingers into the keyboard. Why is knowing SQL queries by heart so important? After all everything can be found on the web so why not just copy & paste? Well not exactly. If you want to be an database development expert, it has to be in your head not on the web. Second, when your supervisor is looking over your shoulder, "Charlie, can you tell me what is the total revenue for March?", you have to be able to type the query without documentation or SQL forum search and provide the results to your superior promptly. The book was designed to be readable in any environment, even on the beach laptop around or no laptop in sight at all. All queries are followed by results row count and /or full/partial results listing in tabular (grid) format. Screenshots are used when dealing with GUI tools such as SQL Server Management Studio. Mastery of SQL programming book likely to be sufficient for career advancement as a database developer.

Beginning T-SQL

DOWNLOAD NOW »

Author: Kathi Kellenberger,Scott Shaw

Publisher: Apress

ISBN: 1484200462

Category: Computers

Page: 496

View: 5615

Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008. Beginning T-SQL begins with an introduction to databases, normalization, and to SQL Server Management Studio. Attention is given to Azure SQL Database and how to connect to remote databases in the cloud. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in most chapters provide an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional. Important techniques such as windowing functions are covered to help write fast executing queries that solve real business problems. A stand-out feature in this book is that most chapters end with a "Thinking About Performance" section. These sections cover aspects of query performance relative to the content just presented. They'll help you avoid beginner mistakes by knowing about and thinking about performance from Day 1. Imparts best practices for writing T-SQL Helps you avoid common errors Shows how to write scalable code for good performance

SQL für Dummies

DOWNLOAD NOW »

Author: Allen G. Taylor

Publisher: VCH

ISBN: 9783527710201

Category: COMPUTERS

Page: 440

View: 2581

Datenbanken sind das beste Werkzeug, um wichtige Informationen im Auge zu behalten. Mit SQL kOnnen die vorhandenen Daten strukturiert und zielsicher abgefragt werden. In "SQL fUr Dummies" macht Allen G. Taylor die Leser mit der Abfragesprache SQL und dem aktuellen Standard SQL:2011 verstAndlich und humorvoll vertraut. Er beginnt mit dem notwendigen Grundlagenwissen fUr den Aufbau eines Datenbankmanagementsystems und den SQL-Hauptkomponenten, zeigt auf, wie man die Daten erstellt, ordnet und abfragt und SQL-Anweisungen in Programme einbindet. Zudem erklArt er, wie SQL mit XML verknUpft werden kann, um Websites mit einer Datenbank zu verbinden. Au'erdem gibt es jede Menge Profi-Informationen, wie man zum Beispiel Datenbanken und Daten schUtzen kann und Fehler lokalisiert und behebt.

SQL Server 2012 T-SQL Recipes

A Problem-Solution Approach

DOWNLOAD NOW »

Author: Jason Brimhall,David Dye,Andy Roberts,Wayne Sheffield,Jonathan Gennick

Publisher: Apress

ISBN: 1430242000

Category: Computers

Page: 808

View: 3884

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2012 Comprehensive: Covers all common T-SQL problem domains What you’ll learn Create databases, tables, and indexes Query and manipulate data Store and manage XML inside the database Move business logic into the database Resolve common performance problems. Build reports that matter to your business. Perform common backup and recovery tasks. Who this book is for SQL Server 2012 T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use Microsoft SQL Server 2012 as their back–end database, and the database administrators who create, manage, and secure those databases. Table of Contents Getting Started with SELECT Elementary Programming Nulls and Other Pitfalls Combining Data from Multiple Tables Grouping and Summarizing Advanced SELECT Techniques Query Techniques for Reporting Inserting, Updating, Deleting Working with Strings Working with Dates Working with Numbers Transactions, Locking, Blocking, Deadlocking Managing Tables Managing Views Managing Indexes Managing Large Tables Stored Procedures User-Defined Functions Triggers Error Handling Query Performance Hints Index Tuning and Statistics XML Files, Filegroups, and Integrity Backup Recovery Principals and Users Securables and Permissions Objects and Dependencies