[Video] Office Hours at the Munch Museum in Oslo
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
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
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
The post Introduction to Using Bitbucket and CI/CD for Your App appeared first on SQLServerCentral.
The pros and cons of multicloud networking
The post The pros and cons of multicloud networking appeared first on SQLServerCentral.
It’s Probably Time to Upgrade Your Cloud VMs.
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
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
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
The post AI-900: Microsoft Azure AI Fundamentals Certification Exam Tips and Tricks appeared first on SQLServerCentral.
MySQL joins
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
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
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
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
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
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 …