Loading
Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
Learn how to find foreign key relationships between SQL Server columns and search database tables for columns by name using system catalog views.
In this article, we will learn about Database Triggers in SQL Server. We also learned the concept of Magic Tables in SQL Server.
In this Article we Learn about store procedures and User Defined Function in SQL Server with Example.In previous article,we discussed about T/SQL and Cursor.
If you are using SQL DB in Azure and don’t have your critical database geo-replicated, you are opening yourself up to potential issues in the event of a disaster. By configuring geo-replication you at least give yourself the ability to make a choice. You could manually failover and keep the lights on, or do nothing and potentially close the doors for days or weeks.
Learn how to shred XML into SQL Server rows with nodes(), insert single or multiple records, and use MERGE to update existing rows or insert new ones.
In this article, we will be creating a hybrid sync group that contains both Azure SQL database & SQL Server Instance.
In this article, I will explain some of the rationale for material view usage along with a specific example that takes advantage of the SQL MERGE statement to incrementally reconcile changes to a table (a materialized view).
Split and convert a delimited string to a table with their position in SQL Server. The string contains words separated (delimited) by comma will be split into Table values.
Analyzing The Size Of Database And Size Of Table. In this article, I am going to explain two SQL queries to find the size of the database and size of a table.
This section covers most of the essential SQL Server scripts of DBA which we can use on a daily basis in the development of any BI project. CREATE DATABASE, CREATE SCHEMA, create table, ALTER DATABASE, BACKUP DATABASE, RESTORE DATABASE, RESTORE LOG
All About Primary Key And Its Basics. In this article, we will learn about general SQL queries and their functioning.
In this article, I have listed shortcuts that I usually find helpful while working with SQL Server Management Studio.
In this article, we will see how to use the Select Query Using Like Clause in SQL Server 2012. The percent sign (%), Underscore (_), Bracket ([]), Caret (^) are wildcard characters in SQL Server.
Learn how DBCC CLONEDATABASE creates schema-only SQL Server copies with statistics and Query Store data to support query performance troubleshooting.
We will see how to create an external data source in SQL Server 2016/2017 and then we will create an external table with Parquet file format. Later, we will push the data to the external table. Automatically, we get the data in our mapped Parquet file of Blob storage.
Hello Learners. Thank you so much for the support for my first article “Learn About Sql Server Architecture”. Hope you all are doing well.
This is my very first article on the understanding SQL Server Architecture. I tried to make this as simple as possible. I just want to share what I learnt. If there is any error or wrong information please leave a comment, I will be obliged to rectify me and grow with that. Happy Learning.
Troubleshoot SQL Server 2008 R2 SP3 installation failures caused by missing Windows Installer cache files, using setup logs and the FindSQLInstalls script.
The server name is important because it is the server where you’re developing the database. If you’re working locally then by default here you’ll see your server name which is installed in your machine and if you’re working on the online server. Then you just need to provide the IP address of server name and then the authentication type will be SQL Server Authentication and provide its user name and password.
This article explain about how to achieve add aggregate function in dynamic pivot in single table without create temporary tables.
In this article, we will discuss SQL Server And Relational Database.
As we all know that SQL Server analysis service (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
In this article, I will give one of the solution to overcome “The given key was not present in the dictionary” exception in MySQL.
In this article, we will learn using Window Ranking Function With UPDATE Statement.
In this article, I am going to tell about dropping of indexes in view in SQL Server.
If you are like me, you use the SSMS GUI for various things. Though I tend to use scripts for the management of most things, I do check on the database growth rates of files using the GUI interface.
I had to work with composite primary keys recently while working on a project for a client. More specifically, I had to create a process that would dynamically (dynamic SQL?! Say it isn’t so?!) handle composite keys in an efficient manner.
In this session, we will briefly discuss how to load data from one table to another table and Excel sheets at the same time using SSIS package.
Learn how SQL Server Secure Enclaves improve Always Encrypted by enabling operations such as comparisons, sorting, aggregations, and searches on protected data.
In this article, we will learn how to create CLR Triggers in C# and install & uninstall CLR assembly in MSSQL Server.
Everything on SQL Server, not only its articles: the SQL Server page →
Mahesh Chand9 videos · 23 news posts+5.3Kpoints2
Aarav Patel21 articles · 1 day visited+2.1Kpoints3
Ananya Desai21 articles · 1 reaction received+2.1Kpoints4
Riya Patel20 articles · 1 reaction received+2Kpoints5
Bhavya Singh20 articles+2KpointsFull leaderboard →
DevSocialUpcoming · 3rd editionAI Agents ConferenceNov 23–27, 2026Live onlineMembers only16days leftRegisterMembers onlyWrite an article and earn +1,000 SHARP when it is approved.
Write an article
