SQL Server

SQL Server

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 […]

SQL Server

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 […]

SQL Server

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 […]

SQL Server

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 […]

SQL Server

Is multitasking good or bad for productivity?

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: Is […]

SQL Server

Troubleshooting SQL Server 2016 backup/restore problems

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