PostgreSQL Constraints: Learning PostgreSQL with Grant
PostgreSQL supports constraints much like any other database management system. When you need to ensure certain behaviors […]
Homepage
Manage Data Over Time with SQL Server MERGE Statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 8 items […]
Index Types in PostgreSQL: Learning PostgreSQL with Grant
As with any other relational data management system (RDBMS), PostgreSQL uses indexes as a mechanism to improve […]
Introducing the MySQL common table expression
This article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all 10 items […]
Don’t Just Chase the Shiny
Fish are beautiful creatures, but they have one minor issue. The main thing I remember from the […]
Azure Function and User Assigned Managed Identities
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many […]
Resolving to Write in the New Year
It is almost New Year’s Day, that time when the optimistic at heart start thinking about making […]
The Good, The Bad, and Suboptimal of Sticking to What ...
The Good In the late 1990s, one of the world’s most popular technologies was waning. COBOL. Relational […]
Subqueries in MySQL
Part of Robert Sheldon’s continuing series on Learning MySQL. The series so far: Getting started with MySQL […]
Express.js or Next.js for your Backend Project
Backend projects create projects to execute code on a centralized server and then communicate results with a […]
Converting Data Across Time Zones: An In-Depth Primer
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t […]
The Basics of Deleting Data from a SQL Server Table
Greg Larsen’s series on Learning T-SQL so far: The basic T-SQL Select Statement Ordering a result set […]
How to Use Any SQL Database in GO with GORM
Object Relational Mapping is a database abstraction technique that aids developers in manipulating and interacting with SQL […]
Introducing the MySQL UPDATE statement
Entry in Robert Sheldon’s series on Learning MySQL. The series so far: Getting started with MySQL Working […]
Oracle optimizer Or Expansion Transformations
Jonathan Lewis’ continuing series on the Oracle optimizer and how it transforms queries into execution plans: Transformations […]
The Basics of Updating Data in a SQL Server Table
Entry in Greg Larsen’s series on Learning T-SQL. The series so far: The basic T-SQL Select Statement […]
Going to the PASS Data Community Summit this year?
We are just one month away from the PASS Data Community Summit. One month. If you haven’t […]
Backing up MySQL Part 1: mysqldump
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is […]
Introducing the MySQL INSERT statement
Entry in Robert Sheldon’s series on Learning MySQL. The series so far: Getting started with MySQL Working […]
The Basics of Inserting Data into a SQL Server Table
Entry in Greg Larsen series on Learning T-SQL. The series so far: The basic T-SQL Select Statement […]
Introducing the MySQL SELECT statement
The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working […]
Summarizing data using GROUP BY and HAVING clauses
SQL Server provides the GROUP BY clause as a means to take a set of detailed values […]
Security in MySQL: Part Two
Welcome back to this series about improving the security in your MySQL infrastructure. The first part of […]
Datamarts and exploratory analysis using Power BI
Power BI Datamarts is an important new feature announced during BUILD. This new feature expands Power BI […]
How to troubleshoot and fix PostgreSQL performance issues
PostgreSQL is a popular database that is used by many applications. It’s been in active development for […]
Azure Synapse Link for SQL: From production to a data ...
The Link technology in Synapse is used to synchronize data from different data sources to Synapse Analytics. […]
The VALUES clause or building tables out of nothing
The VALUES clause is probably one of the most misused features in SQL. If you look at […]
Security in MySQL: Part One
Security is a critical part of any infrastructure – it’s even more so in the database world, […]
Creating unique datasets with managed code
Figuring out uniqueness in large datasets is somewhat trivial in SQL via the DISTINCT statement. This DISTINCT […]
Text Mining and Sentiment Analysis: Oracle Text
The series so far: Text Mining and Sentiment Analysis: Introduction Text Mining and Sentiment Analysis: Power BI […]
A UNIQUE experience
If you look at the postings on SQL forums, you will notice that people are sloppy. They […]
Improving performance with instant file initialization
As a database administrator, one of your jobs is to make sure each SQL Server instance you […]
SQL Server and hyperconvergence
A growing number of organizations have deployed hyperconverged infrastructure (HCI) systems in an effort to simplify IT […]
Embed Power BI in Jupyter Notebooks
Microsoft recently announced the ability to include Power BI reports inside Jupyter notebooks. After overcoming the dazzle […]
Introduction to generic Power BI themes
Power BI has taken the world by storm when it comes to creating attention-grabbing dashboards that empower […]
SQL Server transaction log architecture
The transaction log is a file that each SQL Server database has. It can be thought of […]
SQL Server performance tuning: Nine best practices
SQL Server is a powerful and feature-rich database management platform that can support a wide range of […]
DBA in training: SQL Server high availability options
The series so far: DBA in training: So, you want to be a DBA… DBA in training: […]
Oracle Sequences: RAC
The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, […]
SQL Server security – Providing a security model using user-defined ...
When developing an application that accesses SQL Server, you need to set up a security model, so […]
SQL Server plan cache mining – Plan attributes
The execution plan cache in SQL Server is a treasure trove of information about queries that have […]
How to choose between SQL and NoSQL databases
Organizations that support data-intensive applications must make many decisions about how to best implement and maintain them. […]
SQL Server Security – Fixed server and database roles
Managing Security for SQL Server is extremely important. As a DBA or security administrator, you need to […]
Building a SQL Server data dictionary
A data dictionary is a documentation tool that provides metadata, metrics, or details about a database and […]
Oracle sequences: The basics
Many database applications make use of “meaningless ids” or “synthetic keys” rather than using columns of user […]
A data transformation problem in SQL and Scala: Dovetailing declarative ...
Part II : Equivalent Solutions in Functional Programming – Scala Part I of this two-part series presented […]
What to monitor for SQL Server security
SQL Server databases are under greater threat than ever. Cyberattacks are on the rise, and they’re becoming […]
Mastering TempDB: Managing TempDB growth
The series so far: Mastering TempDB: The basics Mastering TempDB: Managing TempDB growth As you learned in […]
What is interpolation?
Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. […]