Tip of the Week No.1 – SQL Server Always Encrypted

Check our Tip of the Week, about the SQL Server Always Encrypted feature!   Tip of the Week #1       Strengthen your SQL Server Administration Skills – Enroll to our Online Course! Check our online course on Udemy titled “Essential SQL Server Administration Tips” (special limited-time discount included in link). Via the course, … Read more…

New Blog Post Series: Tip of the Week!

Hi friends around the globe! We are pleased to announce a brand new blog post series titled “Tip of the Week“. Via this series, every Monday, we will be sharing with you, useful short tips on a variety of topics such as: SQL Server Administration and Development, Azure SQL Database, Programming, Data Access and more! … Read more…

New Free Service: SQL Server OS Requirements Info

Hi friends! Today we announce another new free online service just for you, the SQL Server Community! This new service is titled “SQL Server OS Requirements Info“, and as the name implies, by using this service, you can quickly retrieve useful information, about the OS requirements for any version and edition of SQL Server! You … Read more…

What Entity Framework Core is and How to Enable it in your C# Projects in Visual Studio

In this article, you will learn what Entity Framework Core is and how to enable it in your C# Projects in Visual Studio. Entity Framework Core, is the Cross-Platform version of ADO .NET Entity Framework. In one of my older articles, I have provided an introduction to Entity Framework. Entity Framework Core, as mentioned above, is its … Read more…

What are Local and Global Temporary Tables in SQL Server?

In this article, we will talk about temporary tables in SQL Server and more specifically, we will answer the question: What are Local and Global Temporary Tables in SQL Server?   What are Temporary Tables in SQL Server? Temporary tables in SQL Server, is a special  type of database tables which once created, exist only … Read more…

What are Relational Database Management Systems (RDBMSs) and the SQL Server Data Platform?

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…

How to Install SQL Server 2019 Express and the Latest Version of SSMS

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…

Essential SQL Server Development Tips for SQL Developers

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…

The feature you are trying to use is on a network resource that is unavailable

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…

SQL Server Installation and Setup Best Practices

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…

.NET Programming for Beginners – Windows Forms (C#)

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…

SQL Server Versions Currently Supported and their End Dates

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…