Sites anglophones


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.

[Video] Office Hours: Cabo Pool Edition

Publié le 17 mai 2022 sur brentozar.com
 

You posted SQL Server  questions and upvoted the ones you’d like to see at https://pollgab.com/room/brento, and before the Cabo Clasico finals start for the day, I sat by the pool to talk through ’em: Here’s what we covered: 00:0 …

I’m Speaking at the PASS Data Community Summit This Year!

Publié le 16 mai 2022 sur brentozar.com
 

For years, the biggest conference in the Microsoft data platform community has been the PASS Summit. This November 15-18, it’s coming back to the Seattle Convention Center. You can attend in person, or virtually. I’m going to be there in pe …

The nuances of MySQL indexes

Publié le 16 mai 2022 sur sqlservercentral.com
 

The post The nuances of MySQL indexes appeared first on SQLServerCentral.

Webinar: Introducing Database DevOps

Publié le 16 mai 2022 sur sqlservercentral.com
 

The post Webinar: Introducing Database DevOps appeared first on SQLServerCentral.

Power BI Report Builder Introduction

Publié le 16 mai 2022 sur sqlservercentral.com
 

Power BI Report Builder is a great tool to generate paginated reports. In a previous article, we mentioned that Power BI was an excellent tool to visualize data, but it is not the best tool to print reports and export the information to different forma …

 

Indexing for Delete – SQL in Sixty Seconds #197

Publié le 13 mai 2022 sur journey to sqlauthority
 

In Comprehensive Database Performance Health Check, I often discuss that indexes can reduce the performance of your system big time. Many still think that indexes are good for a SELECT statement but that is not true and I have previously created a vide …

 

The ins and outs of joining tables in SQL Server

Publié le 13 mai 2022 sur sqlservercentral.com
 

The post The ins and outs of joining tables in SQL Server appeared first on SQLServerCentral.

The Script Activity in Azure Data Factory

Publié le 13 mai 2022 sur sqlservercentral.com
 

Introduction Azure Data Factory recently introduced a new activity, called the Script activity. We can use the Script activity to execute DML (Data Manipulation Language) statements like SELECT, INSERT, UPDATE, as well as DDL (Data Definition Language) …

Summit Learning Pathways Announced

Publié le 13 mai 2022 sur sqlservercentral.com
 

The post Summit Learning Pathways Announced appeared first on SQLServerCentral.

 

Creating unique datasets with managed code

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

Figuring out uniqueness in large datasets is somewhat trivial in SQL via the DISTINCT statement. This DISTINCT technique, however, puts a load on the SQL box to where it is more beneficial to scale out horizontally in managed code instead. Typically, i …

 

The 6-Year-Old T-SQL Book That Never Goes Out of Style

Publié le 12 mai 2022 sur brentozar.com
 

You’ve been working with Microsoft SQL Server for yeeears, and you’re pretty confident that you know how to write a query. So when I tell you about a book called T-SQL Fundamentals, you’re all, “nah, man, I got this covered. …


Pages :