Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is represented should be carefully considered during database design. In this article, Joe Celko considers the ways that SQL Server handles NULLs in several situations.
There is more to our lives than work, and Steve asks that we learn more about other parts of life.
Using R integration for analyzing sales data in WideWorldImporters database
Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?
Learning active forgiveness can be a challenge, but it may help you build a better team.
In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.
Setting up your authorization and security can be fairly easy, but perhaps we ought to consider more complex scenarios.
Learn how to import data into Power BI using either R or Python scripts.
Disaster recovery planning can be hard, and we often forget about some of the non technical issues.
As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item The Distance Metric
Comments posted to this topic are about the item The New Wave of Security...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers