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 […]
simple-talk.com
Dealing with the Bits of a Binary Value in SQL ...
How you used to do it For example, say you want to find all the read-write database […]
Backing Up MySQL Part 7: MySQL Enterprise Backup
MySQL Enterprise Backup is a known tool for everyone inside of the world of MySQL, no matter […]
Subqueries in MySQL
Part of Robert Sheldon’s continuing series on Learning MySQL. The series so far: Getting started with MySQL […]
Backing Up MySQL Part 5: Backing Up Big Data
According to research made by Statista in 2022, the amount of data that is being worked with […]
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 […]
Backing up MySQL Part 4: mydumper
There are many tools we can use to back up our MySQL databases. Some are well-known and […]
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 […]
SQL Server 2022: Azure AD Authentication
SQL Server 2022 is finally GA and one of the features I was most expecting is finally […]
Backing up MySQL Part 3: mysqlpump
In the MySQL world, there are a couple of ways to take backups of your data. Backups […]
Backing Up MySQL Part 2: Percona XtraBackup
There’s no doubt about it – if you’ve ever heard of Percona, you’ve heard of XtraBackup as […]
Introducing the MySQL DELETE statement
Preparing your MySQL environment As with the previous few articles, I used the same database and tables […]
Optimizing MySQL: The Basics of Query Optimization
MySQL is a very interesting beast to deal with – both junior developers and expert database administrators […]
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 […]
The PASS Data Community Sessions I Am Most Excited For
Note: Edited to add more sessions… So many The PASS Data Community Summit is coming up in […]
The PASS Sessions I Am Most Excited For
The PASS Data Community Summit is coming up in less than three weeks, so it is time […]
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 […]
Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, […]
T-SQL Tuesday #154 – SQL Server 2022, IS DISTINCT FROM
SELECT CASE WHEN 1 = NULL THEN ‘True’ Else ‘False’ end, CASE WHEN NOT(1 = NULL) THEN […]
Synapse Analytics: When you should use (or not use) Synapse
Synapse is a great data lake house tool. This means in a single tool we have resources […]
Starting my dream job…
“ A new adventure, there in your eyes. It’s just beginning, Feel your heart beat faster. Reach […]
Into the unknown, sort of
Over half of my life ago, I was looking for a job. I had written a bunch […]
Creating Azure Policy to setup Virtual Machine Auto-Shutdown
The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what […]
What’s new in T-SQL in SQL Server 2022
There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a […]
Boost productivity with ‘Solution Summary’ cards
Solution Summary cards are the name I have given to simple 1-page documents we provide to developers […]
Searching through a database via SQL
Imagine that while developing or testing a SQL Server database, you get an error message mentioning a […]
Parameterizing Azure Policy and Ensuring Azure SQL AD Authentication
I wrote before about enforcing Azure SQL AD Authentication using Azure Policies in two different ways. First, […]
Introducing the MySQL SELECT statement
The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working […]
The Job of a Technical Editor (as Louis sees it)
One of the most essential parts of producing a great technical article, blog, or even a book, […]
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 […]
Power BI: When a Power Query Native Query is not ...
In Power BI, when importing data with Power Query, one basic performance concept is the use of […]
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 […]