The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of crite …
Recording What’s Changed when Running Oracle Migrations with Flyway
The post Recording What’s Changed when Running Oracle Migrations with Flyway appeared first on SQLServerCentral.
[Video] Office Hours at Sea: Heading to Jamaica
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) off the coast of Florida to answer questions y’all posted at https://pollgab.com/room/brento. 00:00 Start 00:56 DBe: In several places I’ve w …
Are PostgreSQL memory parameters magic?
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. There is a good reason for such …
Better Keep Up: More Free PowerShell Videos This Week.
We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough time because your work schedule is so busy and you can’t make 30 minutes of free time? Hey, maybe that’s because you’re a p …
How to Install the AdventureWorks Sample Database in Azure SQL Database
The post How to Install the AdventureWorks Sample Database in Azure SQL Database appeared first on SQLServerCentral.
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, schema, and data stored in the underlying tables of any database. This article will teach us how to identify invalid or broken object …
On-Demand Webinar – Monitoring: The ROI of Build vs. Buy
The post On-Demand Webinar – Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Implement CI/CD in Azure Data Factory (ADF)
Continuous Integration and Continuous Deployment (CI/CD) are integral parts of the software development lifecycle. As a Data Engineer/ Data Professional when we build the ETL pipeline using Azure Data Factory (ADF), we need to move our code from a Deve …
SELECT DISTINCT SQL Command to Return a Unique List of Values
The post SELECT DISTINCT SQL Command to Return a Unique List of Values appeared first on SQLServerCentral.
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 table with data from an events table (part 1 and part 2). This technique could be used to overlay any type of data onto calendars, but my specific go …
Do you need Trace Flag 460?
For most people that are reading this post, I’d venture to guess that you have no idea what Trace Flag 460 is or when you would use it. Well first off, let me tell you it’s a fully documented and supported trace flag, and it’s totally …
Who’s Hiring in the Microsoft Data Platform Community? March 2023 Edition
Is your company hiring for a database position as of March 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must incl …
Complex Production Database Deployments and Flyway
The post Complex Production Database Deployments and Flyway appeared first on SQLServerCentral.
AWS Lambdas with C#
The post AWS Lambdas with C# appeared first on SQLServerCentral.