TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About Sql Server
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Vishal Pawar (16)
Satyaprakash Samantaray (4)
Suvendu Shekhar Giri (4)
Mohamed Elqassas Mvp (4)
Vignesh Mani (4)
Sateesh Arveti (3)
Saravanan V (3)
Nitesh Jha (3)
Jignesh Trivedi (3)
Madhan Raghu (2)
John Charles Olamendy (2)
Ramesh Palanivel (2)
Jasminder Singh (2)
Deepak Middha (2)
Krishna Rajput Singh (2)
Gaurav Tomar (1)
Mahesh Chand (1)
Ck Nitin (1)
Dennis Thomas (1)
Suraj Krishnan (1)
Priti Kumari (1)
Nirav Daraniya (1)
Sourav Bhattacharya (1)
Dhruvin Shah (1)
Sagar Shinde (1)
Nakul Chaudhari (1)
Bhuvanesh Mohankumar (1)
Manoj Kalla (1)
Muhammad Zunair (1)
Nithya Mathan (1)
Raj Kumar (1)
Agus Suhanto (1)
Akshay Phadke (1)
Ravi Kiran Chanduri (1)
Raviteja Swayampu (1)
Tushar Dikshit (1)
Anwar Basha (1)
Christian Del Bianco (1)
Srashti Jain (1)
Thiruppathi R (1)
Rahul Bansal (1)
Vishal Nayan (1)
Vadim Loboda (1)
Vivek Kumar (1)
Jayesh Agrawal (1)
Pankaj Sapkal (1)
Deepak Kaushik (1)
Santosh Kumar (1)
Yashwant Vishwakarma (1)
Durgaprasad Yadav (1)
Abhijit Patil (1)
Ritesh Sharma (1)
Vilas Gite (1)
abdur rehman (1)
Anbu Mani (1)
Priyaranjan K S (1)
Rohatash Kumar (1)
Nemi Chand (1)
Deepak (1)
Related resources for Sql Server
No resource found
Using Stored Procedures with ASP.NET
11/9/2023 6:53:02 PM.
This article helps you to create a stored procedure on SQL Server and tells you how to use them in your asp.net applications.
Use SQL Server 2017 in Docker Containers
11/6/2023 6:07:14 PM.
How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
Introduction To SQL Server Dynamic Data Masking
3/4/2021 11:33:45 AM.
In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.
What is new in Agular 10 release
4/20/2020 9:31:53 AM.
JS frameworks and headless CMS are a bit like cereal boxes. Eventually, you just got to pick one — the right ones, if possible.
Introduction To SQL Server Pagination
1/22/2018 12:12:44 AM.
In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.
Stored Procedures Vs User Defined Functions And Choosing Which One To Use
1/16/2018 1:46:00 AM.
In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply function
Comparison Of Subquery And Joins
1/15/2018 1:07:19 PM.
Here, in this article, we are comparing the SQL Join and SQL Subquery.
Why Dynamic Query Is Bad
1/15/2018 12:55:21 PM.
In this article, we will be talking about Dynamic Query and why it is bad.
Look At SQL Server Encryption - Part I
1/5/2018 1:08:46 AM.
In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.
FILESTREAM Feature In SQL Server
1/4/2018 12:06:55 PM.
Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
R Services In SQL Server 2017
1/2/2018 7:08:35 PM.
Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no wor
Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode
12/23/2017 12:10:26 PM.
In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
Export SQL Result To A Text File
12/18/2017 12:30:57 PM.
This article gives an overview of how to export SQL query results to a text file.
Remove Duplicate Rows In SQL Server Using CTE
12/11/2017 7:26:50 PM.
In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
Audit Made Easy Without Audit Log - Part One
12/7/2017 11:54:51 AM.
In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
How To Create A Stored Procedure In SQL Server Management Studio
11/25/2017 1:13:40 PM.
In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedu
Introduction To SSIS
11/24/2017 3:55:03 PM.
SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data
Introduction To SQL Operations Studio And Connecting It With SQL Server
11/21/2017 5:44:31 AM.
Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
Creating A SQL Database And SQL Server On The Azure Portal
11/20/2017 10:10:01 AM.
This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Three
11/16/2017 11:03:33 PM.
This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificat
Auto Complete with ngTagInput using Web API in AngularJS
11/16/2017 10:54:11 AM.
AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
SSMS 2016 - Enhanced Scrollbar
11/15/2017 5:56:25 AM.
Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
DROP IF EXISTS In SQL Server 2016
11/13/2017 3:18:31 PM.
With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the objec
Masking Sensitive Data With SQL Server 2016
11/11/2017 5:59:13 AM.
SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side sec
Introduction Of New Useful Features In SSMS 2016
11/10/2017 12:25:37 PM.
This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work
Configuring SQL Server 2016 Express On LAN For C# Connection String
11/8/2017 11:26:20 AM.
In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
ASP.NET Web API And SQL Server
11/7/2017 5:39:00 AM.
In this article, you will learn about ASP.NET Web API and SQL Server.
Step By Step Guide To Setup Sample SSAS Multi Dimension Cube
11/6/2017 11:28:31 PM.
Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed
11/6/2017 11:33:52 AM.
In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
User-Defined Types In SQL Server
10/29/2017 6:08:58 AM.
When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Two
10/14/2017 5:42:54 AM.
This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always
T-SQL - Retrieve Task Hierarchy In Project Server
10/12/2017 11:10:01 AM.
In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part One
10/6/2017 1:40:39 PM.
Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need t
How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)
10/3/2017 5:35:21 PM.
PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario
Data mining and SQL Server 2005
10/3/2017 6:24:09 AM.
Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means
Data mining and SQL Server 2005
10/3/2017 6:24:09 AM.
Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means
Concept Of Views In SQL Server
9/23/2017 12:31:13 AM.
In this article you will learn about the concept of views in SQL Server.
How To Secure PII Data In SQL Server Using .NET Assembly
9/21/2017 11:53:17 PM.
PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenari
35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews
9/19/2017 2:12:56 PM.
These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
Encrypt And Decrypt User Password In SQL Server DB Using C# Winform Application
9/18/2017 5:10:07 PM.
In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login for
Convert Rows To Columns Using Dynamic Pivot In SQL Server
9/17/2017 1:34:22 PM.
In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
Create Log Backup Maintenance Plan In SQL Server 2016
9/17/2017 1:25:00 PM.
In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
SQL Server DB Backup Using Stored Procedure In WinForm Application
9/14/2017 11:13:59 AM.
In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
How Should We Store Images And Blob Files In SQL Server
9/7/2017 4:04:38 PM.
There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects
Find Out Creation And Modification Date Of Database Objects Like Tables And Stored Procedures
9/7/2017 2:01:32 PM.
Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
How To Consume Web API Through SSIS Package
9/7/2017 1:22:01 AM.
In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and proces
New String Function In SQL Server 2017
9/6/2017 4:43:54 PM.
It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
How To Backup A Mirrored Database Using SQL Agent
9/4/2017 4:57:00 PM.
Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery mode
Working With JSON In SQL Server 2016
8/28/2017 4:35:33 PM.
JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popu
New Features In SQL Server 2017
8/28/2017 1:32:25 AM.
There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new feat
Creating Login Form For Users With Image Uploading For Password Recall
8/27/2017 10:53:05 AM.
The article is an alternate method of creating a login form where the conventional way of giving a password hint will be given as a question. In this, you can add an image which can be your hint if yo
Load Twitter Data Into SQL Database
8/15/2017 10:44:40 AM.
The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that
Record Table Changes Notification From SQL Server To WPF Client
8/9/2017 1:10:56 AM.
This article shows how to push record table changes to WPF clients using WCF Call Back Service.
Create SQL Server Database Project With Visual Studio
8/8/2017 8:24:37 PM.
In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
Learn AWS With MS-SQL(DB) Using SQL Client
8/8/2017 12:51:07 AM.
You want to login to the AWS console here. If you have no login register new users in here. After registering amazon will provide one year free access.
How To Determine The Version And Edition Of SQL Server And Its Components
8/6/2017 5:19:58 PM.
For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the cl
Find The 3rd Or Nth Highest Salary In A Table Via SubQuery
8/1/2017 2:03:54 AM.
This article describes how to find the 3rd or Nth highest salary in a table. To find the Nth highest salary, we need to create a table in the database containing some data and to do this use the follo
Creating And Managing Stored Procedure In SQL Server 2008
7/27/2017 8:02:33 AM.
In this article you will learn how to Create and Manage Stored Procedure in SQL Server 2008.
Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical Data
7/26/2017 11:09:41 AM.
How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
Creating An Azure SQL Database And Connecting Through SQL Server Management Studio
7/23/2017 11:59:20 AM.
This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
Taking Script From Database In SQL Server In Different Mode
7/17/2017 5:52:45 PM.
This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, up
Create SSRS Drilldown Report
7/17/2017 2:12:58 PM.
Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
Mirroring Database In SQL Server
7/12/2017 12:17:06 PM.
When there is any automatic failure we need another server that will monitor the principal server.
Creating And Using Azure SQL Server And Azure SQL Database
7/9/2017 1:36:31 AM.
This article helps you in creating and using SQL Server and SQL database.
Monitoring Our Database When Accessing From Outside Or Applications In SQL Server
7/8/2017 12:36:26 PM.
This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
Difference Between Stored Procedure And User Defined Function In SQL Server
7/6/2017 7:52:16 AM.
This article describes the differences between Stored Procedures and User Defined Functions in SQL Server.
Installing SQL Server vNext On Linux - Part Two
7/5/2017 12:27:10 AM.
With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Wi
Row Number Function in SQL Server
6/27/2017 7:11:59 AM.
This article explains the row number function in SQL Server. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these fu
Rank Function in SQL Server
6/27/2017 7:11:17 AM.
This article explains the Rank function. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these functions available in
Triggers in SQL Server
6/26/2017 6:51:18 AM.
This article explains triggers in SQL Server. A trigger is a special kind of Stored Procedure or stored program that is automatically fired or executed when some event (insert, delete and update) occu
Indexes in SQL Server
6/26/2017 5:01:31 AM.
This article describes indexes in SQL Server. Indexes are used in relational databases to quickly retrieve the data.
Over Clause in Sql Server (Windows on Data): Part 1
6/26/2017 1:55:15 AM.
This article explains how the Over clause works. Windowing in SQL Server is done by the over clause that was introduced in SQL Server 2005. Windowing of data in SQL Server or the window function is ap
Installation of SQL Server 2005
6/26/2017 1:38:08 AM.
Using Windows 7 Ultimate, after installation of SQL Server 2005, an error occurrs regarding Connection. (Settings for Database Engine) Login failed for user Admin\vilas. (Microsoft SQL Server, Error :
Daily Shrink Database Log Automatically Using Jobs In SQL Server
6/24/2017 11:40:26 AM.
This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script ma
View in SQL Server
6/23/2017 7:32:08 AM.
In this article, I describe Views in SQL Server. Views are database objects which are like virtual tables that have no physical storage and contains data from one table or multiple tables.
Role in SQL Server
6/23/2017 5:54:40 AM.
In this article I described Role in SQL Server. Roles are a collection of permissions or access rights for providing permissions or privileges easily in a large database system with multiple users.
SQL Executer
6/22/2017 4:30:26 AM.
Here you will see how to use SQL Executer. The article is written for beginners, the methods to communicate with database are kept simple.
Automatic Daily Database Backup To Specific Database In SQL Server
6/21/2017 6:12:46 PM.
Automatic Daily Database Backup To Specific Database In SQL Server.
Xamarin.Android - List View Using SQL Server Database
6/21/2017 6:07:59 PM.
In this article you will create a Xamarin Android List View using SQL Server.
CRUD Operation Using Stored Procedure In ASP.NET GridView Real Time
6/16/2017 4:19:40 PM.
A GridView is a graphical control element that presents a tabular view of data.
To Get All File Details From Local File Into SQL Server
6/15/2017 12:28:37 AM.
TO Get All File Details From Local File Into SQL Server.
Concept Of Change Data Capture (CDC) In SQL Server - Part Three
6/13/2017 11:36:49 AM.
Concept Of Change Data Capture (CDC) In SQL Server.
Concept Of Change Data Capture (CDC) In SQL Server - Part Two
6/12/2017 5:22:18 PM.
Concept Of Change Data Capture (CDC) In SQL Server.
Concept Of "Change Data Capture" (CDC) In SQL Server - Part One
6/9/2017 1:46:03 PM.
Concept Of Change Data Capture (CDC) In SQL Server 2008.
Top Ten Things You Should Know About Optimizing SQL Server Performance - Part Two
6/8/2017 11:26:13 AM.
Top Ten Things You Should Know About Optimizing SQL Server Performance.
Top Ten Things You Should Know About Optimizing SQL Server Performance - Part One
6/7/2017 12:10:18 PM.
Top 10 Things You Should Know About Optimizing SQL Server Performance.
Pros And Cons Of Money DataType
6/2/2017 6:14:41 PM.
Pros And Cons Of Money DataType.
ALL In One DataBase Hero Script - Set One
6/1/2017 11:07:34 AM.
ALL In One DataBase Hero Script.
Time And Date Query Code And Analysis - Part One
5/31/2017 5:37:34 PM.
Time and Date query code and analysis.
Transparent Data Encryption In SQL Server
5/31/2017 5:32:15 PM.
Transparent Data Encryption in SQL Server.
Analyzing The Size Of Database And Size Of Table
5/31/2017 4:33:55 PM.
Analyzing The Size Of Database And Size Of Table.
How To Create Login Page In ASP.NET Web Application Using C# And SQL Server
5/31/2017 12:44:02 PM.
How to create login page In ASP.NET Web Application using C# and SQL Server.
How to Create Login Form in Visual Studio and Connect With SQL Server
5/31/2017 4:18:20 AM.
This article explains how to create a login form in Visual Studio and connect with SQL Server.
Select, Insert, Update, Delete Using Stored Procedure in SQL Server 2008
5/31/2017 2:38:59 AM.
Here, we will see how to create select, insert, update, delete statements using stored procedure.
Identifying Relationship Between Columns In SQL
5/30/2017 1:27:27 PM.
Identifying relationship between columns in SQL.
How To Create A Solution And What Its Uses Are
5/25/2017 6:35:36 PM.
How to create a Solution and what its uses are.
All About Primary Key And Its Basics
5/24/2017 12:27:49 AM.
All About Primary Key And Its Basics
Google Map Using SQL Server Stored Procedure In ASP.NET MVC 5
5/23/2017 12:55:31 PM.
I will show you how to show markers on places like country, state, continent etc., using stored procedure.
Move SQL Server Database To Another Location - Lesson Learned
5/22/2017 11:31:33 AM.
Fix: Unable to open the physical file. Operating system error (Access is denied.). In this article, we'll learn the best practice of moving database to another physical location on the Server.
High Availability And Disaster Recovery In SQL Server - A Quick Note
5/20/2017 12:36:29 AM.
High Availability And Disaster Recovery - A Quick Note.