Loading
You are here: Home / Archives for sql

SQL PASS Summit 2011 – Enterprise Database Administration and Deployment[

May 4, 2012 By Leave a Comment


– and Deployment
English | WMV3 | 640×480 | 15fps 241kbps | WMA 32kbps | 7.14GB
Genre: Video Training

As a DBA it can be a challenge to know who has permissions to what SQL instances and what objects. The more instances you have the more complex that task. In this presentation I’ll share a method using PowerShell and TSQL that can be used to capture permissions from all of your SQL instances and load them into a centralized location. We’ll even take it a step further by auditing those permissions so that we can quickly and easily identify any that might have changed. [Read more...]

Filed Under: Video Training Tagged With: , , , ,

OReilly SQL in a Nutshell 3rd (2009) [PDF]

April 9, 2012 By Leave a Comment

in a 3rd (2009) []
Publisher: O’Reilly Media; Third Edition (December 2, 2008)
Language: English
ISBN-10: 0596518846
ISBN-13: 978-0596518844

For programmers, analysts, and administrators, SQL in a Nutshell is the essential reference for the SQL language used in today’s most popular products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in SQL 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source products. You’ll also get a concise overview of the Relational Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts — all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

[Read more...]

Incoming search terms:

Filed Under: IT Books Tagged With: , , ,

CBT Nuggets: Microsoft SQL Server 2008 70-450

March 29, 2012 By Leave a Comment

CBT Nuggets: Microsoft SQL Server 2008 70-450 (New Links)

: 2008 -450
English | Audio: 44100Hz mono 48Kbps | Video: 7 800×600 15.00fps 82Kbps | 640 MB
Genre: Video Training

e you a administrator who wants to add design and development skills to your toolkit? Then this CBT Nuggets SQL Server 2008 Exam-Pack 70-450 Training pack is for you. SQL Server 2008 brings you lots of terrific features. Shared server-wide management capability allows you to automate processes, schedule tasks and set alerts. Plus you CAN edit and insert code and run Reports. Trainer Don Jones Begins HIS video series with the Basics: SQL Terminology, How relational Databases work, How They Store and retrieve data and the Fundamentals of the T-SQL language. Then he teaches you how to install, migrate, upgrade and consolidate your data from previous SQL versions to 2008 SQL Server. Plus, he shows you how some of the “handy” tips and tricks you may have used in earlier versions of SQL can trip you up in SQL Server 2008.

[Read more...]

Incoming search terms:

Filed Under: Tutorials, Video Training Tagged With: , , , , , , ,

[Pluralsight] SQL Server Performance Indexing Basics

March 8, 2012 By Leave a Comment

[- training] : Basics (2012) | 234 MB
Genre: Video Training

Indexes are the most crucial objects of the . They are the first stop for any DBA and developer when it comes to performance tuning. To master the art of performance tuning one has to understand the fundamentals of the indexes how to best apply them. This course is for every DBA and developer who deals with performance tuning and wants to use indexes to improve the performance of server.

[Read more...]

Incoming search terms:

Filed Under: Video Training Tagged With: , , , ,

SQL in a Nutshell, 3rd Edition

February 26, 2012 By Leave a Comment

SQL in a Nutshell, 3rd Edition

Book Description

Publication Date: December 2, 2008 | ISBN-10: 0596518846 | ISBN-13: 978-0596518844 | Edition: Third Edition

For programmers, analysts, and administrators, in a is the essential reference for the SQL language used in today’s most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in SQL 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You’ll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts — all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

  • Background on the Relational Database Model, including current and previous SQL standards
  • Fundamental concepts necessary for understanding relational databases and SQL commands
  • An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
  • The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
  • An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
  • Platform-specific functions unique to each implementation [Read more...]

Incoming search terms:

Filed Under: Database Tagged With: ,
« Older Posts