Introduction to Oracle Database for Database Professionals
Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used relational database management systems (RDBMS) in the world. Designed to manage large amounts of data, ensure reliability, and offer high-performance opera …
Granting Permissions in a Fabric Data Warehouse and Lakehouse
We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses in Fabric. We only go to the workspace level and add the user as a viewer or member. However, this is far from a good idea. This practice not only give …
[Video] Office Hours at the Petit Ermitage in LA
I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your questions from the rooftop deck of the adorable Petit Ermitage hotel. Here’s what we covered: 00:00 Start 00:37 MyTeaGotCold: When was the last time you …
Love Your Conference Sponsors
You probably already realize this, but I work for a company that sponsors conferences. As the editor of Simple Talk, I actually get some ability to influence and choose some of the conferences we sponsor, and even some kinds of event we do. For example …
MySQL Index Deep Dive: Clustered B-Tree Indexes
If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database management systems previously – in that blog, we’ve told you that indexes come in a variety of flavors including ordinary Balanced T …
Who’s Hiring in the Microsoft Data Platform Community? December 2024 Edition
Is your company hiring for a database position as of December 2024? 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 i …
Announcing the Holiday Sale
Our annual Black Friday sale is over, but we’ve got a simple sale for folks who couldn’t get in on that action. Here’s the lineup: Fundamentals AND Mastering$1,095per yearThe best value!Includes all of my Fundamentals of SQL Server an …
An introduction to Terraform
My first exposure to Terraform was when I started to work with data in the AWS cloud. As a Cloud Data Engineer I was expected to cover a wide range of infrastructure provisioning so I found myself having to learn rather more about cloud infrastructure …
SQL IS NULL and SQL IS NOT NULL Examples
The post SQL IS NULL and SQL IS NOT NULL Examples appeared first on SQLServerCentral.
Overlapping Ranges in Subsets in PostgreSQL
In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to improve their performance. We concluded by defining an overlap query in terms of timestamp ranges, which allowed us to use a new index type – …
[Video] Office Hours: Car in the Dining Room Edition
What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, and then take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Ha …
Execute Stored Procedures in the Microsoft GraphQL API
The post Execute Stored Procedures in the Microsoft GraphQL API appeared first on SQLServerCentral.
Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric
Many companies have technical debt which consists of applications and/or databases that are no longer in support or cannot be upgraded. How can we get this data in an Azure Data Lake when the size of the tables are large and there are not slowly chang …
Working with MongoDB Indexes
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Throughout this series, I’ve covered a number of topics about working with MongoDB collections and their data. One topic I have n …
Making Your Learning Plan for 2025
This week is my annual Black Friday sale, and over and over, folks buy the Fundamentals & Mastering Bundle because it’s such a good deal. But then they let it sit in their accounts. Time flies by, and next thing you know, an entire year has g …