SQL Boolean Tutorial
November 28, 2022The SQL Boolean data type is not included in SQL Server. Other databases like Oracle and MySQL include the Boolean data type that accepts the values of TRUE, and FALSE.
Search Results for: INSERT
INT vs BIGINT in SQL Server with Examples
November 22, 2022SQL Server provides int, bigint, smallint and tinyint data for storing exact-number data. In this article, we will focus on int and bigint data types.
Using parameterized queries to avoid SQL injection
November 18, 2022In this article, we will explain what the SQL injection attack is, why it could be hazardous, and how to defend our SQL database from this attack using parameterized queries and some third-party tools.
ODBC drivers for Azure SQL
November 9, 2022Introduction In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure and export the data from one table in Azure to SQL Server on-premises using SSIS.
SQL Subtract dates
November 7, 2022In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I will add some theory to understand the syntax of the DATEDIFF function which is the base of this article.
Getting started with procedures in Azure Database for PostgreSQL
October 26, 2022In this article, we will learn how to work with procedures in Azure Database for PostgreSQL.
Changing the location of FILESTREAM data files in SQL Database
October 14, 2022This article explains different ways to change the location of the FILESTREAM data files. The FILESTREAM feature was introduced in SQL Server 2008 version. We can efficiently store the BLOBs in the SQL database using FILESTERAM.
Reporting data from Azure Database for PostgreSQL using Power BI
October 12, 2022In this article, we will learn how to use Power BI to source data from an instance of Azure Database for PostgreSQL, transform this data and load it into Power BI for reporting.
SQL Commands to check current Date and Time (Timestamp) in SQL Server
October 7, 2022This article explores different SQL Commands (functions) to return the current Date and Time (Timestamp) in SQL Server.
Querying data from Azure Database for PostgreSQL using psql
October 3, 2022In this article, we will learn how to query the data as well as database objects hosted in an instance of Azure Database for PostgreSQL using psql and export the results of the query to a file.
SQL Partition overview
September 26, 2022Introduction In SQL Server there are several kinds of SQL partitions. However, in general, we can say that a partition is a way to divide a table (sometimes a view) into smaller pieces for performance purposes. In this article, we will explain what partition does mean for a table partition and SSAS. We will also […]
Deploy a SQL Server container using Azure Kubernetes Services (AKS)
August 31, 2022This article deploys a SQL Server container using Azure Kubernetes Services (AKS).
Azure SQL Interview Questions and Answers
July 13, 2022Interested in becoming an Azure SQL DBA but don’t know how to start? This article prepares you for the Azure SQL DBA interview by providing reference material links.
Analyzing key influencers in data with Power BI
June 29, 2022In this article, we will use Power BI Desktop to analyze key influencers in a dataset and learn how to use the corresponding visualization as well.
Understanding the OPENQUERY function in SQL Server
June 24, 2022In this article, we are going to learn about the OPENQUERY function. It is used to run an ad-hoc distributed query on the remote data source using the linked server. There are various ways to query the remote data source. You can read this article, Querying remote data sources in SQL Server, to learn more […]
How to overcome parameter sniffing problems in ad-hoc queries
June 17, 2022The purpose of this article is to provide insights into how parameter sniffing occurs for an ad-hoc query and how it affects their performance.
Notebook Views for SQL Notebooks in Azure Data Studio
June 15, 2022We are excited to share that Notebook Views are available for SQL Notebooks in the Azure Data Studio (Currently Insiders release). This article will cover the following topics: What are Notebook Views? Where can you find Notebook Views? How do you create a new view? How do you modify an existing view? Where can you […]
SQL Server statistics from a different perspective
June 10, 2022The goal of this article is to throw light on the less-known points about SQL Server statistics.
7 Common T-SQL Query mistakes
June 1, 2022SQL (Structured Query Language) is an ANSI/ISO standard programming language that is designed to program relational databases and T-SQL (Transact-SQL) is an extended implementation of the SQL for Microsoft SQL Server databases. T-SQL is highly used by database persons when they want to program or manage the SQL Server databases. However, the beginners may do […]
How to write readable T-SQL queries
May 18, 2022This article intends to give some beneficial suggestions that help to write a more readable T-SQL query.
Lever the TSQL MAX/MIN/IIF functions for Pinpoint Row Pivots
May 16, 2022Introduction For a recent Tsql development project involving text document records, the customer wanted a product that would show the latest and most recent earlier version of specific document text stored in a SQL Server 2014 database. One result set row had to hold all relevant information for each document: both document versions as described […]
Working with the SQL MIN function in SQL Server
May 12, 2022The SQL MIN function is an aggregate function that is used to find the minimum values in columns or rows in a table.
CREATE TABLE statement in SQL Server
April 29, 2022In this article, we are going to learn about the CREATE TABLE statement. This article consolidates the various scenarios. I have covered the following scenarios.
Database level roles in Azure SQL Database
April 12, 2022This article explores the database-level roles in the Azure SQL Database.
5 reasons to consider on your Query Performance degradation
April 7, 2022This article gives fundamental insights into which 5 reasons can cause to drop off the query performances in SQL Server.