Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. The Stack Exchange network logs a lot of web traffic – even compressed, we average well over a terabyte per month. And that is just a …
Which of These Azure Courses Would You Attend?
A member of the community (no, it’s not me) is thinking about offering a live training course and wants your help to decide which of these topics are the best fit. Here are 6 $395 live online 1-day classes, and what you’d learn in each clas …
Getting Started with Power Query M Language in Excel
The post Getting Started with Power Query M Language in Excel appeared first on SQLServerCentral.
Sentiment Analysis with IA
Introduction In this article, we will do sentiment analysis of text stored in SQL Server with comments about a product and read the text with AI and detect the customer sentiments. We do this by reading text and then using AI to detect the tone of the …
PostgreSQL 101: A guide to PostgreSQL documentation & useful resources
In the latest webinar of our PostgreSQL 101 series, join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover: How to navigate PostgreSQL documentation The essential things you need to know about Post …
Profiler and Server Side Traces
The post Profiler and Server Side Traces appeared first on SQLServerCentral.
Sending Multiple Attachments in Email from Azure Data Factory Pipeline
Introduction The problem statement is to send email from Azure Data Factory Pipeline with one or more attachments to one or more Office 365 Outlook recipients. Here are the Azure Resources used: Azure Storage Account. Microsoft Documentation Link: http …
T-SQL Fundamentals: Controlling Duplicates
When people start learning a new field, for example T-SQL, it’s tempting to spend very little time trying to understand the fundamentals of the field so that you can quickly get to the advanced parts. You might think that you already understand w …
[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 …