sp_depends have been one of the most used system stored procedures in SQL Server. In fact, many of us still use that even though Microsoft had annouced that it will be removed from the future releases.
Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it
Recently, we upgraded one of our Production Systems from SQL 2012 Enterprise to SQL 2017 Enterprise with CU8. The Upgrade process went smoothly without any issues. During the testing process, one such SQL Statement which was fetching the Data from Oracle Linked Server and inserting the same into a table hosted on SQL failed with the below error message:
SQL Server Database Engine is a general-purpose multi-model Database Engine that enables you to combine the classic relational concepts with NoSQL concepts such as JSON documents. In this article, you will see some use cases how to combine JSON with relational data and when to use it.
If you move in the Past, you’ll get to know that in the early 1980s. You’ll see the applications running on PCs that access the local data files. This creates a problem because multiple users won’t able to share the data. As things evolved, databases installed to be on Servers this enable the multiple users to share the data on the network. And we need something to manage the data this was the relational database system come into play. They do so with the Structure Query Language (SQL). In this simple text, they get passed to the server from the client application. The DBMS on turns take care of all the file known necessary to perform the operation the users requested which could be inserted, update, delete, retrieve, read, modify data etc.
The MySQL and MS SQL are the two of the most widely used database systems in the world. The first thing that you will note about these two database systems is how they are availed to users. MySQL is open source software. This means that the use of MySQL comes from the pooled knowledge of different people from different corners of the world. This can be arguably be the biggest plus for MySQL as users through the open source platform can continually improve the general program. MS SQL on the other hand uses a closed source development approach. By this, the development of the program is done in-house and all that the consumers get is a program that they are supposed to use.
As a software engineer, I was always interested in how a computer can be taught to behave intelligently, at least on some simple tasks that we can easily solve within frames of seconds. One of them applies to audio recognition, which in recent years has been analyzed thoroughly. For this reason, in this article, you will be introduced to one of the complex tasks which arose in the field of computer science: the efficient comparison and recognition of analog signals in digital format. As an example, consider an audio signal Ψ1, which you would like to compare to another Ψ2 in order to see if they both are coming from the same song or audio object. Any person could cope with this assignment with no problem at all, but computers unfortunately are not that intuitively “smart”. The difficulty lies in the fact that each of the signals might have distinct digitized formats, thus making their binary signatures totally opposite (resulting in an obsolete byte-by-byte comparison). The dissimilarity may also result because of the combination of variant internal characteristics of the same audio format (bit rate, sampling rate, number of channels (mono, stereo, etc.)). Even if you proceed with the conversion of the files to some predefined specifications (e.g., 44100 Hz, stereo, WAVE PCM format), you still might bump into the problem of having different binary representations because of the possible time misalignment, noise, distortion, or “loudness levels” for the same song (“loudness” technically defined as amplitude level).
In this article, we are going to learn how to log each request and response of an API such that it helps to maintain logs, next we are going to handle all API exception such that if an error occurs, we can store errors and fix it as soon as possible, and last part is versioning of the API.
DevOps is a combination of software development and operation (Dev & Ops) which strongly advocate automation at all steps in software development process. This will enable faster delivery, more stable operating environment with minimum human errors, less maintain cost and many more advantages for software development team.
A quick guide to managing 100000'ish records efficiently with SQLite and C#/.Net.
Most of us think when we make some changes and rollback the transaction everything is rolled back, but here is the catch- transaction do not roll back the auto increment field.
In this article, let’s see how to create our own ASP.NET Core Blazor Master Detail HTML Grid with Sorting and Filtering using Entity Framework, and Web API. We also use the Dynamic Content features of Blazor to create our Master Detail Grid.
How to generate a pie chart with Grafana and MS SQL
SqlBinder is a free, open-source library that helps you transform a given SQL template and a set of conditions into any number of valid SQL statements along with their associated parameters.
This article will explain in detail about, how to create an ASP.NET Core Blazor Filter and Sorting for HTML Table using Entity Framework and Web API.
In this post, we are going to explore how a Single Page Application (SPA) sample can be put together using ASP.Net Core & Angular from scratch.
In this article we will see on how to create a simple CRUD application for ASP.NET Core Blazor using Entity Framework and Web API
Installing Magento 2 On Localhost Using Xampp
How to extend the Entity Framework with bulk insert functionality, using DbContext
A Dockerized proof of concept application using React, Node, Python, GnuCOBOL, PostgreSQL, and Docker.
Using Powershell and Windows Task Scheduler API to detect malicious login attempts on a remotely accessible SQL Server database
Building an actual warehouse is hard. This article covers the techniques that you can use to design and implement data warehouses that fit into modern cloud infrastructures.
This custom database first approach token authentication will enable you to apply token-based authentication in your application in a simple way with no hassle.
I walk you through how to make use Table-valued parameters with one value
New feature in SQL Server 2016
Through this article, we are going to discuss three important interview questions of SQL
A flexible way to generate unique numbers for things like invoice numbers
AngularJS and REST API Tutorial – Part 2
Often a service is required to connect to a database to perform some operations. In this post, we are going to look at having an Azure Function connect and insert a record in database table. We will showcase the usage on nuget packages and usage in Azure Function to automate package management.