What a Modern Video Marketing Strategy Really Looks Like I recently got a review of the State of Inbound 2016 Report, and it was eye-opening. As you can see, videos ranked extremely high on the list. The conclusion is crystal-clear: consumers want to see more social media posts, news articles, and videos. In light of this insight, you may want […]
SQL Server
Some tips for using Transactional Replication in SQL Server 2016 (Part 2)
Some tips for using Transactional Replication in SQL Server 2016 (Part 2) Set the “Maximize Throughput for Network Applications” option. This can increase SQL Server performance, because Windows will allocate more RAM to SQL Server than to its file cache. Consider locating both the publisher and the distributor on the same physical server. You can place the publisher and the […]
Introduction to Structured Query Language (SQL) — Part– 1
Introduction to Structured Query Language (SQL) – Part – 1 History of Structured Query Language (SQL) This article tries to put emphasis on the Structured Query Language (SQL), from both the aspects of extensive as well as expansive ways. Expansive way, meaning that it is applied at numerous stages of database communication, starting from a simple Admission Form Combo-Box right […]
How to best deliver bad news
How to Best Deliver bad News Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create effective systems so that they can […]
Some tips for using Transactional Replication in SQL Server 2016 (Part 1)
Some tips for using Transactional Replication in SQL Server 2016 (Part 1) Try to keep transactions as short as possible. Because SQL Server send changes from the Publisher to Subscriber as INSERT, UPDATE, and DELETE statements you should keep transactions as short as possible to help the Distribution Agent to transfer transactions through the network. By the way, keeping transactions […]
Relational Data Modeling for Database Systems Part – 4
Relational Data Modeling for Database Systems Part – 4 Relational Algebra Relational algebra is a technical language containing a group of different operators. Every single operator takes one (1) or more (N) tables or relations as its input as well as yields only one (1) table or relation as its output. There are seven (7) rudimentary relational algebra operations present, […]
How to Attract More Clients to Your Business
How to attract more clients to your business Career Management Series By Laura Lee Rose Hello, this is Laura Lee Rose – author of TimePeace: Making peace with time – and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. I help busy professionals and entrepreneurs create effective systems so that […]
Some tips for using Snapshot Replication in SQL Server 2016
Some tips for using Snapshot Replication in SQL Server 2016 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. Do not configure the Distribution Agent to run continuously. […]
Relational Data Modeling for Database Systems Part – 3
Relational Data Modeling for Database Systems Part – 3 Relational Languages So far in this series of the article the database structure have been considered, along with the relations or tables as well as the associations among the tables or relations. Currently, in this part of the article we will consider the different tactical methods to use for extracting the […]
Some tips for using SQL Server 2016 file and filegroups
Some tips for using SQL Server 2016 file and filegroups Do not set the autoshrink feature. Autoshrinking results in some performance degradation, therefore you should shrink the database manually or create a scheduled task to shrink the database periodically during off-peak times, rather than set Autoshrink feature to ON. Place log files on RAID 1+0 (or RAID 1) disks. By […]