Sites anglophones


Oracle optimizer removing or coalescing subqueries

Publié le 25 mai 2022 sur sqlservercentral.com
 

The post Oracle optimizer removing or coalescing subqueries appeared first on SQLServerCentral.

 

Azure Synapse Link for SQL: From production to a data warehouse in a few clicks

Publié le 24 mai 2022 sur simple-talk.com
 

The Link technology in Synapse is used to synchronize data from different data sources to Synapse Analytics. Synapse Link for CosmoDB and Synapse Link for Dataverse were already released. Now it’s time for a new and very important one: Azure Syna …

 

Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)

Publié le 24 mai 2022 sur brentozar.com
 

These days, BrentOzar.com mostly focuses on the Microsoft data platform. However, you and I have a relationship, dear reader, so I just need to talk about some personal stuff today. Lemme get two things out of the way first: I’m pansexual, and Fr …

 

The VALUES clause or building tables out of nothing

Publié le 23 mai 2022 sur simple-talk.com
 

The VALUES clause is probably one of the most misused features in SQL. If you look at SQL forums online, you’ll see people use it as the second clause in an insertion statement, but they only use it to construct a single row at a time, thus: BEGI …

 

 

Power BI: When a Power Query Native Query is not enough

Publié le 23 mai 2022 sur simple-talk.com
 

In Power BI, when importing data with Power Query, one basic performance concept is the use of native queries. The transformations will perform better if they can be converted to a native query, especially a single native query for all transformations. …

 

Never been to a SQL Server training class? Let’s fix that.

Publié le 23 mai 2022 sur brentozar.com
 

You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes …

Getting results using less T-SQL

Publié le 23 mai 2022 sur sqlservercentral.com
 

The post Getting results using less T-SQL appeared first on SQLServerCentral.

How to use Images in Power BI Report Builder

Publié le 23 mai 2022 sur sqlservercentral.com
 

Introduction This article will teach you how to use images in Power BI Report Builder. Previously, we show how to work with Power BI Report Builder. In this article, we will show how to add images to the report. We will work with simple embedded images …

Database DevOps: Standardize, Automate, Monitor & Protect

Publié le 23 mai 2022 sur sqlservercentral.com
 

The post Database DevOps: Standardize, Automate, Monitor & Protect appeared first on SQLServerCentral.

 

Security in MySQL: Part One

Publié le 20 mai 2022 sur simple-talk.com
 

Security is a critical part of any infrastructure – it’s even more so in the database world, where one step in the wrong direction can be the cause of system disruptions and downtime, customer dissatisfaction, and in the worst-case scenario …

 

Flyway and Simple Source Control

Publié le 20 mai 2022 sur sqlservercentral.com
 

The post Flyway and Simple Source Control appeared first on SQLServerCentral.

Change Management and Leadership Alignment

Publié le 20 mai 2022 sur sqlservercentral.com
 

The post Change Management and Leadership Alignment appeared first on SQLServerCentral.

[Video] Office Hours: Cabo Balcony Edition

Publié le 19 mai 2022 sur brentozar.com
 

Post your questions at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing …

SQL Server vulnerabilities and assessment

Publié le 18 mai 2022 sur sqlservercentral.com
 

The post SQL Server vulnerabilities and assessment appeared first on SQLServerCentral.

[Re-post] Tackling the Challenges of Hybrid Estates

Publié le 18 mai 2022 sur sqlservercentral.com
 

The post [Re-post] Tackling the Challenges of Hybrid Estates appeared first on SQLServerCentral.


Pages :