Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric
Before the invention of shortcuts in Microsoft Fabric, big data engineers had to create pipelines to read data from external sources such as Amazon Web Services (AWS) S3 buckets and write into Azure Data Lake Storage. This duplication of data is at ri …
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
NEW YORK, October 29, 2024 – Timescale, the leading PostgreSQL database platform, today expanded its PostgreSQL AI offerings with the launch of a groundbreaking tool, pgai Vectorizer, available open-source and hosted in the cloud. Pgai Vectorizer unloc …
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly, ran batch jobs submitted on punched cards and magnetic tape. Bu …
Who Actually Buys BrentOzar.com Training?
So you’re thinking about picking up some of my training & online services during our annual Black Friday sale, and you’re wondering – do people actually buy this stuff? During last year’s Black Friday sale, 954 folks bought …
The Countdown is On: Our Black Friday Sale Starts This Friday!
All year long, when you’re watching my Office Hours sessions, you keep hearing me say, “That topic is addressed in the X class” or “For the full answer on that, check out the Y class.” And all year long, you snarl back at …
Audit SQL Server Extended Stored Procedures Usage
The post Audit SQL Server Extended Stored Procedures Usage appeared first on SQLServerCentral.
Leveraging SQL Transaction Control in Python Applications
Transactions are the unsung heroes of data consistency/integrity in database operations. For us Python devs working with databases, understanding and implementing SQL transaction control is very important when it comes to building reliable applications …
Microsoft at the PASS Data Community Summit 2024
Microsoft is once again excited to the be top sponsor at the PASS Data Community Summit in 2024 to be held the week of November 4th at the Seattle Convention Center in the new Summit building. As with the tradition of this event, we will kickoff early …
[Video] Office Hours: Salem Witchcraft Edition
It’s spooky time again! I visited Salem, Massachusetts again this year, this time for a friend’s wedding. I ended up in the same spot next to the Charter Street Cemetery that I filmed at last year! I went through your top-voted questions fr …
MySQL Index Overviews: FULLTEXT B-Tree Indexes
If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve. We’re also big fans of database performance, too. And if you’re a developer or a DBA, you surely know one of the primary answers to dat …
Using a Service Account in Microsoft Fabric
The post Using a Service Account in Microsoft Fabric appeared first on SQLServerCentral.
[Video] Office Hours: Open Q&A About Databases
I’m back in the home office to take your database questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 03:15 Mattia Nocerino: I’ve always ignored database t-sql snapshots. What are good u …
What’s In Your Development Database? The Answer: Production Data.
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted a poll here on the blog and on a few of my social media feeds, and here were the results: Note that the numbers can add up to mo …
Troubleshoot Chained SQL Server CTE
The post Troubleshoot Chained SQL Server CTE appeared first on SQLServerCentral.
[Video] SQL Server Always On Availability Groups 101
I got a few closely related Availability Groups questions at https://pollgab.com/room/brento and decided to do a half-hour introduction to AGs: Here’s what we covered: 00:00 Start 00:24 Paul Hunter: My company decided to move to AZURE. The person …