Standard Members

Pro Members SQL Server Standard Members

Database Recovery Methods Part 7

Database Recovery Methods Part – 7 Recovery Methods Based On Instant Update In these methods, at the time when a transaction executes an update command, the database can be updated “instantly,” without any necessity to wait for the transaction to reach its commit point. In these methods, however, an update process should be logged in the log (on disk) before...

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
Pro Members SQL Server Standard Members

How to Manage Multiple Web Projects with a Deadline?

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. A busy professional has this question regarding project management: How...

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
Pro Members SQL Server Standard Members

Some useful undocumented SQL Server 2016 extended stored procedures

Some useful undocumented SQL Server 2016 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2016 extended stored procedures. xp_enum_oledb_providers This extended stored procedure can be used to get the list of all available OLE DB providers. It returns Provider Name, Parse Name and Provider Description. Syntax: EXECUTE xp_enum_oledb_providers To get a...

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
Pro Members SQL Server Standard Members

Database Recovery Methods Part 6

Database Recovery Methods Part – 6 Postponed Update with Simultaneous Execution in a Multi User Setting For multi user systems with concurrency control, the recovery procedure might be a bit more difficult, depending on the protocols castoff for concurrency control. In a lot of circumstances, the concurrency control as well as recovery processes are interconnected. In overall, the greater the...

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
Pro Members SQL Server Standard Members

What’s the Best Approach to Setting the Right Priorities?

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. A busy professional has this question regarding time management: How...

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
Oracle Pro Members Standard Members

Developing Machine Learning Apps with Oracle R Technologies

By Yuli Vasiliev Oracle R Technologies provides a comprehensive platform for data analysts and data scientists, making it easy to perform statistical data analysis and generate advanced graphics. If you are using an Oracle database to store your data and are interested in advanced analytics, then employing Oracle R Technologies should be your natural choice. The key component of Oracle...

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
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 Bulk Copy Problems

Troubleshooting SQL Server 2016 Bulk Copy Problems If you have problems with SQL Server 2016 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...

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
Pro Members SQL Server Standard Members

Database Recovery Methods Part 5

Database Recovery Methods Part – 5 Recovery Methods Based On Delayed Update The notion behind delayed update a method are to delayed or postpone any definite updates to the database until and unless the transaction finishes its implementation effectively as well as reaches its commit point. At the time of transaction implementation, the updates are logged only in the log...

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
Pro Members SQL Server Standard Members

What is the Best Way to Advertise a Forum on a Niche Topic?

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – the The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. A busy professional has this question regarding branding and marketing:...

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
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2016 triggers

Troubleshooting problems with SQL Server 2016 triggers If you have problems with SQL Server 2016 triggers, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 triggers bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this...

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