Create Your First Pipeline in Microsoft Fabric
Introduction Microsoft Fabric is an end-to-end analytics solution that includes data lakes, data integration, data engineering, data science, real-time analytics, and business intelligence together. Currently, Fabric is in public preview. In this artic …
Who’s Hiring in the Microsoft Data Platform Community? August 2023 Edition
Is your company hiring for a database position as of August 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 inc …
Running Queries Across Many SQL Server Databases
A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on a subset of databases and to do so in a nuanced manner. Some maintenance or metrics collection processes can be simply run aga …
Installing SQL Server Integration Services
The post Installing SQL Server Integration Services appeared first on SQLServerCentral.
How to Change the SQL Server Database Owner
In SQL Server, each database has an associated owner, which is a principal that has certain permissions and control over the database. The database owner is a user or login that has been granted the dbo (database owner) user role for that database. The …
Unmasking SQL Server Dynamic Data Masking, Part 5, Mitigations and Summary
This is the fifth and final part of this series on SQL Server Dynamic Data Masking. The first part in the series was a brief introduction to dynamic data masking, completing solutions, and use cases. The second part covered setting up masking and some …
The Hidden Impact of Microsoft Defender for Azure SQL
Recently, we received a call from a customer who was experiencing timeouts on multiple SQL Server instances. We followed the standard troubleshooting steps that any DBA would take, but couldn’t identify an obvious cause. However, there were some clues: …
Best Practices for Google Cloud Security
The post Best Practices for Google Cloud Security appeared first on SQLServerCentral.
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 …