Get the list of temporal tables in SQL Server DB
Using simple sql technique, here we will see how to get the list of temporal tables in a database.
Beaulin Twinkle
Check and drop system-versioned temporal table if exists
How to check and drop a system-versioned temporal table if it exists in the database as temporal tables are different from regular tables?
How to find the history table of a temporal table?
Here a simple trick to find the name of the history table of a system versioned temporal table using SQL select statement.
Find if system versioned temporal table exists
Let us see how to check if a specific table is system versioned temporal or not using SQL script. SQL tips to check if temporal table exists.
Creating and using temporal table (system-versioned table) in SQL Server.
Temporal table otherwise called as system-versioned table helps you to maintain the version history of the data in the table in a automated way.
Extended Events vs Profiler Trace in SQL Server
In this article let us see a briefing about how Extended Events are comparable with Profiler and Trace. Extended Events vs Profiler Trace.
Get only the common records from two tables using INTERSECT
With example how to get only the common records from two tables using INTERSECT and the advantages of INTERSECT over INNER JOIN.
Get records from one table which are not present in another table using EXCEPT
Getting records from one table which are not present in another table using EXCEPT operator in SQL Server.
Concatenate columns to string in SQL Server
In SQL Server there are several ways to concatenate columns to a single string. Here are few methods for concatenating columns based on the version of SQL Server.
Formatting SQL statements in SSMS
Formatting SQL statements or source code of procedures or function in SSMS is a daunting task. Here you will see how to use a plugin to format T-SQL in SSMS.
Creating code snippet for Python Django web app in VS Code
It will be a good practice to create a code snippet instead of copy paste the template code in several files. Creating code snippet for Python Django web app in VS Code.
Using database in Python Django website
Simple step by step illustrations for using database in Python Django website. Here we will be using SQLite database.
Adding image to Python Django web app
Adding images and other media files is same as adding other static files. Sometime you may need to segregate images in a separate folder.
Creating website with Python using VS Code on macOS
Step by step instruction on how to use Python for website development using Django as the web framework, Visual Studio Code as the editor on macOS.
How to copy a file in Python?
Here is a simple way to copy a file in Python programming using one of the copy methods in shutil library module.
How to get a sub-string from a string in Python
There are several ways to get a sub-string from a string in Python programming. Here we will see a simple slicing techniques to get sub string.
How to find the current directory of the script file in Python?
Here is a simple method to find the current directory of the script file in Python programming using a method from the os module.
Manually raising exception in Python
Sometime you may need to manually raise exception in Python programming instead of thrown automatically.
Get the last element of a list in Python
There are couple of simple ways to get the last element of a list in Python programming. Let us see both these methods with samples.
How to find number of elements in a list in Python?
Here is a simple tip to find the number of elements in a list in Python programming. Get the count of elements in a list.