My book “Learn T-SQL from Scratch” is launched
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
13 reads
Brahmanand Shukla
- Website: https://sqlservercarpenter.com/
- LinkedIn: https://in.linkedin.com/in/brahmanand-shukla
Script to create copies of the existing object
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)
548 reads
Divide the rows of a column in equals batches in grid format
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)
499 reads
Get the month end dates of last N years
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)
345 reads
Divide the rows in equals batches
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)
1,881 reads
Get the month end dates of last N months
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
783 reads
SSIS Logging – Linking sysssislog with custom log
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)
442 reads
Query to find Nonclustered Index clashing with Clustered Index
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)
933 reads
Lesser-known facts of Explicit Transactions
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)
194 reads
Behavior of numeric data types with ”
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)
353 reads
Blogs
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Going to Cloud? Look at the Shared Responsibility Model
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
How Long Will It Take to Learn SQL? The Truth Might Surprise You
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Forums
Wholesale Pricing For WooCommerce Plugin
The Wholesale Pricing for WooCommerce plugin by Addify store allows for the management of...
azure synapse analytics
Dears, Hope this message finds you well I did not see in this foruns...
Restore dbs
The below code works for backup files only from local drives. When replaced with...
Question of the Day
Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers