Microsoft Technology Licensing, LLC

Christian Kleinerman

Shrinivas Ashwin

Ganapathy Subramaniam Krishnamoorthy

Goetz Graefe

Mark H Lucovsky

Shaun Douglas Pierce

Joel Mathew Soderberg

Alazel Acheson

Jose A Blakeley

Peter Alan Carlin

Arthur Zwiegincew

Eugene N Nonko

Stefano Stefani

Florian Michael Waas

Cesar Alejandro Galindo-Legaria

Ajay Kalhan

Michael Ray Clark

Pablo Castro

Aleksandras Surna

Jun Fang

Erik Ismert

Stephen Frederick Starck

Eugene Zabokritski

Girkumar Nair

Amrish Kumar

Giri Nair

Honggang Zhang

Systems and methodologies are provided as part of a computing environment that implements an enhanced tabular data stream (TDS) protocol. Such enhanced TDS protocol can mitigate synchronization inconsistencies between client and servers, improve robustness of the data transfer, facilitate password specification as part of login procedures, and reduce administration overhead. Various headers are provided as part of the data stream protocol, and a versioning scheme is established that facilitates proper communication between servers and clients having different release dates and versions of the TDS protocol.

Enhanced tabular data stream protocol

Various embodiments of the present invention enable functions, procedures, and triggers to be written in any of the .NET languages and executed by the RDBMS. User code can access data from the local or other SQL servers using the SQL Programming Model and both the SqlServer or SqlClient implementations respectively. Moreover, to improve upon the previous extensibility mechanism, a set of APIs (commonly known as 'the in-process provider' or 'inproc provider') is utilized to provide efficient and easy to use data access while running inproc, a data access API that is an implementation of the ADO.net programming model.

Systems and methods for a database engine in-process data provider

The Best Practices Analyzer scans one or more instances of the database server for conformance to a set of guidelines and recommendations ('best practices' or 'best practice rules'). Best practice rules may be defined by the user and/or may be provided. The Best Practices Analyzer performs analysis of usage of database programming (query) language and conformance to guidelines. Best Practices Analyzer may check for correct execution of common administrative tasks. Rules may be implemented as procedural code in any language.

Best practices analyzer

Various mechanisms are presented that allow for the coordination of transactions in a managed runtime environment. In one aspect, a runtime environment that is hosted in a database system, includes an application programming interface (API). The API can surface the database transactions as ambient transactions, and present them to some user code. When the user code connects to some remote resource, the ambient transaction can be implicitly propagated to the remoter resource, resulting in coordination of the database transaction with any given transaction running in the remote resource.

Framework for database transactions

A number of members of a user defined type may be designated as delayable members. During an initial fetch of the type, the type may be returned from the database without the delayable members, thereby preserving valuable bandwidth and reducing the amount of time required to perform the initial fetch. Upon request, selected delayable members may be re-fetched from the database at a later time without returning the other members provided during the initial fetch.

System and method for delayed fetching of designated members of a user defined type

Various embodiments of the present invention are direct to the utilization of Blob Handles (BHs) which are an internal representation of a large value. BHs are immutable and stateless references to a large data object. The structure of a BH contains enough information to return an ILockBytes interface in order to provide access to the corresponding large data block, and a BH can also return information regarding its own lifetime description. A BH can be completely described using (a) a pointer to the beginning of BH data and (b) the byte-length of the BH.

Systems and methods for a large object infrastructure in a database system

Methods, systems, and computer program products for accessing data where the data store provider is abstracted from both the data manipulation language used to access the data and the schema that describes the data. A received request structured in accordance with the data manipulation language is represented in an intermediate form. From the intermediate representation, a native request for any of one or more data store providers may be produced. Before being returned to the requestor, a native response from data store provider may be formatted so that it is structured in accordance with the data manipulation language used for the request. A given request received by one computer system may cause a procedure to be generated for accessing the data store provider. When a later request is received by second computer system, the previously generated stored procedure may be reused if applicable.

Manipulating schematized data in a database

A client submits a subscription to a database specifying selected data within a data set. A subscription plan is generated based on the subscription. A query is submitted to the database changing selected data within the data set. A query plan is generated based on the query. The subscription is matched to the query based on the data set, and the query plan is supplemented with the subscription plan to generate a notification of the change to the client.

System and method for database change notification

Methods, systems, and computer program products for accessing data where the data store provider is abstracted from both the data manipulation language used to access the data and the schema that describes the data. A received request structured in accordance with the data manipulation language is represented in an intermediate form. From the intermediate representation, a native request for any of one or more data store providers may be produced. Before being returned to the requester, a native response from data store provider may be formatted so that it is structured in accordance with the data manipulation language used for the request. A given request received by one computer system may cause a procedure to be generated for accessing the data store provider. When a later request is received by second computer system, the previously generated stored procedure may be reused if applicable.

Growing community of inventors

Bellevue, WA, United States of America

Christian Kleinerman