The Basics of Using GENERATE_SERIES()
First, SQL Server 2022 has many interesting new features for both DBAs and database developers. GENERATE_SERIES is one of the new additions, and will likely please a lot of database developers and administrators. This function allows us to create a tab …
Using SQLite with Flutter
Storing, retrieving, and modifying data are common tasks in many applications. In a cross-platform application, it is important to have a lightweight storage mechanism, as opposed to a heavy database software. This article explores how to use SQLite in …
Power BI Workspace Permissions and Roles
The post Power BI Workspace Permissions and Roles appeared first on SQLServerCentral.
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 …