Triggers, Stored Procedures, And Functions

SQL Server: Triggers, Stored Procedures, and Functions with Martin Guidry [repost]

SQL Server: Triggers, Stored Procedures, and Functions with Martin Guidry
MP4 | Video: AVC 1280x720 | Audio: AAC 48KHz 2ch | Duration: 2 Hours | 261 MB
Genre: eLearning | Language: English

SQL Server: Triggers, Stored Procedures, and Functions  

Posted by videourok at May 18, 2014
SQL Server: Triggers, Stored Procedures, and Functions

SQL Server: Triggers, Stored Procedures, and Functions with Martin Guidry
MOV + Exercise Files | Duration: 1h 52m | 960x540 | Video: 30 fps 732 kbps | Audio: AAC 48KHz 96 kbps 2 stereo | 172 MB
Genre: eLearning | Level: Advanced | Language: English | Subtitles: English | Released: Sep 24, 2012

This course investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies. Author Martin Guidry shows how to combine these techniques and create a high-quality database using Microsoft SQL Server 2012. The course also covers real-world uses of the INSERT, UPDATE, and DELETE procedures, and how to build a basic web form to connect to your database.
Code Centric: T-SQL Programming with Stored Procedures and Triggers

Garth Wells - Code Centric: T-SQL Programming with Stored Procedures and Triggers
Published: 2001-01-29 | ISBN: 1893115836 | PDF | 692 pages | 25 MB

EngInSite MySQL Client 2.0.4.230  

Posted by vincente at Oct. 30, 2007
EngInSite MySQL Client 2.0.4.230

EngInSite MySQL Client 2.0.4.230 | 4 MB

This all-in-one tool will help you create, manage and edit MySQL databases. One intuitive interface for all tasks. Supports all releases of MySQL from 4.02 to 5.12 and all of the latest MySQL features including views, triggers, stored procedures and functions as well as InnoDB foreign keys.

EngInSite MySQL Client v1.4.9.195 Multilingual  Software

Posted by misirac at Jan. 17, 2007
EngInSite MySQL Client v1.4.9.195 Multilingual

EngInSite MySQL Client v1.4.9.195 Multilingual | 3,04 Mb

This all-in-one tool will help you create, manage and edit MySQL databases. One intuitive interface for all tasks. Supports all releases of MySQL from 4.02 to 5.12 and all of the latest MySQL features including views, triggers, stored procedures and functions as well as InnoDB foreign keys.
Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types (repost)

Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types by Douglas Hinson
English | December 11, 2006 | ISBN: 0470054034 | 432 Pages | PDF | 9 MB

SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and write to resources outside of SQL Server and enjoy a tighter integration with XML, web services, and simple file and logging capabilities.

Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types

Professional SQL Server 2005 CLR Programming: with Stored Procedures, Functions, Triggers, Aggregates and Types by Derek Comingore / Douglas Hinson
Publisher: Wrox | | ISBN: 0470054034 | PDF | 8.62 MB | 432 pages


SQL Server 2005 offers the capability to write code in a .NET language that can be compiled and run inside SQL Server. CLR Integration, or SQL CLR, lets you create stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language. You can read and write to resources outside of SQL Server and enjoy a tighter integration with XML, web services, and simple file and logging capabilities.
Here's the reference you'll want on your desk as you develop SQL CLR solutions. It helps you decide whether to use SQL CLR, how to lock down security, and learn from real examples. If you want to develop stored procedures or other objects in .NET for SQL Server 2005, this book offers exactly what you need.
What you will learn from this book
  • The concepts and architecture of SQL CLR
  • Uses of .NET namespaces in SQL Server programming tasks
  • How to develop and benchmark routines in T-SQL and .NET to determine when CLR-based solutions are advantageous
  • How to replace extended stored procedures using SQL CLR stored procedures
  • How to use SQL CLR objects in external applications
  • How to restrict and secure SQL CLR object capabilities
  • Processes and procedures for deploying SQL CLR objects

Who this book is for
This book is for developers and architects who are familiar with .NET concepts as well as DBAs who, although developers in their own right, may be slightly less up to date on .NET. A solid grounding in T-SQL is necessary.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Practical SQL Server In-Memory OLTP Tables and Objects  eBooks & eLearning

Posted by naag at May 14, 2016
Practical SQL Server In-Memory OLTP Tables and Objects

Practical SQL Server In-Memory OLTP Tables and Objects
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2h 50m | 414 MB
Genre: eLearning | Language: English

A practical approach to understanding the benefits and requirements of implementing in-memory OLTP tables, indexes, natively compiled stored procedures, and UDFs. This course also treats support, monitoring, and troubleshooting IMOLTP.

EMS SQL Manager for MySQL 5.5.1 Build 45563 Multilingual  

Posted by speedzodiac_ at April 7, 2015
EMS SQL Manager for MySQL 5.5.1 Build 45563 Multilingual

EMS SQL Manager for MySQL 5.5.1 Build 45563 Multilingual | 97 MB

EMS SQL Manager for MySQL is a high performance tool for MySQL database administration and development. It works with any MySQL versions from 4.1 to the newest one and supports all of the latest features including MySQL triggers, views, stored procedures and functions, InnoDB foreign keys, Unicode data and so on.
Beginning T-SQL 2012 (Expert's Voice in Databases) by Scott Shaw [Repost]

Beginning T-SQL 2012 (Expert's Voice in Databases) by Scott Shaw
English | July 2, 2012 | ISBN: 143023704X | 448 Pages | PDF | 15 MB

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft’s 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.