Skip to content
  • Facebook
  • GitHub
  • YouTube
  • Pinterest
My Tec Bits
  • Home
  • Microsoft
    • .Net
      • ASP.NET
      • MVC
      • Visual Studio
    • IIS
    • SQL Server
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012
      • SQL Server 2008
    • Windows OS
  • Web Development
    • Java Script
    • Jquery
    • Python
    • Bootstrap
    • Zurb Foundation
    • Web Security
  • More
    • macOS
    • Reviews
  • Online Tools
    • Fitness Calculators
    • Encoders & Decoders
    • Cryptography
    • Unit Converters
    • Math. Calculators
    • Date & Time Calculators
    • Finance Calculators

Beaulin Twinkle

How to find only the files in a directory in Python?

Mar 3, 2023Jul 12, 2019 by Beaulin Twinkle
find only the files in a directory in Python

A simple Python technique to find only the files in a directory. Here I have used pathlib and os.listdir to get the list of files.

Categories Python Tags Python 3.x Leave a comment

How to check if file exists before opening it in Python?

Jul 12, 2019 by Beaulin Twinkle
check if file exists before opening it in Python

Here is a simple Python technique to check if file exists before performing any operation on the file.

Categories Python Tags Python 3.x Leave a comment

Python code to find the version it is running on

Jul 10, 2019 by Beaulin Twinkle
Python code to find the version it is running on

Here is a simple Python code to find the version it is running on. You can get the full version number or the various components like manor, minor,… versions separately.

Categories Python Tags Python 3.x Leave a comment

Upgrading PIP on macOS for Python 3.x

Jul 10, 2019 by Beaulin Twinkle
Check latest released pip version

Here are the simple steps for upgrading “Package installer for Python” abbreviated as PIP to it’s latest version compactable to Python 3.x.

Categories macOS, Python Tags macOS Mojave, Python 3.x Leave a comment

Linting Python Code In Visual Studio Code

Jul 9, 2019 by Beaulin Twinkle
Linting Python Code In Visual Studio Code

In this article we will how to activate, install and use a popular linting tool PyLint on VS Code for linting python source code.

Categories Python Tags macOS Mojave, Python 3.x, Visual Studio Code Leave a comment

Installing Python Packages For Visual Studio Code On macOS

Sep 6, 2019Jul 9, 2019 by Beaulin Twinkle
Using Python Packages

In this article we will see how to create a virtual environment and installing Python packages for Visual Studio Code on macOS.

Categories macOS, Python Tags macOS Mojave, Python 3.x, Visual Studio Code 3 Comments

Setting Up Visual Studio Code For Python On macOS

Jul 9, 2019Jul 4, 2019 by Beaulin Twinkle
Python extension for VS Code

Simple step by step illustration for setting up visual studio code for Python programming and debugging on macOS computer.

Categories macOS, Python Tags macOS Mojave, Python 3.x, Visual Studio Code 2 Comments

How To Upgrade Python On MacOS?

Sep 9, 2020Jul 3, 2019 by Beaulin Twinkle
download the pkg file for macOS 64-bit installer

Here is the step by step instruction tp upgrade Python On maxOS to it’s latest version.

Categories macOS, Python Tags macOS Catalina, Python 3.8.x, Python 3.x Leave a comment

Check If Python Is Pre-installed On Your MacOS

Aug 5, 2021Jul 3, 2019 by Beaulin Twinkle
Check If Python Is Pre-installed On Your MacOS

Follow the steps given here to check if Python is pre-installed on your macOS computer.

Categories macOS, Python Tags macOS Mojave, Python 2.x, Python 3.x Leave a comment

How To Drop Temporary Table If Exists In SQL Server?

Jun 28, 2019 by Beaulin Twinkle
Drop Temporary Table Only If Exists

Here is a simple tip on how to drop a temporary or temp table if it exists using the DIY in 2016 or higher versions of SQL Server.

Categories SQL Server Tags SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How To Reset Identity Seed In SQL Server?

Jun 28, 2019 by Beaulin Twinkle
Reset Identity Seed In SQL Server

Here is a simple tip to reset identity seed of an auto incremented identity column after deleting records from the table in SQL Server.

Categories SQL Server Tags SQL Server 2017, SQL Tips, Transact-SQL (T-SQL) Leave a comment

Convert DateTime To YYYY-MM-DD Format In SQL Server

Dec 20, 2019Jun 27, 2019 by Beaulin Twinkle
Convert DateTime To YYYY-MM-DD Format

Here is a simple tip to convert the datetime value to a specific formatted date like YYYY-MM-DD in SQL Server 2012 and higher.

Categories SQL Server Tags SQL Server 2012, SQL Server 2017, SQL Tips, Transact-SQL (T-SQL) 3 Comments

Generate A Date From Day, Month & Year In SQL Server

Jun 26, 2019 by Beaulin Twinkle
Generate A Date From Day, Month & Year

Here is a simple method to generate a date from integer format of day, month and year in SQL Server.

Categories SQL Server Tags SQL Tips, Transact-SQL (T-SQL) Leave a comment

RAND() vs NEWID() In SQL Server

Jun 26, 2019 by Beaulin Twinkle
Rand() vs NewId()

Here we will compare the builtin SQL Server functions RAND() vs NEWID() and understand the major differences between them.

Categories SQL Server Tags Transact-SQL (T-SQL) Leave a comment

Generating Unique Random Number For Each Row in Select Statement

Jun 21, 2019 by Beaulin Twinkle
Unique Random Numbers For Each Row in Select Statement

Here is a simple trick for generating unique random number for each row in select statement in SQL Server. Let’s see how it works.

Categories SQL Server Tags SQL Tips, Transact-SQL (T-SQL) Leave a comment

How To Generate Random Numbers In SQL Server?

May 14, 2021Jun 21, 2019 by Beaulin Twinkle
Generate Random Numbers In SQL Server

Generating random numbers is very simple in SQL Server. We can use the built-in function RAND() to generate random number. Here are some examples.

Categories SQL Server Tags SQL Tips, Transact-SQL (T-SQL) 4 Comments

Getting The List Of Column Names Of A Table In SQL Server

Jun 20, 2019 by Beaulin Twinkle
Column Names using SP_COLUMNS

There are several ways to get the the list of column names of a table on a specific SQL Server database. I will go through these methods.

Categories SQL Server Tags SQL Tips, Transact-SQL (T-SQL) Leave a comment

Getting Day Of Year In SQL Server

Jun 20, 2019 by Beaulin Twinkle
Get Day Of Year In SQL Server

There is a couple of straightforward ways to get day of year for a given date in SQL Server using DATENAME or DATEPART built-in function. Let’s see how to use them

Categories SQL Server Tags SQL Tips, Transact-SQL (T-SQL) Leave a comment

How To Get Only The Date Part Of GetDate() In SQL Server?

Jun 20, 2019 by Beaulin Twinkle
Get Only The Date Part Of GetDate()

Here is the simple technique to get only the date part of GetDate() in SQL Server.

Categories SQL Server Tags SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How To Find Number Of Weeks In A Month in SQL Server?

Jun 20, 2019 by Beaulin Twinkle
Find Number Of Weeks In A Month in SQL Server

Here are couple methods to find the number of weeks in a month including the partial weeks considering different start day of week.

Categories SQL Server Tags SQL Tips, Transact-SQL (T-SQL) Leave a comment
Older posts
Newer posts
← Previous Page1 … Page9 Page10 Page11 … Page21 Next →

Article Categories

  • Android (2)
  • Apple (22)
    • macOS (22)
  • Internet & Web Dev. (152)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (7)
    • Python (83)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (4)
  • Microsoft (318)
    • .Net (69)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (225)
    • Windows (24)
  • Networks And Distributed Systems (2)
  • Oracle (7)
    • Java (2)
    • Oracle Database (5)
  • Others (6)
  • Reviews (10)

Recent Articles

  • Installing .NET SDK in Linux Mint and debugging C# code using VS Code Jun 21, 2024
  • Generating random number in C#  Jun 6, 2024
  • How to calculate running total in SQL Server? Apr 27, 2024
  • How to import XML data into SQL Server using SELECT query? Apr 10, 2024
  • How to prevent VS Code from replacing an already opened preview tab with a subsequently opened one? Mar 13, 2024
  • Separating letters and numbers from strings in SQL Server Mar 6, 2024
  • How to call or run another application from python code? Feb 15, 2024
  • How to store images in SQL Server? Jan 17, 2024
  • Error: A table that has FILESTREAM columns must have a nonnull unique column with the ROWGUIDCOL property. Jan 8, 2024
  • Fix for Error: “FILESTREAM feature is disabled” while adding FILESTREAM Jan 4, 2024

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators
  • Date & Time Calculators
  • Finance Calculators

Popular Articles

  • How to exit from single-user mode in SQL Server database?
  • Auto Generate INSERT Statements for a Table in SQL Server
  • Where is SQL Server Configuration Manager?
  • Joining Tables from Databases on Different SQL Servers
  • Clean way to uninstall Docker on macOS
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. Learn more...
  • Home
  • About Us
  • Contact Us
  • Site Map
  • Terms Of Use
  • Privacy Policy
© 2012 - 2025 My Tec Bits. All Rights Reserved.