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
SQL Server
FOLLOW
Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.
Articles
(1123)
Blogs
(1121)
Resources
(55)
Videos
(19)
News
(7)
Articles
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Three
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 certifi...
Saravanan V
Nov 15, 2017
SSMS 2016 - Enhanced Scrollbar
Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
Suvendu Shekhar Giri
Nov 14, 2017
DROP IF EXISTS In SQL Server 2016
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 ob...
Suvendu Shekhar Giri
Nov 13, 2017
Masking Sensitive Data With SQL Server 2016
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 ...
Suvendu Shekhar Giri
Nov 10, 2017
Introduction Of New Useful Features In SSMS 2016
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 w...
Suvendu Shekhar Giri
Nov 10, 2017
Configuring SQL Server 2016 Express On LAN For C# Connection String
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
Agus Suhanto
Nov 08, 2017
Step By Step Guide To Setup Sample SSAS Multi Dimension Cube
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.
Madhan Raghu
Nov 06, 2017
SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed
In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
Mohamed Elqassas Mvp
Nov 05, 2017
User-Defined Types In SQL Server
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.
Ravi Kiran Chanduri
Oct 13, 2017
T-SQL - Display Decimal Numbers As Money
In this article, we will show how to display decimal numbers as money with and without cents
Mohamed Elqassas Mvp
Oct 17, 2017
Sharing A Solution To Generate Billcode
Many of systems we use will generate plenty of billcodes everyday , and most of them include date(datetime) or a prefix to show their signification , such as specifying a billcode belongs to a spec...
Catcher Wong
Oct 16, 2017
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Two
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 Alwa...
Saravanan V
Oct 14, 2017
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part One
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 nee...
Saravanan V
Oct 06, 2017
How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)
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 scena...
Nitesh Jha
Oct 03, 2017
Concept Of Views In SQL Server
In this article you will learn about the concept of views in SQL Server.
Raviteja Swayampu
Jun 26, 2016
How To Secure PII Data In SQL Server Using .NET Assembly
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 scen...
Nitesh Jha
Sep 21, 2017
35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews
These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
Tushar Dikshit
Sep 19, 2017
Convert Rows To Columns Using Dynamic Pivot In SQL Server
In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
Mohamed Elqassas Mvp
Sep 17, 2017
Create Log Backup Maintenance Plan In SQL Server 2016
In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
Mohamed Elqassas Mvp
Sep 17, 2017
SQL Server DB Backup Using Stored Procedure In WinForm Application
In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
Ramesh Palanivel
Sep 14, 2017
No Records Available.
21
-
40
of
1123
<<
1
2
3
4
5
>>
Build And Architect Distributed Cloud Applications
Challenge yourself
SQL server
E-Book Download
Get Certified
Blazor