Exporting data from a MySQL database using SELECT…INTO OUTFILE
This article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all of the items in the series, click here. In the previous article in this series, I introduced you to the MySQL LOAD DATA statement, which lets you retrieve data fro …
[Video] Office Hours: Overheating Cadillac Edition
I took your questions from https://pollgab.com/room/brento before heading out to pick up my Cadillac from the mechanic. Here’s what we covered: 00:00 Start 04:50 JudgeDredd: Hi Brent, have you ever been asked for opinion/expertise (as a database …
[Video] Office Hours: Azure SQL DB & SQL Server Questions
Post your SQL Server and Azure SQL DB questions at https://pollgab.com/room/brento and upvote the ones you’d like to hear me discuss. Here’s what we discussed in this episode: 00:00 Start 02:47 therealprodDBA: In the last webcast, I heard y …
PASS Data Community Summit 2023
The post PASS Data Community Summit 2023 appeared first on SQLServerCentral.
What is OneLake in Microsoft Fabric?
Get ready to be blown away! The highly anticipated Microsoft Build in May 2023 has finally unveiled its latest and greatest creation: the incredible Microsoft Fabric – an unparalleled Data Intelligence platform that is guaranteed to revolutionize the t …
Querying PostgreSQL: Learning PostgreSQL with Grant
Writing queries to retrieve the data from a database is probably the single most common task when it comes to working with data. Working with data in PostgreSQL is no exception. Further, PostgreSQL has an incredibly rich, wide, and varied set of mechan …
Finishing Up Your Free Azure Networking Training
To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 24: Demo: Working With a VPN July …
A Overview of Amazon Redshift
Introduction In the world of big data analytics and data warehousing, Amazon Redshift has emerged as a powerful cloud-based solution for processing and analyzing vast amounts of data. Redshift is a fully managed, petabyte-scale data warehousing service …
DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections
The post DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections appeared first on SQLServerCentral.
Exploring Parameter Sensitive Plan Optimization in SQL Server 2022
Overview of PSP Optimization PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situat …
SQL Server vs Oracle Query Statistics to Improve Performance
The post SQL Server vs Oracle Query Statistics to Improve Performance appeared first on SQLServerCentral.
PASS Data Community Summit – Early Bird price ends July 26
The post PASS Data Community Summit – Early Bird price ends July 26 appeared first on SQLServerCentral.
Optimizing Queries in MySQL: Optimizing Updates
In the previous parts of these MySQL optimization series, we’ve told you how queries work on a high level, then dived deeper into the power of SELECT and INSERT statements. In this blog, I will cover some of the ways to optimize modifying your da …
[Video] Office Hours: SO MANY Good Questions
Seriously, how do y’all keep coming up with so many great questions? I went through your top-voted questions from https://pollgab.com/room/brento/ on a live stream on my Twitch channel, like I do on most Wednesdays & Thursdays, and really enj …
[Video] Office Hours: While Stack Overflow is Down
Stack Overflow was down, so y’all posted questions at https://pollgab.com/room/brento and I gave ’em my best shot. Here’s what we covered: 00:00 Start 04:33 Amir: Does Az-900 worth the effort and money? What about other microsoft cert …