[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 …