Using Virtual Network Data Gateways to Secure Access to Azure ...
Power BI and Azure are two related services, but with a considerable independence between them. Power BI […]
simple-talk.com
Paging Data in T-SQL
Sometimes when working with very large sets of data, you may not want to return all of […]
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT […]
Are PostgreSQL memory parameters magic?
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do […]
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar […]
Why a monitoring tool is an essential tool for growing ...
When I was a DBA involved with the management of a large number of database servers, I […]
Synapse Serverless and Dedicated Pool: The differences no one told ...
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store […]
Optional Code in T-SQL Scripts using SQLCMD
When you are writing T-SQL scripts to save away, for example one to create a new database, […]
Retrieving MySQL data from within Python
Applications of all types commonly access MySQL to retrieve, add, update, or delete data. The applications might […]
Getting Out of Character
Pre-Unicode Younger programmers have grown up with ASCII and Unicode as the only ways of representing character […]
Find 40 Problems in this SQL Server Stored Procedure
I’ve been at this for a while now, and have a very particular set of rules and […]
PostgreSQL Basics: Object Ownership and Default Privileges
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) […]
Azure Machine Learning Introduction: Part 1 Overview and prep work
The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data […]
How to ask for programming help
Over the past 25 years, I have answered a lot of programming questions in online forums, from […]
Firebase and Supabase: Key differences you need to know
The tools classified as “Realtime Backend / API“, or tools that can rapidly process an API call […]
Using TOP clause in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items […]
PostgreSQL Constraints: Learning PostgreSQL with Grant
PostgreSQL supports constraints much like any other database management system. When you need to ensure certain behaviors […]
Azure Functions and Managed Identity: More Secrets
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I […]
PostgreSQL Basics: Roles and Privileges
Authentication Authorization Verify that the user is who they claim to be. This can be through password, […]
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 […]
Synapse Serverless: CETAS requires DFS to work
CETAS is the acronym for Create External Table As Select. This allow us to export the result […]
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 […]
SQL Server 2022: How Auto-Drop Statistics Work
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, […]
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 […]
What’s new on Power BI DataMarts UI
I wrote an article about Power BI Datamarts which was released together the feature, on the exact […]
Backing up MySQL Part 8: Zmanda Backups for MySQL & ...
“A Backup as Revolutionary as You Are.” Ever heard that phrase before? If you did, you’re no […]
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 […]
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 […]