Advanced SQL Server Features and Techniques for Experienced DBAs

by

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…

Python Data Access Fundamentals

by

Hi friends, in an older article, we have talked about how you can connect to SQL Server databases from a Python program. In this article, we will be discussing about the Python Data Access fundamentals, that is how you can connect to different databases from within your Python code. In general, Python provides the capability … Read more…

System.IO.FileLoadException: could not load file or assembly…

by

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…

SQL Server 2022 Generally Available!

by

Yesterday, November 16 2022, Microsoft announced the general availability of SQL Server 2022. The long-awaited new release of SQL Server, includes many features in all aspects of the popular data platform, but also an additional set of features, that make SQL Server the most Azure-enabled release of SQL Server yet. Let’s discuss about the highlights … Read more…

The Database Engine system data directory in the registry is not valid

by

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…

SQL Server 2022: What’s New – New and Enhanced Features (Course Preview)

by

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…

Comparison of SQL Server Deployment Options on the Azure Cloud Platform

by

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…

An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint (9642) – How to Resolve

by

Hi friends, in this article, we will be discussing about how to troubleshoot the following error message: “Event ID: 9642. An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint.“.   About the Service Broker/Database Mirroring transport connection endpoint error We can see from the error message, that it refers to a … Read more…

Data Security vs. Data Privacy

by

In this post, we will be comparing Data Security vs. Data Privacy and try to identify their main difference. So in order to efficiently perform this comparison, we need to define what data security is as well, as what data privacy is. What is Data Security? As covered in a previous article, defines the processes, … Read more…

Differences Between Batch and Streaming Data

by

In this article, we will be discussing about the batch and streaming data, what they are and which are their main differences.   What is Batch Data and Batch Processing? Batch data, is a term used to characterize large data sets with millions of records stored in files, records, etc. Batch data is processed by … Read more…

An existing History Table cannot be specified with LEDGER=ON – How to Resolve

by

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…