Tag Archives: T-SQL

Azure DocumentDB: JavaScript as Modern Day T-SQL


via Azure DocumentDB: JavaScript as Modern Day T-SQL | Microsoft Azure Blog.

Azure DocumentDB’s database engine is purposefully designed from the ground up to provide first class support for JSON and JavaScript. Our vision is for JavaScript developers to build applications without having to deal with the entity mappers, schemas, code generation tools, type adornments and other duct tapes. Our deep commitment to JSON and JavaScript inside the database engine is surfaced in the following ways:

  1. Schema Agnostic Indexing: DocumentDB does not require developers to specify schemas or secondary indexes in order to support consistent queries. The database engine is designed to automatically index every property inside every JSON document, while simultaneously ingesting a sustained volume of rapid writes. This is a crucial step to removing the friction between ever evolving modern applications and the database.
  2. SQL query dialect rooted inside the JavaScript type system: DocumentDB’s SQL query dialect is based on the JavaScript’s type system. This in-turn not only removes the type system mismatch between JavaScript applications and DocumentDB, but also enables seamless invocation of user defined functions (UDFs) written entirely in JavaScript from within a SQL query.
  3. JavaScript Language Integrated Transactions: As part of our bet on JavaScript, we allow developers to register stored procedures and triggers written in JavaScript with DocumentDB collections. These stored procedures/triggers get executed in a sandboxed manner inside the database engine within an ambient database transaction. The stored procedure (or trigger) can update multiple documents transactionally. The database transaction is committed upon successful completion of the stored procedure (or trigger); the database transaction is aborted when the JavaScript “throw” keyword is executed!
  4. JavaScript Language Integrated Queries: Today, we are pleased to announce we’re taking this vision another step further by introducing a JavaScript language integrated query API to our JavaScript server-side SDK.

Software Engineer at Bellevue, WA


Role: Software Engineer
Location: Bellevue, WA
We need only W2 candidates. We can also do H1 transfer

Note: Send me your updated resume at kdinesh@prokarma.com

Qualifications:
• Bachelor’s Degree in Computer Science or related field (or equivalent experience based on 3 years of work experience for every 1 year of education)
• Computer Science fundamentals in object-oriented design
• Computer Science fundamentals in data structures
• Computer Science fundamentals in algorithm design, problem solving, and complexity analysis
• Strong T-SQL Skills
• Proficiency in C#, JavaScript, HTML
• Proficiency in performance optimization techniques with large data set
• Experience with scoping ambiguous business requirements to a concrete set of work
• Experience building complex software systems that have been successfully delivered to customers
• Knowledge of professional software engineering practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
• Ability to take a project from scoping requirements through actual launch of the project
• Experience in communicating with users, other technical teams, and management to collect requirements, describe software product features, and technical designs

ProKarma
Dinesh Ram Kali.
Human Resource Associate| National Staffing|
Direct: +1 (402) 905 9212
222 South 15th Street, Suite 505N, Omaha, NE 68102
Follow: Dineshramitc.wordpress.com

SQL Server DBA


Role : SQL Server DBA
Duration: 2 month contract with possible extension
Location: Houston, TX

Note: Interested candidates can send me your updated resume at kdinesh@prokarma.com or you can also reach me at (402) 905 9212. Please share or like this post.

Must Have

  • SQL Server 2005/2008/2008R2
  • T-SQL, stored procedures
  • Query Performance Optimization
  • DBA
  • Database backup/recovery
  • SSRS administration
  • SSIS administration
  • Clustering, SAN, Replication
  • SSIS ETL development
  • SSRS report development
  • Communication Skills