SQL Server

Pro Members SQL Server Standard Members

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

by

Tips for using Merge Replication in SQL Server 2017 (Part 2) If you do not need continuous replication, do not configure the Merge Agent to run continuously. Try to schedule the Merge Agent to run at regular intervals instead of running continuously. Try to schedule it during CPU idle time and slow production periods. By using it, you can decrease...

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 →
Amazon AWS Amazon RDS Azure Azure SQL Database Editorials SQL Server

SQL Server instance growth, management

by

I was reading an interesting article in DBTA (April/May 2018, “The Headaches of Microsoft SQL Server Sprawl“) and it was clear that so many of us are facing some pretty significant challenges when it comes to managing SQL Server instances.  Particularly true if you consider “SQL Server instances” to include your Azure instances and/or managed instances on Azure and AWS. […]

Continue Reading →
Pro Members SQL Server Standard Members

How to Stress Less During the Day

by

This question came from a busy professional. How to stress less throughout the day What are some tips for busy woman regarding how to stress less throughout the day? What are some ways in the morning, afternoon, and night that you can relax a little more — physically, mentally, emotionally? Easy ways and easy to remember! There are a few...

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

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

by

Tips for using Merge Replication in SQL Server 2017 (Part 1) Avoid using join filters with five or more tables. Because join filters with five or more tables can significantly degrade merge replication performance, you should avoid join filter for the small lookup tables, or denormalize the database design instead of using join filters with five or more tables. Use...

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

Database and File System Organization – Part 1

by

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
Continue Reading →
Administration Azure SQL Database Editorials Encryption/Data Security SQL Server

Inventory control and your databases….

by

No, not the “what servers do you have and what do they have on them” variety necessarily.  In a previous life, inventory and point of sale systems were a focus, and one of the great things that we could nearly always point to surrounded that initial inventory of the store location – their stuff on the shelves.  So many times, […]

Continue Reading →
Pro Members SQL Server Standard Members

How to Quit a Job Without Burning Bridges

by

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

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

by

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
Continue Reading →
Administration Editorials Security SQL Server

Where to Start is Often the Question – Here’s Help

by

One of the bigger challenges as you get your footing with your databases and start addressing all sorts of issues of security, compliance and such – is where to start.  How do you know what’s missing or needs attention when there are so many different areas that may indeed need attention? We’ve talked about all sorts of things, from encryption […]

Continue Reading →
Pro Members SQL Server Standard Members

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

by

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
Continue Reading →
1 … 33 34 35 36 37 … 115