Monthly Archives: November 2010

How to use Managed Code (CLR) in SQL Server? Video

SQL CLR Integration allows you to create database objects that enhance your ability to provide custom functionality and package them into .NET assemblies. The .NET CLR offers: Access to existing managed code. Security features to ensure managed code will not compromise the server. The ability to create new resources using .NET languages like Microsoft Visual [...]

V28 – Oracle SQL Tutorial – Querying data – Part 10(b) – Single-Row Character Functions

V28 – Oracle SQL Tutorial – Querying data – Part 10(b) – Single-Row Character Functions

SQL Developer tutorials demonstrating single row character functions in oracle, presented by Oraclecoach.com This is a 2 part tutorial – 10(a) and 10(b)
From:
or…

V27 – Oracle SQL Tutorial – Querying Data – Part 10(a) – Single-Row Character Functions

V27 – Oracle SQL Tutorial – Querying Data – Part 10(a) – Single-Row Character Functions

SQL Tutorial demonstrating Single Row Character Functions using SQL Developer, presented by www.oraclecoach.com Note: This video is split as Part 10(a) and 10(b)…

SQL Server 2011 (Denali) Certification

Microsoft have announced that the next version of SQL Server Certifications. Following are the new exam codes for SQL server 11, for which Microsoft has called SME. 70-460   PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 11 70-461   PRO: Designing Database Solutions and Data Access Using Microsoft® SQL Server® 11 [...]

V26 – Oracle SQL Tutorial – Querying Data – Part 9 – Intro to Single-Row Functions

V26 – Oracle SQL Tutorial – Querying Data – Part 9 – Intro to Single-Row Functions

SQL Developer Tutorial introducing single-row functions, the DUAL table, Snippets in SQL Developer, presented by www.oraclecoach.com
From:
oraclecoach
Views:
1327

How to turn off Auto Recovery (AUTO Save) in SQL Server Management Studio?

What is Auto Recovery (AUTO SAVE) feature in SQL Server Management Studio ? AUTO Recovery is a feature in SQL Server management studio that automatically saves open sql scripts, after a user definable period of time. By default this setting is set for 5 minutes. What Could be the issue, if this feature in remain [...]

V25 – Oracle SQL Tutorial – Querying data – Part 8 – WHERE clause continued

V25 – Oracle SQL Tutorial – Querying data – Part 8 – WHERE clause continued

SQL Developer tutorial demonstrating the use of the LIKE operator and IN operator to restrict data in a WHERE clause, presented by www.oraclecoach.com
From:
oraclecoach
View…