Hi there! We are happy to announce our brand new course titled: “.NET Programming for Beginners – Windows Forms (C#)“. We are really excited about this course, since via the course, we share our passion, expertise, as well as tips and tricks, about Windows Forms (WinForms) programming in .NET, using Visual Studio and C#. But … Read more…
A few days ago, a friend asked me where are SQL Server statistics stored. Are they stored in one of SQL Server’s system databases or are they stored in each database individually? In this short tip, we will take a look into this and answer the question, but first, let’s talk about SQL Server statistics. … Read more…
When working with SQL Server, not only as Database Administrator but also as Developer, you need to know the SQL Server versions currently supported by Microsoft, as well as their extended support end dates, in order to plan ahead. And planning ahead does not only mean planning possible SQL Server instance migrations, but also, plan … Read more…
A common question I usually get from fellow SQL Server community members, is how to update SQL Server Reporting Services (SSRS) 2017? This is a good question, because since SQL Server 2017 and later, SSRS is no longer part of the SQL Server installation media. To this end, SSRS 2017 and later can be found … Read more…
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…
In this short article, we will talk about how to resolve an error message you might get when running queries in SQL Server Management Studio (SSMS), and that is the error message: “There is not enough space on the disk. (mscorlib)“. Since the above error message just gives an indication on what the issue is, … Read more…
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…
In a previous article, we talked about what Search Engine Optimization (SEO) is. In this article, we continue this discussion by talking about 10 simple but effective SEO techniques you can perform, in order to make your website more visible to search engines, rank higher and thus drive more organic traffic to your website. … Read more…
What is Search Engine Optimization (SEO)? One thing is for sure, and that is SEO is a very hot topic nowadays! SEO stands for Search Engine Optimization. It is the process of optimizing your website in such a way, in order to make it as visible as possible to search engines without having to pay … Read more…
Hi there! We are happy to announce the creation of another new blog category on our website. The name of the new category is “Tech Talk“. Under this category, we will be discussing different topics of general technology interest such as: SEO Windows-related topics Internet of Things (IoT) …and much more! Don’t worry, our main … Read more…
Hi friends, We are excited to let you know that a few days ago, we released the new versions of DBA Security Advisor and In-Memory OLTP Simulator. Besides some performance improvements, the major new enhancement in both tools, is that we have added support for SQL Server 2019. Feel free to download the free trial … Read more…
As we progress as a society, it is inevitable to use Technology even more, in different aspects of our lives. Healthcare, Education and work are just some of them. This is the well know process of “Digitalization”. Digitalization: An Ongoing Process Digitalization, is a huge and ongoing process, with many aspects. Besides all the … Read more…
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 Machine Learning? Why nowadays everyone talks about it? Can it help mankind solve complex problems? All the above, are some questions that come to our minds when we hear the term “Machine Learning”. In one of previous articles, I explained what Data Science is. In this article, we will talk about Machine Learning, … Read more…
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…
