Redgate Hub

  • Product articles
  • University
  • Events
  • Forums
  • Community
  • Simple Talk
  • Home
  • Cloud
  • DevOps
  • Sysadmin
  • Development
  • Databases
  • Opinion
  • Books
  • Blogs
  • Log in
  • Sign up
  • Home
  • Databases
EzzEddin Abdullah
25 May 2022
EzzEddin Abdullah
25 May 2022

How to troubleshoot and fix PostgreSQL performance issues

0
6
  • PostgreSQL
PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.… Read more
Dennes Torres
24 May 2022
Dennes Torres
24 May 2022

Azure Synapse Link for SQL: From production to a data warehouse in a few clicks

0
2
  • BI
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.… Read more
Joe Celko
23 May 2022
Joe Celko
23 May 2022

The VALUES clause or building tables out of nothing

0
24
  • Theory and design
The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.… Read more
Lukas Vileikis
20 May 2022
Lukas Vileikis
20 May 2022

Security in MySQL: Part One

0
7
  • MySQL
There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.… Read more
Edward Pollack
11 May 2022
Edward Pollack
11 May 2022

Insights from the SSRS database

0
15
  • BI
The SSRS database contains a wealth of undocumented information that can help administrators. In this article, Edward Pollack explains how to get to the data and ways to use it.… Read more
Robert Sheldon
09 May 2022
Robert Sheldon
09 May 2022

Working with MySQL stored functions

0
3
  • MySQL
Stored functions in MySQL return a scalar value and can be used in a SQL statement. In this article, Robert Sheldon explains how to create and use a MySQL stored function.… Read more
Joe Celko
03 May 2022
Joe Celko
03 May 2022

Combinations, permutations, and derangements

0
8
  • Theory and design
Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.… Read more
Lukas Vileikis
02 May 2022
Lukas Vileikis
02 May 2022

Optimizing my.cnf for MySQL performance

0
6
  • MySQL
Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.… Read more
Edward Pollack
27 April 2022
Edward Pollack
27 April 2022

Getting results using less T-SQL

0
22
  • T-SQL Programming
There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.… Read more
Jonathan Lewis
27 April 2022
Jonathan Lewis
27 April 2022

Oracle optimizer removing or coalescing subqueries

0
2
  • Oracle
The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations involving subqueries.… Read more
Greg Larsen
21 April 2022
Greg Larsen
21 April 2022

The ins and outs of joining tables in SQL Server

0
9
  • Learn SQL Server
Most database queries require joining tables. In this article, Greg Larsen explains the ins and outs of joining tables in SQL Server.… Read more
Priyanka Chouhan
21 April 2022
Priyanka Chouhan
21 April 2022

SQL Server vulnerabilities and assessment

0
3
  • Security
SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server.… Read more
Lukas Vileikis
21 April 2022
Lukas Vileikis
21 April 2022

The nuances of MySQL indexes

0
4
  • MySQL
Indexes are critical for database performance. In this article, Lukas Vieikis explains the many types of indexes available with MySQL.… Read more
Rajeshkumar Sasidharan
20 April 2022
Rajeshkumar Sasidharan
20 April 2022

A MySQL story: Can system engineers solve database issues using system tools?

0
20
  • MySQL
A story about how a system engineer solved a MySQL performance issue written by Rajeshkumar Sasidharan.… Read more
Dennes Torres
18 April 2022
Dennes Torres
18 April 2022

How to automate table level refresh in Power BI

0
2
  • Azure
  • BI
You can automate Power BI table refreshes using PowerShell, an Automation Account, and Runbook. Dennes Torres explains how in this article.… Read more
Robert Sheldon
15 April 2022
Robert Sheldon
15 April 2022

Working with MySQL Stored Procedures

0
5
  • MySQL
MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.… Read more
Sanil Mhatre
06 April 2022
Sanil Mhatre
06 April 2022

Finding deeper insights with Topic Modeling

0
2
  • BI
  • Python
Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.… Read more
Samuel Nitsche
05 April 2022
Samuel Nitsche
05 April 2022

Why your PL/SQL needs to be testable – and how to do it: Part 1

0
3
  • Oracle
Part 1: What is testable code, why is it important, and first glimpses on practices that can help Anyone familiar with PL/SQL, the procedural language extension to Oracle SQL, knows that the code they are touching is usually business-critical, likely to be around for a long time, and may undergo many revisions in the future. … Read more
Adam Aspin
22 March 2022
Adam Aspin
22 March 2022

Tips and tricks with DAX table functions in paginated reports

0
4
  • BI
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.… Read more
Jonathan Lewis
18 March 2022
Jonathan Lewis
18 March 2022

Oracle subquery caching and subquery pushing

0
6
  • Oracle
In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery.… Read more
PreviousNext
  • 1
  • 2
  • 3
  • …
  • 72
  • MySQL
  • NoSQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • Theory and design

Subscribe for more articles

Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.

Subscribe to our fortnightly newsletter

Simple Talk

  • FAQ
  • Sitemap
  • Write for Redgate
  • Contact Us