SQL Server

Pro Members SQL Server Standard Members

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

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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Administration Azure SQL Database Editorials Encryption/Data Security SQL Server

Inventory control and your databases….

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

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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Where to Start is Often the Question – Here’s Help
Administration Editorials Security SQL Server

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

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

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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
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 - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register