Standard Members

Pro Members SQL Server Standard Members

Database and File System Organization – Part 1

A file system is a deliberation to store, recover and refresh FILENAMES DIRECTORIES METADATA Advantages and Disadvantages of Conventional File System Easy to plan due to their single – application. · Disadvantages · Harder to adjust to new prerequisites. · DATABASE MANAGEMENT SYSTEM (DBMS) FUNCTIONS Data Dictionary Management. Data Storage Management In the upcoming part we will be discussing about...

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 Quit a Job Without Burning Bridges

Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – 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. This question came from a busy professional. How do you quit...

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

Tips for using Transactional Replication in SQL Server 2017 (Part 2)

Tips for using Transactional Replication in SQL Server 2017 (Part 2) Consider using transactional replication to memory-optimized tables. In SQL Server 2017, tables acting as transactional replication subscribers, excluding peer-to-peer transactional replication, can be configured as memory-optimized tables. To configure the subscriber database for supporting replication to memory-optimized tables, you should set the @memory_optimized property to true by using sp_addsubscription...

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

A Holistic View of Database Management System (DBMS) – Part 20

Storage Organization Already we have portrayed the storage framework. In a short, the storage structure can be partitioned into two classifications: Volatile storage: As the name recommends, a volatile storage can’t survive system crashes. Volatile storage devices are set near the Central Processing Units (CPU); ordinarily, they are implanted into the chipset itself. For an instance, primary memory, as well...

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 Communicate that You Are Not Looking for Further Advancement (Right Now)

This question came from a busy professional working from home. Looking to speak with a career counselor about how to communicate with your boss when you are content with your career or not looking for advancement at this particular time. This is a tricky one because you don’t want to give the impression that you never want to improve yourself,...

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

Tips for using Transactional Replication in SQL Server 2017 (Part 1)

Tips for using Transactional Replication in SQL Server 2017 (Part 1) Avoid publishing unnecessary data. Try to restrict the amount of published data. This can results in good performance benefits, because SQL Server will publish only the amount of data required. This can reduce network traffic and boost the overall replication performance. Increase the -MaxBcpThreads parameter of the Distribution Agent....

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

A Holistic View of Database Management System (DBMS) – Part 19

Loss of Volatile Storage An unpredictable storage like RAM stores all the dynamic logs, disk buffers, and related information. Moreover, it stores every one of the transactions that are as a rule at present executed. What happens if such an unstable storage crash unexpectedly? It would clearly take away every single log and dynamic duplicates of the database. It makes...

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

Time Management Tip for People Who Work-From-Home

This question came from a busy professional working from home. I need a Time Management Tip for people who Work-From-Home What are some of your secrets to successful time management when working from home? I know the usual suspects: Create a dedicated workspace, get dressed for work, etc., but what are your most interesting and creative ways to manage your...

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

Tips for using Snapshot Replication in SQL Server 2017

Tips for using Snapshot Replication in SQL Server 2017 Run the Snapshot Agent as infrequently as possible. The Snapshot Agent bulk copies data from the Publisher to the Distributor, which results in some performance degradation. So, try to schedule it during CPU idle time and slow production periods. Consider specifying a simple or bulk-logged recovery model for the subscription database....

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

A Holistic View of Database Management System (DBMS) – Part 18

DEADLOCK Procedure In a multi-process framework, deadlock is an undesirable circumstance that emerges in a shared asset condition, where a procedure uncertainly prolonged for an asset that is held by another procedure. For instance, consider an arrangement of transactions {T0, T1, T2, …, Tn}. T0 needs an asset X to finish its task. Asset X is held by T1, and...

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