This post explains and demonstrates the main different between CHARINDEX() and PATINDEX(). Keep in mind that CHARINDEX() function allows you to search for a substring in a string whereas PATINDEX() allows you to search for a substring and a pattern in a string. Both return 1 if found and 0 if not found. CHARINDEX() ThisContinue reading “charindex vs patindex”
Category Archives: Blog
import ssis packages
In this post, I will explain how to develop a PowerShell script to import multiple SSIS packages. You can use the script straight away to deploy the SSIS packages in any environment. I recommend that you to read all the steps in the script before you start using. This set of scripts were developed andContinue reading “import ssis packages”
sql server backups in parallel and zip the files
In this post, I will explain and provide a script that allow you to backup SQL Server databases in parallel. SQL Server backups are a key part of any database administrator’s job and one of the first items that will get automated in an environment. In my career, I have seen a number of differentContinue reading “sql server backups in parallel and zip the files”
download file from web and unzip it
In this tutorial, you will learn how to download files from the web using wget Python modules and unzip it. Run pip install wget if you have not yet install wget on your system. Below function will create a new local directory if not exit, download the web file then unzip it. Now, let’s executeContinue reading “download file from web and unzip it”
upload files from local directory to aws s3 bucket
In this article, I will focus on how python Boto3 library makes it easy for us to upload a single or all file(s) in amazon s3 bucket. Amazon Web Services (AWS) Simple Storage Service (S3) is a Storage-as-a-Service provided by Amazon. It’s a general purpose object store, the objects are grouped under a name spaceContinue reading “upload files from local directory to aws s3 bucket”
Delete all files from aws S3 bucket
Amazon Web Services (AWS) Simple Storage Service (S3) is a Storage-as-a-Service provided by Amazon. It’s a general purpose object store, the objects are grouped under a name space called “buckets.” The buckets are unique across the entire AWS S3. Boto library is the official Python SDK for software development and it provides APIs to workContinue reading “Delete all files from aws S3 bucket”
load csv file to aws dynamodb
This blog will describe one of the many ways to load a csv data file into AWS dynamodb database using python boto3 library provided by AWS. Amazon DynamoDB is a fully-managed NoSQL database service that offers speedy performance and scalability to store and retrieve any amount of data.Click here if you would like to setupContinue reading “load csv file to aws dynamodb”
Set Up Local DynamoDB in a Docker Container
In this tutorial, I am going to show you how to set up a local DynamoDB in a Docker container so that you can play around with it on your local machine without any cost. Click here if you have not setup docker yet or here to setup AWS SDK to your environment. Benefits ofContinue reading “Set Up Local DynamoDB in a Docker Container”
Build SQL Server Container Using Docker Compose file
As DBA, DevOps, and Data Engineer we should look for the most optimal way to maintain our environments however Docker Compose would be our best answer In a SQL Server Container world. What is Docker Compose?Docker Compose is a tool for defining and running multi-container Docker application and/or database services using a single YAML/YML file.Continue reading “Build SQL Server Container Using Docker Compose file”
Persist SQL Server Container Data-Part2
In Part1, I demonstrated the most basic way to persist data in SQL Server container however in this post which is part2, I will introduce kind of advance ways to persist data when using SQL Server container. Please click here if you have not setup docker yet within your environment or new to docker containerContinue reading “Persist SQL Server Container Data-Part2”
bigdatadriven.org 