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

19 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)

562 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)

520 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)

366 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,142 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,182 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)

470 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)

953 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)

228 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)

422 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

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened

What is CPU Usage?

Limiting Checkpoints

Question of the Day

Limiting Checkpoints