In this blog post, I’ll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients.
SQL SERVER – Troubleshooting Common CSV Import Issues
Let us explore Troubleshooting Common CSV Import Issues. Importing data from CSV files into SQL Server is a common task.
SQL SERVER – Stored Procedures to Check for Pythagorean Triples
I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.
SQL SERVER – Introduction to Dynamic Data Masking
In this blog post, we’ll explore the concept of dynamic data masking, a powerful feature available in Microsoft SQL Server 2016 and later.
SQL SERVER – STRING_AGG Function to Concatenate Strings
We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn.
SQL SERVER 2022 – GENERATE_SERIES Function
Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function.
SQL SERVER – Generating Complex Passwords with T-SQL
The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today.