We’ll explore industry guidelines for complex passwords and implement them in an SQL Server stored procedure to generate secure passwords.
SQL SERVER Performance: Functions in WHERE Clause
Functions in WHERE clause can hurt performance. I compare a query using YEAR() with one using direct column references on AdventureWorks, plus indexes.
SQL SERVER – A Comparison of CHARINDEX vs LIKE
In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
SQL SERVER – Stripping HTML Tags from Text
In this blog post, we’ll explore a method for stripping these HTML tags from your text data using SQL Server. Let us explore the post.
Repeatable Test Data With a Fixed Random Seed
Generate repeatable test data with a fixed RAND seed or row-number hashes, then verify identical names and amounts across runs.
SQL SERVER – Avoid Functions in the WHERE Clause for Performance
Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.
SQL SERVER – Techniques for Retrieving Random Rows
This post will explore various techniques to retrieve random rows in SQL Server and analyze their performance and randomness characteristics in depth.