Sites anglophones


[Video] Office Hours at the Munch Museum in Oslo

Publié le 28 septembre 2023 sur brentozar.com
 

While in Norway for Data Saturday Oslo, I set up my camera gear by the Munch Museum to answer your top-voted questions from PollGab.com/room/brento. I later found out it’s pronounced ‘monk’, not ‘munch’, so there’s t …

 

Microsoft Fabric and the Delta Tables Secrets

Publié le 27 septembre 2023 sur simple-talk.com
 

Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained in my introduction to Microsoft Fabric. Either if you use lakehouses, data warehouses, or even datasets, all the data is stored in the OneLake. …

 

[Video] Office Hours at Dyrhólaey Overlooking Puffins & Black Sand Beach

Publié le 27 septembre 2023 sur brentozar.com
 

Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. This episode comes to you from Dyrhólaey, where I was completely surprised to find puffins at this time of year. Here …

Introduction to Using Bitbucket and CI/CD for Your App

Publié le 27 septembre 2023 sur sqlservercentral.com
 

The post Introduction to Using Bitbucket and CI/CD for Your App appeared first on SQLServerCentral.

The pros and cons of multicloud networking

Publié le 27 septembre 2023 sur sqlservercentral.com
 

The post The pros and cons of multicloud networking appeared first on SQLServerCentral.

It’s Probably Time to Upgrade Your Cloud VMs.

Publié le 26 septembre 2023 sur brentozar.com
 

If you’ve been in Azure or Amazon for a few years, you’re probably on old, slow hardware. In the last 3 weeks, I’ve had two clients who’d both been early cloud adopters. When they’d migrated to the cloud, they both used Az …

 

SQL Server Row Level Security Deep Dive. Part 5 – RLS Attacks

Publié le 25 septembre 2023 sur simple-talk.com
 

As mentioned in previous sections, RLS is an addition to security and should not be used as the primary method to limit access to data. It is a supplementary layer, useful in specific scenarios. There are also instances where RLS can be defeated by an …

 

Restore With Standby; A Review and A Lesson Learned

Publié le 25 septembre 2023 sur sqlservercentral.com
 

There are features of SQL Server I use often and consider to understand reasonably well, features I know but rarely use, and probably a whole list of things I’ve only looked at or used once. Within the realm of things I know, sometimes I find that I ha …

AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks

Publié le 25 septembre 2023 sur sqlservercentral.com
 

The post AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks appeared first on SQLServerCentral.

 

MySQL joins

Publié le 25 septembre 2023 sur simple-talk.com
 

Tables in a MySQL database are commonly related to one another, often in multiple ways, and it is only by linking the tables together that you can derive meaningful information from the data. To connect these tables together, you can use the JOIN claus …

 

 

Analyze and Tune SQL Server Statistics

Publié le 22 septembre 2023 sur simple-talk.com
 

Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that? Well, if we were to consider the …

 

How Would You Design This: Scheduling Classes

Publié le 22 septembre 2023 sur sqlservercentral.com
 

One of the challenges for many database developers is coming up with a good design that not only meets the specifications but also performs well in queries. Relational databases often seek some level of normalization, which reduces the update load for …

New Amazon X2iedn High-Memory Instances

Publié le 21 septembre 2023 sur brentozar.com
 

Amazon just announced new X2iedn instance types for Amazon RDS SQL Server. They’re a sweet deal for people who want a high-performance managed database, with really fast cores and more memory per core than you can get in Azure’s managed SQL …

 

Microsoft Fabric: Checking and Fixing Tables V-Order Optimization

Publié le 20 septembre 2023 sur simple-talk.com
 

Download the notebook used on this blog I explained in a previous article how the Tables in a lakehouse are V-Order optimized. We noticed this configuration depends on our settings, which can be enabled or not. One question remains: How could we check …

 

[Video] Office Hours at Svínafellsjökull Glacier in Iceland

Publié le 20 septembre 2023 sur brentozar.com
 

Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. This episode comes to you from the most hike-friendly glacier in Iceland, one where you can park your car and step onto th …


Pages :