Languages and coding

SQL Server PRINT and SQL Server RAISERROR statements

October 2, 2019 by Rajendra Gupta

This article explores the SQL Server PRINT statements, and its alternative SQL Server RAISEERROR statements to print messages in a query.

MySQL Query (T-SQL) Tutorial for SQL Server

September 25, 2019 by Jignesh Raiyani

Microsoft SQL Server and MySQL, both are quite well-established database engines. In our role as a DBA, at some given time point we require T-SQL straddling between both database engines unites Select, Insert, Update, Delete and some other…

Truncate Table Operations in SQL Server

September 25, 2019 by Dinesh Asanka

Truncating a table is removing all the records in an entire table or a table partition. TRUNCATE table is functionally similar to DELETE table with no WHERE clause. However, TRUNCATE table is much faster than DELETE with respect to the time and the resource consumptions which we will look at in this article. TRUNCATE statement removes the data by de-allocating the data pages in the table data. This means that TRUNCATE is similar to drop and re-create the table. Also, it records only the page de-allocations in the transaction log, not the row-wise as in DELETE statement.

Database Level DDL Triggers on Tables

September 23, 2019 by Jignesh Raiyani

This article portrays the different utilization of database DDL Triggers for the Tables with a counting mail alert on schema composition using DDL (Data Definition Language) standard. Using that efficient method we can keep close eyes on monitoring schema changes in any database of SQL Server. We’ll also see how we could monitor these movements and send an alert email to persons responsible to inform about this change.

T-SQL RegEx commands in SQL Server

September 17, 2019 by Rajendra Gupta

This article explores T-SQL RegEx commands in SQL Server for performing data search using various conditions.

Overview of SQL LOWER and SQL UPPER functions

September 10, 2019 by Rajendra Gupta

This article gives an overview of SQL UPPER function and SQL LOWER function to convert the character case as uppercase and lowercase respectively.

Overview of the SQL DELETE Column from an existing table operation

September 6, 2019 by Rajendra Gupta

In this article, we will explore the process of SQL Delete column from an existing table. We will also understand the impact of removing a column with defined constraints and objects on it.

TSQL history

September 3, 2019 by Daniel Calbimonte

In this article, we’ll take a look at a brief TSQL history and a few examples of loops, conditionals, and stored procedures

Different ways to SQL delete duplicate rows from a SQL Table

August 30, 2019 by Rajendra Gupta

This article explains the process of performing SQL delete activity for duplicate rows from a SQL table.

SQL Injection: Detection and prevention

August 30, 2019 by Ed Pollack

Summary

With an understanding of what SQL injection is and why it is important to an organization, we can shift into a discussion of how to prevent it. We ultimately want systems where SQL injection is impossible or very difficult to pull off. We then want systems where exploiting bugs is slow, laborious, and likely to raise monitoring alarms within an organization when attempted. The trio of layered security, prevention, and alerting can provide an immense advantage against not only SQL injection, but other data security threats.

SQL Injection: What is it? Causes and exploits

August 30, 2019 by Ed Pollack

Summary

Many security vulnerabilities are discovered, patched, and go away forever. Some linger and continue to plague software development and will continue to do so for years to come. Setting aside social engineering and non-technical attacks, SQL injection remains one of the top security threats to our data, as well as one of the most misunderstood.

SQL Server ALTER TABLE ADD Column overview

August 27, 2019 by Dinesh Asanka

In this article, we will explore SQL Server ALTER TABLE ADD Column statements to add column(s) to an existing table. We will also understand the impact of adding a column with a default value and adding and updating the column with a value later on larger tables.

SET NOCOUNT ON statement usage and performance benefits in SQL Server

August 26, 2019 by Rajendra Gupta

Have you ever noticed SET NOCOUNT ON statement in T-SQL statements or stored procedures in SQL Server? I have seen developers not using this set statement due to not knowing it.

sp_updatestats overview and usage

August 20, 2019 by Esat Erkec

In this article, we will learn usage details of the sp_updatestats built-in store procedure which helps to update all statistics in a SQL Server database. First of all, we will take a glance at the statistics concept in SQL Server.

Dynamic SQL in SQL Server

August 15, 2019 by Ranga Babu

In this article, we will review how to construct and execute dynamic SQL statements in SQL Server with different examples.

Calculate SQL Percentile using the PERCENT_RANK function in SQL Server

August 15, 2019 by Rajendra Gupta

This article explores the SQL Server PERCENT_RANK analytical function to calculate SQL Percentile and its usage with various examples.

SQL Server Statistics and how to perform Update Statistics in SQL

August 13, 2019 by Rajendra Gupta

This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics.

How to create geographic maps in Power BI using R

August 1, 2019 by Andrea Martorana Tusa

Introduction

This is the fifth article of a series dedicated to discovering geographic map tools in Power BI.

SQL STUFF function overview

July 31, 2019 by Rajendra Gupta

This article gives an overview of the SQL STUFF function with various examples.

FOR XML PATH clause in SQL Server

July 30, 2019 by Rajendra Gupta

As SQL professionals, we often have to deal with XML data in our databases. This article will help you walk through several examples of using ‘FOR XML PATH’ clause in SQL Server.

A complete guide to T-SQL Metadata Functions in SQL Server

July 30, 2019 by Gauri Mahajan

In this article, we will demonstrate T-SQL metadata functions available in the SQL Server.

SQL Server stored procedures for beginners

July 29, 2019 by Ranga Babu

In this article, we will learn how to create stored procedures in SQL Server with different examples.

Comparing VARCHAR(max) vs VARCHAR(n) data types in SQL Server

July 26, 2019 by Rajendra Gupta

I have seen that SQL developers use varchar(max) data while designing the tables or temporary tables. We might not be sure about the data length, or we want to eliminate the string or binary truncation error.

DBCC FREEPROCCACHE command introduction and overview

July 23, 2019 by Rajendra Gupta

This article gives an overview of the SQL Server DBCC FREEPROCCACHE command and its usage with different examples.

SQL Server Lead function overview and examples

July 16, 2019 by Rajendra Gupta

This article explores the SQL Server Lead function and its usage with various examples.