Different Ways to Populate the List of Tables
A database administrator has various tasks and responsibilities. Managing and keeping track of the database is one of them. Whether you are new or an experienced database administrator, you must know how to get the list of tables because of following …
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 No 6; June 1970). Some more work followed up after that by other people, giving us normal forms and other things we have taken for granted for 50+ years. …
[Video] Office Hours at the Arctic Circle
Just after passing the Arctic Circle marker and celebrating with a glass of champagne, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:13 TheEveryDayDBA: Does it matter on what column y …
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating an interesting sequence of content. In this blog, I’m summarizing the content I published about Fabric, helping …
[Video] Office Hours Off the Coast of Norway
Come join me in my cabin aboard the Hurtigruten Nordlys, sailing up the coast of Norway, and we’ll cover your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 00:57 Accidental DBA: What are …
Something’s Up with Parallelism in Azure SQL DB Serverless
Or perhaps another way to phrase that is, Microsoft is up to something with parallelism. I don’t know how long it’s been this way – could even be since the launch of Azure SQL DB Serverless – but I just now noticed it while help …
SQL Server Row Level Security Deep Dive. Part 6 – RLS Attack Mitigations
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. Attacks range from removing RLS, getting data from other systems or straight brute-force methods using side-channel attacks. Mechanisms exist for each potenti …
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 …