DevSocial Articles · SQL Server articles

Learn to create C# CLR stored procedures with and without namespaces, deploy and remove SQL Server assemblies, and enable CLR integration.

Dinesh KushwahaMay 13, 201845,3301,000

In any application persistence of data is required. Database plays a very important role to fill this gap. Microsoft SQL server is one such database. We all know database contains multiple tables to manage the data for us. However apart from Tables many more entities exist in these databases.

Hemant MahajanMay 8, 201811,4621,000

Let’s discuss how to connect the database to SSIS package and how to load the table record(s) from database to notepad file. We can pull it into notepad, excel, csv or any other extension that you want to store.

Sankara Krishnan VenugopalMay 8, 201861,6361,000

In this article we will learn how to display records in custom given order except ascending & descending in MSSQL Server.

Dinesh KushwahaMay 4, 201822,9711,000

In SQL Server, the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The optimizer uses this cardinality data, which relies heavy on statistics to get the answers and calculate a cost estimate. It takes the #of Rows to Satisfy a Predicate/Total # of Input Rows.

Monica RathbunMay 3, 201811,1441,000

When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you already had stay at their pre-upgrade compatibility level, which means they run under the older set of optimizer rules.

Monica RathbunApr 24, 201820,3111,000

In this article, you will learn how to remove duplicate rows in SQL Server using CTE.

Nakul ChaudhariApr 15, 201826,6701,000

Learn how SQL Server system-versioned temporal tables retain row history for auditing and point-in-time analysis, including table creation and FOR SYSTEM_TIME queries.

Monica RathbunMar 29, 201813,9021,000

This article helps you to understand how to use the SQL Profiler, and how to trace a particular table.

I ran across a client the other day that had these Backup and Recovery options set like the picture below because it defaults this way.

Monica RathbunMar 23, 20188,7481,000

We have already discussed many ways to import data in Azure DWH. Today I will discuss an OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the most promising way to import data from different data sets/ types like SQL Server, Oracle, MySQL, Flat File, CSV, DB2 .

Deepak KaushikMar 21, 201811,8051,000

In this article, we will learn Pre-Deployment And Post-Deployment Script on SQL Database Project.

Srashti JainMar 20, 201863,8661,000

Learn how to use the SSMS Output window to view queries run by Object Explorer, troubleshoot delays, and inspect SSMS telemetry settings.

John MorehouseMar 17, 201813,6721,000

Learn four checks to make before running SQL Server queries in production: the right server, database, query, and recovery plan.

John MorehouseMar 13, 20188,1921,000

Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly. The solution was related to an aspect of table partitioning that I was not aware of. If you aren’t familiar with partitions in SQL Server, you can “divide” up a table into different segments or partitions. Often this is found in large tables (think millions/billions of rows) in order to quickly and efficiently move data around. Moving partitions around is a meta-data operation which is what makes it so efficient.

John MorehouseMar 12, 20189,0511,000

Sometimes, there is a need to insert bulk records into a database. In some cases, we have multiple unique records and that all needs to be inserted into the database. Instead of hitting the database for each record, we need to insert bulk records into database.

Sagar ShindeMar 10, 201850,8391,000

Here, in this article, we are comparing the SQL Join and SQL Subquery.

In this article, we will be talking about Dynamic Query and why it is bad.

Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.

Nirav DaraniyaJan 6, 201880,6351,000

Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.

Nirav DaraniyaJan 4, 201845,0421,000

This article gives an overview of how to export SQL query results to a text file.

Sagar ShindeDec 18, 201737,5221,000

In this article, I have shared the Roles and Responsibilities of a SQL Developer.

Sundaram SubramanianDec 9, 2017144,8171,000

How to use SQL Server 2017 on Docker containers to automate deployment using VSTS

Mahesh ChandNov 21, 201713,9581,000

Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.

Satyaprakash SamantarayNov 21, 201712,5201,000

Learn and download SQL Operations Studio

Mahesh ChandNov 17, 201728,4801,000

Learn how to search deterministic Always Encrypted columns in SQL Server 2016 and export and import the column master key certificate for a deployment environment.

Saravanan VNov 16, 201716,5651,000

Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.

Suvendu Shekhar GiriNov 15, 20178,2061,000

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 object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.

Suvendu Shekhar GiriNov 13, 201729,4641,000

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 security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.

Suvendu Shekhar GiriNov 11, 201735,1621,000