How to Compare Two SQL Prompt Styles
A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code.
2021-07-26
Conditional Formatting
Conditional Formatting with SSRS
An introduction on how to implement condition formatting of cells, such as the font and background colour or font weight, within SSRS using SSRS Expressions.
2022-11-25 (first published: 2020-09-17)
38,458 reads
Managing Recursive Group on SSRS Reporting Services Reports
Learn how to implement a report that recursively walks a hierarchy in a table.
2019-11-05
10,316 reads
Blogs
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Forums
Find all records in a table whose values when summed up will equal another value
I have a list of transactions in a table. Each transaction has a unique...
sp_lock memory leak
I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...
Migration related issue
I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers