DevSocial Articles · SQL Server articles

In this article, I will introduce you to Enzo Online’s SQL Server webhook, a free service you can use to call a SQL Server database hosted in the cloud using HTTP commands so that you can easily program against a relational database using simple HTTP commands.

Herve RoggeroJan 24, 201927,9021,000

In this write-up, we will learn about subqueries in SQL Server. Subqueries are also termed as Nested queries.

Usama ShahidJan 23, 201918,1681,000

A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule for each agent job, frequently with applications like Reporting Services, users use Shared Schedules across multiple jobs. For instance, you can set a schedule to run at 8 am on week days or run every 2 hours or pick from a predefined list of schedules that already exist in the MSDB database. These are very convenient.

Monica RathbunJan 22, 201913,7641,000

Learn the core concepts of SQL Server Service Broker, including services, queues, message types, contracts, dialogs, routes, and reliable asynchronous messaging.

In this article, I will list the Pros and Cons Of Money DataType in SQL Server. Money DataType vs Decimal DataType vs Float DataType.

Vishal PawarJan 15, 201946,0861,000

TRIM() is a new function introduced in SQL Server 2017 which helps to remove the white space/characters from both sides of a string. Let us see all aspects of this function in detail.

Unnikrishnan RJan 13, 201923,7471,000

In this article, we will go through a deep understanding of SQL Joins from scratch.

Usama ShahidJan 8, 201917,3231,000

We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table. This process can generate a noticeable performance hit especially for larger tables with millions of rows. Many times, there is no way around this. To help mitigate this overhead SQL Server 2019 introduces us to approximating the distinct count with the new APPROX_COUNT_DISTINCT function.

Monica RathbunJan 5, 20198,4661,000

In order to use the grand total of matrix column group values outside of the Matrix. I am going to insert one new Tablix from toolbar then add some expression in header row to get the sum of column group values then use that values in text box to find the difference with the grand total of another table.

Madhan RaghuJan 2, 201928,2641,000

This article introduces the NoSQL concept. There are many NoSQL databases available like MongoDB, Elastic Search and Hadoop and so on.

Ratnesh SinghDec 25, 201810,8781,000

A practical guide to SQL Server development best practices covering database design, configuration, indexing, query performance, stored procedures, and source control.

Sourav MukherjeeDec 19, 201831,0391,000

Aggregate functions are the built-in functions in SQL. They are used for specific operations like to compute the Average of the numbers, Total Count of the records, Total sum of the numbers etc. These are also called Group functions because these functions apply to the group of data.

Usama ShahidDec 19, 201841,2841,000

This article explains synonyms in SQL Server. SQL Server Synonyms are created in the database that need to access the other database and use them in the SELECT statement, like we access the table in the local database.

Jasminder SinghDec 18, 201848,0421,000

In this article, I described how to calculate the maximum range of various integer data types in SQL Server. TINYINT, SMALLINT, INT and BIGINT are all number data types. The difference between these data types are in the minimum and maximum values. So let's have a look at a practical example of how to calculate the maximum range of the integer data type in SQL Server. The example is developed in SQL Server 2012 using the SQL Server Management Studio.

Rohatash KumarNov 25, 2018549,9921,000

To learn the database, most of the times, we need to build the schema and put some data inside. But to speed up the learning and make the hands dirty in code as soon as possible, large organizations provide us the pre-build database and to make some experiments on it. So here we’re using Chinook database and I’m working in SQL Server 2014.

Usama ShahidNov 21, 201811,7331,000

In my recent article Using Materialized Views Effectively, I offered a few ways to populate data stores that can be critical performance-improvers for your apps and BI environments that use SQL Server. I showed how we could incrementally improve the loading process for these specialized tables - starting from a simple TRUNCATE / INSERT, to a MERGE statement, to a MERGE filtered based on “since last load.” This article covers another method that I’ve been using in production situations, with good success.

Joel ChampagneNov 19, 20189,4241,000

When I started learning SQL, I found out several issues, which I thought to be interesting to share. For our needs, let us use AdventureWorks2012 database, which can be obtained here.

Bohdan StupakNov 12, 201812,7801,000

Here, I will tell you the possible ways to return calculated Boolean values from SQL Server code. At a lot of places, you want to progress conditionally. You send some input values to the stored procedure and want to get a Boolean value which decides the future flow of the application.

Kapil GaurNov 5, 2018158,3771,000

Did you know that compression can gain you more than just space on a disk; it can allow you to fit more data into the buffer pool? That means queries have faster and more efficient reads which can help reduce I/O.

Monica RathbunNov 2, 20187,5501,000

This article is about merging different row cells into one for the purpose of reporting. Sometimes we need to customize according to the client’s requirements.

Rohit KainthOct 24, 20189,5521,000

I hope you all are doing fine. This particular article is about updating the dynamic columns on the go.

Rohit KainthOct 24, 201852,9321,000

In this article, we will learn about identity function and how we Reset Identity Column in SQL Server. Identity keyword is used in SQL Server to Auto Increment Column value.

Sanwar RanwaOct 22, 201829,8361,000

In my series of articles there are a few scenarios where we need to take care of some real-world samples and examples to help explain concepts to the end users. This is part 49 of the series of articles on SSIS.

Karthikeyan AnbarasanOct 17, 2018163,4611,000

In this article, we will learn how to create and use user-defined functions in SQL server. The function we write for reusability purpose to avoid complexity and duplication of code. User-defined functions are precompiled and ready for later use. Using SQL server, you can easily create, view, and modify the user-defined functions.

Jitendra WaghaleOct 15, 201824,1631,000

Backup and Restore are common functions of a database administrator. In this tutorial, you learn how to create a SQL Server database backup and restore it back using SQL Server tools.

Jitendra WaghaleOct 15, 201812,3241,000

In this article, I am going to explain about best practices and programming guidelines in SQL Server, for all SQL programmers.

Bikesh SrivastavaOct 11, 201861,8131,000

I am writing this article to share knowledge about Windows Functions or Windows Ranking Function(It is a sub part of the Windows Functions). There are many windows functions introduced in SQL Server such as Rank, Row_Number, Dense_Rank, Lead, Lag, First, Last, Ntile etc. which can be used to work upon a row data set, row data set means grouping of rows according to certain conditions, that is known as a Row Data Set or if we talk about in context to this article, simply called as Window.

Rohit KainthOct 10, 201811,3971,000

In this article we learned about exception handling in SQL Server, This article is the last article of T/SQL Series. Now, We will start learning MongoDB. I have to prepare some article on MongoDB soon to post the complete series on NoSQL Database.

Sanwar RanwaSep 28, 201811,9611,000

Installing SQL Server vNext On Linux. install SQL Server vNext on Ubuntu, install SQL Server on Linux. install SQL Server vNext on Linux. install SQL Server vNext.

Yashwant VishwakarmaSep 21, 20189,5451,000