Forrards Blog

130 cents total
How to convert to Base64 and backwards via T-SQL

I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important advantage - it works OOB, without CLR functions. We need a test database and a table to use as an example:

Forrards
March 18, 2023
Performance and using of VARCHAR boxes as filters in SSRS reports

Very few people have thought about this performance killer. It is all about report parameter of text type.The initial situationThere was a table with about 45 million rows. Some columns in the table were VARCHAR and should have been filtered. As a result of filtering by 10 different parameters the total number of rows could have been significantly reduced. SQL Server was going for table scan in this case. Also there was a number of indexes defined on the table.

Forrards
March 18, 2023
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Subscribe to our blog

                             

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Remote DBA Services: Database Shrinking

It is a well-known fact that sooner or later each business dependent on IT-infrastructure faces with “Low disk memory” problem. There are plenty of ways to clean the disk’s space, using standard OS services. But neither of them can be used for cleaning or shrinking data on SQL Server. The problem can stuck the overall business processes though and lead to unplanned delay and high costs.

Forrards
March 31, 2023
Top 4 Reasons to decide on Remote DBA Services

Before we review what remote DBA services are, let’s clarify the DBA itself. Database administration or shortly DBA aims to maintain functionality, safety and integrity of database management software – Oracle, DB2 and SQL Server in the first hand. Nobody wants to end up with a non-working system with all the data become unavailable or even lost. So the scope of DBA services covers every matter that explicitly or implicitly influences the operation of a DBMS.

Forrards
March 31, 2023

Let's discuss your project or resource request

                       

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.