(Hannes du Preez) Use this nifty function to check the validity of an email address.

(Thomas LaRock) Last week, Stack Overflow acknowledge their culture issues with this post. I’m glad to see them talking about these issues publicly, and they are actively looking to make things better. Admitting you have a problem is a good first step.

(Krishnakumar Rukmangathan) In this blog, we will be addressing the problem with CDC implementation in SSIS package which goes with the error ‘invalid column name __$command_id’.

(Jayendra Viswanathan) Many organizations have some type of hierarchy for business processes. When it comes to large organizations, the hierarchy can get very complex and large, so building a hierarchy in a RDBMS is a tedious task.

(Marcin Policht) Deployment of cloud-based technologies introduces a wide range of challenges; however, few of them are scrutinized to the same extent as security.

(Jack Vamvas) Question: I understand the theory behind NULLIF – based on the MS documentation “Returns a null value if the two specified expressions are equal”.

(Grant Fritchey) I’ve been in love with the concept of a database as a service ever since I first laid eyes on Azure SQL Database. It just makes sense to me. Take away the mechanics of server management and database management. Focus on the guts of your database.

(Pinal Dave) While playing with my lab cluster, I ran into a situation. In this blog, we would learn about a situation where failover was not working from one node to another node. Everything used to work fine on Node1. Let us fix the error related to failover clustered.

(Hannes du Preez) In order to execute a Stored Procedure when SQL Server starts, you first need to enable scanning for Startup Procedures with the following code:

(Jose M Jurado) Some days ago, I have been working on an issue that our customer is trying to enable Data Masking for a specific column of a table and they got an error “the index … is dependent on column …”