Standard Members Archives - Page 54 of 110

Standard Members

Concurrency Regulatory Methods Part — 4

by Sunny Singh

Concurrency Regulatory Methods Part – 4 Transaction Phases As soon as a transaction is committed, an individual cannot undo the alterations made by means of the transactions through rolling back the transaction. Sole ways to undo the updates which is or are the effects of a committed transaction is to implement a recompensing transaction. The forming of a recompensing transaction...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

How to Go from Intermediate to Expert Quickly

by Laura Lee Rose

How to go from “intermediate” to “expert” quickly Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create effective systems so that...

Already a member? Log in here

Continue Reading →

Oracle Pro Members Standard Members

JSON Support Enhancements in Oracle Database 12c Release 2 (12.2)

by Yuli Vasiliev

JSON Support Enhancements in Oracle Database 12c Release 2 (12.2) By Yuli Vasiliev New release of Oracle Database (12.2) for the first time comes with Database JSON Developer’s Guide as a standalone book within Oracle Database Online Documentation Library. In the preceding release, JSON support in Oracle Database was covered in the JSON in Oracle Database chapter within XML DB...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Some tips for using temporary tables in SQL Server 2016

by Alexander Chigrik

Some tips for using temporary tables in SQL Server 2016 Consider using system-versioned temporal tables. A system-versioned temporal table is a new type of user table in SQL Server 2016 that provides correct information about stored facts at any point in time. Each temporal table consists of two tables actually, one for the current data and one for the historical...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Useful Undocumented SQL Server 2016 Stored Procedures (Part 2)

by Alexander Chigrik

Useful Undocumented SQL Server 2016 Stored Procedures (Part 2) SQL Server 2016 supports the following useful undocumented stored procedures: sp_oledb_database sp_oledb_defdb sp_oledb_deflang sp_oledb_language sp_syscollector_validate_xml sp_xml_schema_rowset sp_xml_schema_rowset2 sp_oledb_database The sp_oledb_database stored procedure returns the oledb database name. Syntax sp_oledb_database Return Code Values None. Result Sets Column name Type Description name sysname The name of the oledb database. Remarks This stored procedure...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Some tips for using SQL Server 2016 distributed queries

by Alexander Chigrik

Some tips for using SQL Server 2016 distributed queries Try to avoid using distribution queries or minimize it using. Because distribution transactions incur more overhead than general transactions, avoid using distribution queries, whenever possible. The first steps to optimize distributed queries against a SQL Server 2016 linked server is rewriting queries so, that the most work will be performed on...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

How to Decide Upon a Refund Policy

by Laura Lee Rose

How to decide upon a refund policy Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create effective systems so that they...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Some tips for using views in SQL Server 2016

by Alexander Chigrik

Some tips for using views in SQL Server 2016 Use views to enhance security and conceal underlying data objects. For example, you can give to users the permission to access a view, which contain a restricted set of the columns and data, not allow selecting or updating the underlying data objects. By using views, the permission management could also be...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

How to Overcome Nervousness of Public Speaking of Attending Networking Events Part 2

by Laura Lee Rose

How to overcome nervousness of public speaking of attending networking events Part 2 Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

SQL Server Development and Deployment Standards

by Basit Aalishan Masood-Al-Farooq

SQL Server Development and Deployment Standards The purpose of this article is to highlight a set of standards for the development and deployment of database code. This will allow best practices to be complied with, standards to be maintained and ownership to be traced. It will also mean that developers and DBAs alike can share common practices that will assist...

Already a member? Log in here

Continue Reading →