DevSocial Articles · SQL Server articles

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 SuhantoNov 8, 201750,4621,000

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 ChanduriOct 29, 2017126,5541,000

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 special day or a special type .

Catcher WongOct 16, 20177,6131,000

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 Encrypted feature. In case, if you have missed out the first part of the series.

Saravanan VOct 14, 201720,8381,000

Learn how to configure Always Encrypted in SQL Server 2016 using SSMS, including column master keys, column encryption keys, and deterministic column encryption.

Saravanan VOct 6, 201766,5211,000

In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.

Mohamed ElqassasSep 17, 201778,9301,000

In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016

Mohamed ElqassasSep 17, 201719,8151,000

In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.

Ramesh PalanivelSep 14, 201728,9991,000

Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.

Satyaprakash SamantaraySep 7, 201726,7491,000

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.

Jignesh TrivediSep 6, 201728,7391,000

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 model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.

Vishal PawarSep 4, 201728,1361,000

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 features in SQL server 2017.

Jignesh TrivediAug 28, 201733,5181,000

This article illustrates the purpose of SSIS with Web Service.

Nitesh JhaAug 19, 201773,7201,000

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 into SQL Server 2016 Database.

Madhan RaghuAug 15, 201716,8051,000

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.

Srashti JainAug 8, 2017359,6551,000

Learn several ways to identify SQL Server versions, editions, product levels, installed instances, and client tools using SSMS, error logs, T-SQL, and Discovery Report.

Vishal PawarAug 6, 201728,7381,000

This is an open source project I named online shopping site.This is an online shopping cart application written in ASP.NET (4.0) and C# where a user can browse, add items to the shopping cart and place orders.

Prakash kumar JhaAug 2, 2017733,5931,000

Learn how to find the 3rd or Nth highest distinct salary in a SQL Server table using a TOP query, ORDER BY, DISTINCT, and a subquery.

Rahul BansalAug 1, 2017546,1031,000

Incorrect cardinality and Cost Estimation may lead query optimizer to choose inefficient plans which can have a negative impact on the database performance. In this article we are going to look deep inside Statistics.

Vikrant MoreJul 30, 20178,0251,000

How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.

Vadim LobodaJul 26, 201735,3951,000

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, update or delete then create our database based on our database modification.

Vignesh ManiJul 17, 201723,0621,000

Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.

Jayesh AgrawalJul 17, 201748,0851,000

When there is any automatic failure we need another server that will monitor the principal server.

Pankaj SapkalJul 12, 201714,0711,000

This article helps you in creating and using SQL Server and SQL database.

Deepak KaushikJul 8, 201717,3971,000

This article explains how to monitor our database when accessing from outside or any other applications in an easy way.

Vignesh ManiJul 8, 201711,2721,000

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 Windows but it is on Linux also and people who love Linux can check the flavor of SQL Server in the Linux environment.

Yashwant VishwakarmaJul 5, 20179,0121,000

This article explains Wild Card Operators in SQL. Wildcard characters can be used in LIKE expressions; the percent sign (%) matches zero or more characters and underscore (_) a single character.

Saillesh PawarJun 28, 201718,0161,000

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 SQL Server that allows us to assign rankings or numbering to the rows of the result set data.

Jasminder SinghJun 27, 201715,2021,000

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 manually.

Vignesh ManiJun 24, 2017124,0741,000