Get the list of user created databases in SQL Server
Here is a simple tip to get the list of user created databases in an SQL Server.
Beaulin Twinkle
How to insert results from Stored Procedure to a temp table in SQL Server?
As a database programmer, you may need to get result in table format from a stored procedure and store it to a temp table. Here we will see how to insert results from Stored Procedure to a temp table.
Debugging Python Django web application
Debugging is a vital part web development. In this article, you will read about basics of debugging Python Django web application in VS Code editor.
Altering existing tables with data to system-versioned temporal table
Here are the simple steps with example for altering existing version tables with data to system-versioned temporal table.
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.
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.