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…
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…
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 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…
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…
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…
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…
Hi friends. In this article, we will be discussing about what is Abstraction in Object Oriented Programming. Also, we will see a relevant video lecture. What is Abstraction? Abstraction, is a well-known technique in Object Oriented Programming and generally in Computer Science. It is a way, of handling a complex problem, by removing the … Read more…
Hi friends. In this article, we will see step by step, how to run the SQL Server BULK INSERT command from within a Python Program. This is an approach, that indeed helps importing the contents of large data files into SQL Server faster, since logging is minimal. Note that this article, is from our online … Read more…
Hi friends, in this article, we will be discussing about, what Data Compliance is, within the Data Management scope. What is Data Compliance? Data Compliance, is part of Data Management. It is the set of practices and strict controls applied within an organization in order to comply with the regulations (i.e. laws), guidelines and … Read more…
Hi friends! Today, we are happy to announce a new release of our security tool for SQL Server, that is DBA Security Advisor v2.3. What is DBA Security Advisor? DBA Security Advisor, is a security assessment tool for SQL Server. By using the tool, you can connect to one or more SQL Server instances, … Read more…
Hi friends, in this article, we will be discussing about, how you can resolve the following error you might get in your Visual Studio project: CS0234 The type or namespace name ‘Office’ does not exist in the namespace ‘Microsoft’ (are you missing an assembly reference?) Why I Received this Error Message? The reason you … Read more…
In this article, we will be discussing about the File Activation error message in SQL Server and ways to resolve it. The File Activation Error Message in SQL Server In some cases, under certain circumstances, when creating a new database in SQL Server using a T-SQL script that among other, specifies the physical location … Read more…