[Video] Office Hours: Let’s Have a Drink
I was making myself a drink to film Office Hours and I realized I should just film it in my home bar. I mixed myself a gin & tonic and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we discussed: 00:00 Start 0 …
T-SQL Notebooks: Manage Views Source Control and more
T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss the fact this is a new feature at all. Yes, it is. Notebooks were capable to support Spark SQL, but T-SQL is something new. The main examples bein …
Launch Day Bonus: Free Stuff on Friday
Our annual Black Friday sale launches this Friday and runs all month. For those of you who are early birds, the folks who move quickly when the sales open on Friday, I’ve got a special bonus for you. The first 100 buyers can use coupon code Early …
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 …