Check our collection of high-quality articles on a variety of SQL Server topics. The collection is being regularly updated with new articles.
Have you ever found yourself locked out of your Azure SQL Database because you forgot the admin password? It’s a pretty common scenario, but the good news is, it’s easy to fix. Here’s a simple, step-by-step guide to help you reset your SQL Server admin password on Azure.\ Step 1: Access the Azure Portal … Read more…
Performance tuning in SQL Server is not just a skill – it’s a critical aspect of database management that can make or break your application’s performance. As databases grow and queries become more complex, ensuring your SQL Server runs efficiently under various loads becomes increasingly important. In this article, we’ll cover some fundamental concepts and … Read more…
Hi friends. Welcome to a new article on SQLNetHub! In the technology field of database management, the emergence of NoSQL databases has prompted traditional relational models to adapt. SQL Server, a long-standing player in relational databases, has embraced this change by introducing Graph Database features. In this article, we’ll explore the interesting topic of SQL … Read more…
Hi friends, this T-SQL tips is about how you can retrieve the version name a SQL Server instance using the @@VERSION system function in SQL Server. The T-SQL Script for Retrieving the Version Name Here’s the script. As you can see, in order to retrieve the version name for the SQL Server instance we … Read more…
Hi friends, in this short article, we will be discussing about, how you can resolve the following issue that might occur under certain circumstances, when launching SQL Server Management Studio (SSMS) 19.x: Unable to load DLL ‘Microsoft.Data.SqlClient.SNI.x86.dll’ The Error Message The exact error message is the below: Cannot connect to [instance name] —————————— … Read more…
SQL Server database backup and recovery is a critical task for any database administrator. Having a reliable backup and recovery strategy in place, can help ensure that critical data is not lost and operations can resume as soon as possible in the event of a hardware failure, software issue, or other data loss event. In … Read more…
Hi friends, in this article, we’ll be discussing about certain advanced SQL Server features and techniques, that can help experienced DBAs, to tune the SQL Server data platform even more, in terms of performance, security and scalability. So, as an experienced SQL Server DBA, you are probably familiar with the fundamentals of SQL Server. There … Read more…
Hi friends, in this article, we will be discussing about the Azure Synapse Link in SQL Server 2022. Note that this topic, is also part of my course on Udemy “SQL Server 2022: What’s New – New and Enhanced Features“, so feel free to check it out on Udemy. What is Azure Synapse Analytics? … Read more…
Hi friends, in this article, we’ll be discussing about Query Store Enhancements in SQL Server 2022. Note that this lecture, is part of my online course on Udemy, titled: “SQL Server 2022: What’s New – New and Enhanced Features“. About Query Store in SQL Server Query Store, is feature that was originally shipped with … Read more…
Hi friends, in this article, we will be discussing about, how to resolve the below error, when working with CLR assemblies in SQL Server: An error occurred in the Microsoft .NET Framework while trying to load assembly id… The server may be running out of resources, or the assembly may not be trusted. Run the … Read more…
Hi friends, in this article, we will be discussing about how SQL Server evolved over the years in terms of Azure features, and why this release, makes SQL Server a hybrid data platform, with powerful capabilities, not only on premises, but also on the Azure cloud, via built-in integration mechanisms. Below, we list the major … Read more…
Hi friends, in this article, we will be discussing about the case where you might be updating or patching a SQL Server instance, and under certain circumstances you get the error message: The Database Engine system data directory in the registry is not valid. The Error Message The exact error message in the above … Read more…
Hi friends, it is with great pleasure, that we are announcing today our brand new course, titled: “SQL Server 2022: What’s New – New and Enhanced Features“. In this article, you can learn more about the course and what you can learn by attending the course. Introduction – What is this course about? SQL … Read more…
Hi friends, in this article, we will be performing a comparison of the SQL Server deployment options on the Azure cloud platform. Overview of SQL Server Deployment Option on Azure When it comes to options for deploying SQL Server databases on the Azure cloud platform, there are many options that can cover all needs. … Read more…
Hi friends, in this post, we will be discussing about the SQL Server 2022 error message: An existing History Table cannot be specified with LEDGER=ON. What are Ledger Tables in SQL Server 2022? Ledger tables are special tables originally introduced in SQL Server 2022. They constitute a major part of the security enhancements in … Read more…