So, You Want to Be a DBA…
Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives some advice for those who would like to be a DBA.
2020-08-31
database
SQL Server Problems We Don’t Have Anymore
There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.
2020-08-28
Storage 101: Data Security and Privacy
No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what must be considered to protect data in today's world.
2020-08-10
How to Install Azure Data Studio to Work with SQL Server
Brent shows us how to Install Azure Data Studio to Work with SQL Server.
2020-08-05
Allowing for manual checks and changes during database deployments
SQL Change Automation enables users to make database changes to production safely and efficiently using PowerShell cmdlets, which can be integrated easily into any release management tool. This article will show you how to automate database deployments safely, by using SQL Change Automation from within PowerShell scripts, and how a deployment script for a release can be checked and amended as part of the process.
2020-06-15
Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
2020-02-18
89,035 reads
Blogs
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers