Boost SQL Server Database Performance with In-Memory OLTP

In this article, we are presenting our new course titled “Boost SQL Server Database Performance with In-Memory OLTP” and explain how can the course help you, significantly improve the performance of your SQL Server-based data processes.   What is In-Memory OLTP in SQL Server? In-Memory OLTP, is SQL Server’s powerful In-Memory Optimization Engine, which is … Read more…

What are SQL Server Always On Availability Groups?

SQL Server AlwaysOn Availability Groups is a technology that was initially released by Microsoft with SQL Server 2012. The main concept, is that you have your data available in more than one sites at the same time. To this end, you have groups of databases that have primary replicas and secondary replicas. These replicas are hosted … Read more…

What are SQL Server Machine Learning Services?

In a previous article, we have discussed about what Machine Learning is and saw some of its applications. Today, we continue this series of articles, dedicated to Data Science, Machine Learning and Artificial Intelligence (AI), by discussing what SQL Server Machine Learning Services are, and how you can use them, for efficiently implementing high-quality Data … Read more…

What is Data Science?

Data Science is one of the hottest topics in Information Technology. Data Science, combined with Machine Learning and Artificial Intelligence (AI), are already heavily used by many organizations, in order to analyze large sets of structured and unstructured data, also known as Big Data, and transform this data into knowledge and useful information. All that, … Read more…

Introduction to Data Science and SQL Server Machine Learning

Hi there! We have some great news to share! We have recently released our new online course titled “Introduction to Data Science and SQL Server Machine Learning“. Data Science, Big Data, Machine Learning and Artificial Intelligence, are the areas of technology that have been significantly evolved over the last few years. These technologies, are already … Read more…

How to Find the OS Version of your SQL Server Machine – Single vs Many Machines

Finding the Windows OS version of a single SQL Server machine is easy. There many ways you can do it. However, what about when you work with hundreds of SQL Server instances? How can you efficiently generate a report with the OS versions? This article discusses some of the methods you can use to find … Read more…

How to Connect to SQL Server from Visual C++

In this article, we are going to see, step by step, how we can connect to SQL Server from a Visual C++ program using an ODBC connection. Prior to start reading, if you are really interested in learning Programming, then you should definitely check my 6-hour online course, “The Philosophy and Fundamentals of Computer Programming“. … Read more…