This article covers the following topics:
- Overview of the Amazon Athena
- Query CSV file stored in Amazon S3 bucket using SQL query
- Create SQL Server linked server for accessing external tables
Rajendra Gupta
Hi! I am Rajendra Gupta, Database Specialist and Architect, helping organizations implement Microsoft SQL Server, Azure, Couchbase, AWS solutions fast and efficiently, fix related issues, and Performance Tuning with over 14 years of experience.
I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure". I published more than 650 technical articles on MSSQLTips, SQLShack, Quest, CodingSight, and SeveralNines.
I am the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups.
Based on my contribution to the SQL Server community, I have been recognized as the prestigious Best Author of the Year continuously in 2019, 2020, and 2021 (2nd Rank) at SQLShack and the MSSQLTIPS champions award in 2020.
Personal Blog: https://www.dbblogger.com
I am always interested in new challenges so if you need consulting help, reach me at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
I am the author of the book "DP-300 Administering Relational Database on Microsoft Azure". I published more than 650 technical articles on MSSQLTips, SQLShack, Quest, CodingSight, and SeveralNines.
I am the creator of one of the biggest free online collections of articles on a single topic, with his 50-part series on SQL Server Always On Availability Groups.
Based on my contribution to the SQL Server community, I have been recognized as the prestigious Best Author of the Year continuously in 2019, 2020, and 2021 (2nd Rank) at SQLShack and the MSSQLTIPS champions award in 2020.
Personal Blog: https://www.dbblogger.com
I am always interested in new challenges so if you need consulting help, reach me at rajendra.gupta16@gmail.com
View all posts by Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
- How to install PostgreSQL on Ubuntu - July 13, 2023
- How to use the CROSSTAB function in PostgreSQL - February 17, 2023
- Learn the PostgreSQL COALESCE command - January 19, 2023
Read SQL Server error logs using the xp_readerrorlog command
November 14, 2019This article explores the xp_readerrorlog command for reading SQL Server error logs using T-SQL.
Read more »
Overview of DBCC INPUTBUFFER and sys.dm_exec_input_buffer DMF
November 7, 2019This article gives an overview of the DBCC INPUTBUFFER and its replacement sys.dm_exec_input_buffer system dynamic management function .
Read more »
Exploring the SandDance Visualizations extension in Azure Data Studio
November 6, 2019Azure Data Studio is an open-source, cross-platform and lightweight data management tool. We can use it for on-premise SQL Server, Azure SQL database and Azure SQL data warehouse. Previously we knew this tool as SQL Operations Studio.
Read more »
A handy SQL Notebook for the purposes of troubleshooting in Azure Data Studio
November 5, 2019This article prepares a handy SQL Notebook for DBAs. You can use this notebook to troubleshoot performance issues and for getting SQL Server instance details.
Read more »
SQL Carriage Returns or Tabs in SQL Server strings
November 4, 2019This article explores inserting SQL carriage return AKA line break and tab in a string along with SSMS behavior while copying data to excel, notepad.
Read more »
The Partial SQL Server Database Backup
October 30, 2019This article explores the partial backup SQL Database strategy in SQL Server and its usages for read-only filegroups.
Read more »
Data Import from Amazon S3 SSIS bucket using an integration service (SSIS) package
October 28, 2019This article explores data import in SQL Server from a CSV file stored in the Amazon S3 SSIS bucket.
Read more »
Methods to avoid the SQL divide by zero error
October 21, 2019This article explores the SQL divide by zero error and various methods for eliminating this.
Read more »
SET QUOTED_IDENTIFIER settings in SQL Server
October 17, 2019In this article, we will explore QUOTED_IDENTIFIER behavior, default value, and comparison with a different value. Set options at connection level control query behavior in SQL Server. The query might behave differently with different set options and their values.
Read more »
An overview of the SQL table variable
October 16, 2019This article explores the SQL Table variables and their usage using different examples.
Read more »
SQL Lag function overview and examples
October 15, 2019In the article SQL Server Lead function overview and examples, we explored Lead function for performing computational operations on data. This article gives an overview of the SQL Lag function and its comparison with the SQL Lead function.
Read more »
Multi-AZ Configuration for AWS RDS SQL Server
October 10, 2019Amazon provides AWS RDS SQL Server as a managed relational database service. You can deploy databases instantly without worrying about underlying hardware platform, license cost, managing data centers. AWS RDS database instances are highly available. It provides a failover mechanism using the Mult-AZ deployments.
Read more »
A Walkthrough of SQL Schema
October 9, 2019This article gives an overview of SQL Schema and its usage in SQL Server.
Read more »
Overview of SQL Server Aliases
October 7, 2019This article gives an overview of SQL Server Alias and its usage for connecting with SQL Server.
Read more »
Enforce SSL connections in AWS RDS SQL Server
October 7, 2019This article explores a method to enforce SSL for all connections in AWS RDS SQL Server.
Read more »
Pseudo-Simple SQL Server Recovery Model
October 7, 2019This article gives an overview of the Pseudo Simple SQL Server Recovery Model. It also explores the conditions in which the database behaves in Pseudo mode.
Read more »
Encrypted Backup and Restore in AWS RDS SQL Server
October 4, 2019In the article, Recover Data in AWS RDS SQL Server, we explored the process of native backup and restoration for the AWS RDS SQL Server database. It involves the following steps:
Read more »
Piecemeal Database Restores in SQL Server
October 3, 2019This article explores the piecemeal database restore SQL Server feature and its benefits to minimize the database restoration.
Read more »
SQL Server PRINT and SQL Server RAISERROR statements
October 2, 2019This article explores the SQL Server PRINT statements, and its alternative SQL Server RAISEERROR statements to print messages in a query.
Read more »
Recover Data in AWS RDS SQL Server
September 27, 2019This article explores the process to recover data in AWS RDS SQL Server and its recent enhancements.
Read more »
An Overview of Instant File Initialization in SQL Server
September 25, 2019This article gives an overview of Instant File Initialization and its benefits for SQL Server database creation, restoration and file growth.
Read more »
T-SQL RegEx commands in SQL Server
September 17, 2019This article explores T-SQL RegEx commands in SQL Server for performing data search using various conditions.
Read more »
Row Sampling Transformations and Percentage Sampling Transformations in SSIS packages
September 11, 2019This article explores Row Sampling Transformations in SSIS and Percentage Sampling Transformations in SSIS packages
Read more »
Character Map Transformations in SSIS packages
September 11, 2019This article explores the Character Map Transformation in SSIS package with available configurations.
Read more »