Brahmanand Shukla

I’m a seasoned SQL Server Professional having certified with MCSA SQL 2016 and with over 12 years of rigorous working experience in the Design, Development, and Optimization of MS SQL Databases. Few of my unique skills involved – Out of box thinking when working out the database design and can-do anything attitude when it comes to the database. Managed money critical, compliance critical, and performance-critical SQL Server databases, and some of them were in TB’s. You can find out more about me on LinkedIn (https://in.linkedin.com/in/brahmanand-shukla)

Website: https://sqlservercarpenter.com/
LinkedIn: https://in.linkedin.com/in/brahmanand-shukla

All authors

My book “Learn T-SQL from Scratch” is launched

by Brahmanand Shukla

SQL Server Carpenter

A lot of my colleagues and people in my network reached out to me to train them on the SQL Server and T-SQL. They think that my style of...

2021-11-23

15 reads

Script to create copies of the existing object

by Brahmanand Shukla

SQL Server Carpenter

Many a time we need copies of an object but with different names. I also got a requirement to process the files in parallel using SSIS. We had already...

2021-09-17 (first published: 2021-09-09)

558 reads

Divide the rows of a column in equals batches in grid format

by Brahmanand Shukla

SQL Server Carpenter

I published an article Divide the rows in equals batches few days ago. One of my reader requested me to help him with a requirement to divide a column’s...

2021-09-13 (first published: 2021-08-28)

513 reads

Get the month end dates of last N years

by Brahmanand Shukla

SQL Server Carpenter

Here is a simple T-SQL script that may come handy if you need the month end dates of last N years. N is the number of years. The output...

2021-09-03 (first published: 2021-08-13)

350 reads

Divide the rows in equals batches

by Brahmanand Shukla

SQL Server Carpenter

Here is the simple and practical use case of NTILE function. We’ve used it to divide the rows of sys.columns into N batches. N is the batch size. We’ve...

2021-08-25 (first published: 2021-08-15)

2,126 reads

Get the month end dates of last N months

by Brahmanand Shukla

SQL Server Carpenter

Here is a simple T-SQL script that may come handy if you need the month end dates of last N months. N is the number of months. The output...

2021-08-13

1,141 reads

SSIS Logging – Linking sysssislog with custom log

by Brahmanand Shukla

SQL Server Carpenter

I was working on an ETL solution, which was expected to run for hours. It has become extremely important to track the errors properly, so as to debug the...

2021-07-05 (first published: 2021-06-21)

464 reads

Query to find Nonclustered Index clashing with Clustered Index

by Brahmanand Shukla

SQL Server Carpenter

It’s being quite a long time when I made the last post. Actually, I was lacking a topic that should trigger me to write. Finally, I got one when...

2021-05-12 (first published: 2021-04-28)

943 reads

Lesser-known facts of Explicit Transactions

by Brahmanand Shukla

SQL Server Carpenter

Transactions are of various kinds in SQL Server such as Autocommit, Implicit, Explicit and Batch-scoped. I personally found this article quite helpful if you wish to understand Implicit Transactions....

2021-03-22 (first published: 2021-03-16)

214 reads

Behavior of numeric data types with ”

by Brahmanand Shukla

SQL Server Carpenter

As we all know, there are various numeric data types, such as TINYINT, INT, SMALLINT, BIGINT, NUMERIC, DECIMAL, SMALLMONEY, MONEY and FLOAT. I was working on a SSIS package,...

2021-03-10 (first published: 2021-03-07)

412 reads

All authors

Brahmanand Shukla

My book “Learn T-SQL from Scratch” is launched

Script to create copies of the existing object

Divide the rows of a column in equals batches in grid format

Get the month end dates of last N years

Divide the rows in equals batches

Get the month end dates of last N months

SSIS Logging – Linking sysssislog with custom log

Query to find Nonclustered Index clashing with Clustered Index

Lesser-known facts of Explicit Transactions

Behavior of numeric data types with ”

Blogs

SQL Saturday Boston Slides and Code

Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings

Advice I Like: Fear and Imagination

Forums

How to use data pre-computed in previous ETL SSIS Nodes?

Building AI Governance and Policies- First Steps

Simple delete causes table scan on other tables with foreign key

Question of the Day

Checking Identities