Pro Members

Pro Members SQL Server Standard Members

Tips for using ASP.NET with SQL Server 2019

Tips for using ASP.NET with SQL Server 2019 Use the SQL Server .NET data provider to access SQL Server 2019 data using ADO.NET. Because using the SQL Server .NET data provider provides better performance in comparison with other providers, you should use the SQL Server .NET data provider whenever possible. Try to avoid synchronous calling when developing ASP.NET applications. Synchronous…...

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.
Log In Register
Pro Members SQL Server Standard Members

Title: AI-powered Search with spaCy — Part 14

As you learned in the previous part of this series, guessing what is in a photo is perhaps one of the most interesting and yet challenging tasks of AI, which involves both Computer Vision and NLP. In this article, as well as in the previous two in this series, we concentrate on the NLP techniques that you might use to…...

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.
Log In Register
Pro Members SQL Server Standard Members

Avoiding the 3 massive mistakes business owners make as they scale

Typically, the difference between a small business and a successful and profitable company is time and experience.  But there are certain factors that play a big part in how those companies grew to be successful — things like timing, having the right people, focus, and intensely hard work. And as your business begins to grow, you may be tempted to…...

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.
Log In Register
Pro Members SQL Server Standard Members

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

Tips for using Merge Replication in SQL Server 2019 (Part 2) 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. Specify the -Validate parameter of the Merge Agent. This parameter…...

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.
Log In Register
Pro Members SQL Server Standard Members

PART I: Overview of Distributed Database

Distributed Database Collection of several interconnected databases which are physically distributed to different locations and they can communicate over a computer network is called Distributed Database. Features of Distributed Database The databases in the collection are logically linked. They often represent a single logical database. Data is physically stored in multiple locations. The data of each location can be managed…...

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.
Log In Register
Pro Members SQL Server Standard Members

What should I do if I’m realizing being a product manager is not for me?

Discovering early that you’re not doing what you enjoy (or aren’t succeeding at it) is probably a gift. Two possible situations: You know what you’d like to do (or try) next. Have a frank but humble discussion with your current manager about it. If there’s an opening in your current company for the new thing (e.g. UX or development or…...

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.
Log In Register
Pro Members SQL Server Standard Members

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

Tips for using Merge Replication in SQL Server 2019 (Part 1) Consider setting the -MaxNetworkOptimization parameter of the Snapshot Agent to 1 to avoid sending irrelevant deletes to the Subscriber. Irrelevant deletes are DELETE commands that are sent to Subscribers for rows that do not belong to the Subscriber’s partition. The default value of the -MaxNetworkOptimization is 0. Setting -MaxNetworkOptimization…...

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.
Log In Register
Pro Members SQL Server Standard Members

AI-powered Search with spaCy – Part 13

In this part, we’ll continue our discussion started in the previous part, covering how to teach your script to give a short description for a submitted photo. Some of you may argue: what does this have to do with the problem of AI-powered search claimed in the title? Well, let’s try to figure out what types of tasks might fall…...

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.
Log In Register
Pro Members SQL Server Standard Members

PART II: Database Transaction

Definition of Schedule A schedule is a process in which a single group of multiple parallel transactions is created and executed individually. You must maintain the order in which the instructions appear in each transaction. If two transactions are executed at the same time, the result of one transaction can influence the result of another transaction. Below is the example:…...

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.
Log In Register
Pro Members SQL Server Standard Members

Setting up a CMO for Success!

CMO’s have the highest turnover in the C-suite level. Why? What is the problem with CMO’s Chief Marketing Officer – CMO’s are generally responsible for planning, developing, implementing and monitoring the overall business marketing strategy. Some of the duties may include market research, pricing, product marketing, marketing communications, advertising and public relations. The CMO would play a big, important role,…...

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.
Log In Register