Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2021-11-26 (first published: 2019-11-04)
14,704 reads
The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
2019-10-14
4,976 reads
As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.
2021-05-07 (first published: 2019-09-12)
5,370 reads
Learn some of the basics of using Dynamic SQL in a short series of videos.
2019-08-12
8,546 reads
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
488 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
26,646 reads
With the PBIR format of Power BI reports, it’s much easier to make report...
By Steve Jones
As we close out the year, I decided to drop this post here and...
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Hi, I have created a multicolumn paginated report, which includes a subreport that I...
I have this script that puts all of the output from query to a...
Hi, after i copy in ssis my excel file to a secured folder, its...
What is Terraform (from Hashicorp) used for in technology?
See possible answers