In this article, in our “Beginners Corners” series of articles, you will learn what are Relational Database Management Systems (DBMSs) and the SQL Server Data Platform. What are Relational Database Management Systems (RDBMs)? Relational Database Management Systems, also abbreviated as RDBMSs, are systems which are based on the relational model of data. The approach … Read more…
In this article, we will talk about SQL Server Express Edition, its characteristics and limitations, and how you can download it and install it on a new Windows environment, along with installing the latest version of SQL Server Management Studio (SSMS). What is SQL Server Express Edition? SQL Server Express Edition, is a special, … Read more…
Hi friends. Finally, after months of hard work, I’m proudly announcing the release of my new online course, titled: “Essential SQL Server Development Tips for SQL Developers“. In this course, via a combination of lectures, downloadable resources and over than 30 live demos/hands-on guides, you will learn many useful SQL Server database programming hands-on tips, … Read more…
This post provides a fix suggestion for the error message “VS Shell Installation has Failed with Exit Code 1638“, when trying to install SQL Server 2016 features on a Windows Server. When you Might Get this Error? You might get the “VS Shell Installation has Failed with Exit Code 1638” error message when trying … Read more…
Under certain circumstances, it might happen when trying to add a feature to an existing SQL Server installation (i.e. adding SQL Server Integration Services), to get the following error message: “The feature you are trying to use is on a network resource that is unavailable“. The above error message, might be referring to Microsoft SQL … Read more…
Installing SQL Server, especially on standalone servers, is a relatively easy process. However, efficiently installing SQL Server, is a whole different story. Via this article, I will be sharing with you, some useful tips regarding SQL Server Installation and Setup Best Practices. The list of best practices presented in this article, is not exhaustive, but … Read more…
This article and video, helps you learn how you can use the ClickOnce Visual Studio component, for deploying your .NET Windows Forms apps (WinForms apps). The video presented in this article, is part of my online course “.NET Programming for Beginners: Windows Forms (C#)“. The Need for a Deployment Method for your .NET App … Read more…
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…
