SQL Server

Pro Members SQL Server Standard Members

Tips to work with SQL Server 2019 clustering

Tips to work with SQL Server 2019 clustering Consider using SQL Server 2019 Big Data Clusters. SQL Server Big Data Clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes. With Big Data Clusters you can read, write, and process big data from Transact-SQL or Spark. Set the performance boost for the foreground...

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: Overview of Distributed Database

Types of Distributed Databases Homogeneous Distributed Databases The locations use identical DBMS and operating systems in case of homogeneous distributed databases. The characteristics are as follows: The websites use very similar software. The locations use identical DBMS or DBMS from the same supplier. Each site knows all other sites and works with other sites to process user requests. The 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.
Log In Register
Pro Members SQL Server Standard Members

Avoiding the 3 massive mistakes business owners make as they scale Part Two

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 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