Get Free Access to Azure SQL Database for a Lifetime
Read this article to learn how Azure offers free access to an Azure SQL Database serverless configuration for a lifetime.
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 can be reached at: Rajendra.gupta16@gmail.com for any consulting help.
- MSSQLTips Awards:
- Author of the Year - 2022 | Author Contender - 2021/2023/2024 | Champion Award (100+ tips) - 2020
Polymorphism in Python Code Examples – Functions, Classes, Inheritance
Learn about polymorphism in Python with these code examples to learn about functions, classes, inheritance, and duck typing.
Python Classes for Code Reusability
In this article, we look at Python classes and how to use classes to implement reusable code encapsulating data and behavior in a single entity.
Python Functions for Reducing Code Complexity
Learn about Python functions to solve the problem of having to write repeated code, make code easier to understand, and reduce code complexity.
SQL Server Management Studio 20 New Features and Functionality
Learn about some of the new features and functionality of SQL Server Management Studio 20.
Python Control Flow – if, if else, nested if, for loop and while loop
Learn how to write Python code to handle conditional logic such as if, if else, nested if, for loop, while loop, and ternary operators.
Python String Functions: Concatenate, Split, Replace, Upper, Lower
Learn how to manipulate strings in Python with these string functions: concatenate, split, replace, upper, lower, and more.
Python Variables and Data Types
Learn about different data types using Python along with how to create and use variables in Python.
AI Tools to Generate SQL Queries with Code Reliability
In this article, we look at how AI tools can generate SQL queries and whether you can rely on the SQL code that is generated.
Python Programming Introduction – Install, Jupyter Notebooks, VS Code
In this step-by-step article, learn how to quickly install Python and start writing Python code using Jupyter Notebooks or Visual Studio Code.
Limit Data used by Amazon Athena Queries
Learn how to manage and control the amount of data used for Amazon Athena queries to limit excessive query runs.
Query Amazon CloudTrail Logs using Amazon Athena
This tip covers using Amazon Athena to query Amazon CloudTrail logs for auditing your AWS account.
AWS Athena Data Partitioning to Improve Performance and Reduce Cost
Learn how Amazon Athena can partition data based on data stored in AWS S3 to improve performance and reduce AWS costs.
Create a Linked Server from SQL Server to AWS Athena Tables
In this article, learn how to create a linked server from SQL Server to AWS Athena tables.
AWS Athena Configuration, Querying Data, Create Tables and Views
In this article, we look at how to use AWS Athena to query data as well as create tables and views when working with Athena.
Learn SQL Athena – How, Why and Advantages
Learn about Amazon Athena, how it works, why you would use it, and some of the advantages of Athena over traditional relational databases.
SQL Declare Variable Code Examples
Learn how to define and use variables in SQL Server code with these many different code examples.
Append SQL Table with New Columns and Add New Data
In this article, learn how to append columns to an existing SQL Server table as well as how to append data to a SQL Server table.
Go-SqlCmd for Deploying and Using Containers
Go-SqlCmd provides additional features for deploying and using containers with great flexibility which we will explore in this tip.
go-sqlcmd tool for SQL Queries, Scripts and Automation
Learn about the new version of SQLCMD called go-sqlcmd which you can download and begin using to interact with SQL Server.
SQL CASE Statement in WHERE Clause Examples
Discover the power of SQL CASE in the WHERE clause to enhance your data filtering capabilities in SQL queries.
SQL Round Function Examples
Learn about the SQL ROUND function and how it works to round numbers up or down or to truncate values at a specific location.
SQL SUBSTRING Code Examples and Usage
Learn different ways to use the SQL SUBSTRING function along with several different code examples of how this can be used.
SQL Certifications Program from Microsoft
Microsoft made changes to its certification program and knowing about these changes can help you plan for future certifications related to SQL Server.