Power BI Workspace Permissions and Roles
The post Power BI Workspace Permissions and Roles appeared first on SQLServerCentral.
Archives de l’année : 2023
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 […]
First Normal Form Gets No Respect
Dr. Codd first described the relational model in a paper in Communications of the ACM (CACM 13 […]
[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 […]
Fabric: My Content compilation
Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating […]
[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 […]
SQL Server 2022 on SUSE Enterprise Linux v15 SP5 – ...
You might have already seen the post for SQL on SLES 15 SP4 release, where we announced the […]
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 […]
SQL Server Row Level Security Deep Dive. Part 6 ...
As seen in the previous section, there are several ways bad actors can attempt to bypass RLS. […]
Normalize strings to optimize space and searches
While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. […]
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 […]
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 […]
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 […]
Enterprise vs EnterpriseCore Edition for SQL Server on Linux production ...
Recently, in one of the meetings with our CSS team (support) we realized that our customers might not be […]
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 […]
T-SQL Fundamentals: Controlling Duplicates
When people start learning a new field, for example T-SQL, it’s tempting to spend very little time […]
Protect SQL Server 2014 workloads with Azure flexibility
SQL Server has brought reliability and security to mission-critical workloads for 30 years. SQL Server 2022, released November […]
[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 […]
Microsoft Fabric and the Delta Tables Secrets
Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained […]
[Video] Office Hours at Dyrhólaey Overlooking Puffins & Black Sand ...
Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I’ll answer the top-voted ones. […]
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 […]
Best practices N° 4 – configuration de l'instance SQL
Etape importante de configuration post-installation, à minima retoucher les paramètres de l’instance : Mémoire maximale Compression et checksum […]
SQL Server Row Level Security Deep Dive. Part 5 – ...
As mentioned in previous sections, RLS is an addition to security and should not be used as […]
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 […]
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 […]
Best practices N° 3 : configurer les historiques
SQL Server ne conserve par défaut que 6 archives du journal d’erreur, et l’historique des travaux de l’agent […]
Best practices N° 2 : configurer database mail, les notifications ...
Etre notifié par mail en cas de problème, c’est indispensable ! Ici, nous configurons Database Mail, étape importante […]
Analyze and Tune SQL Server Statistics
Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and […]
Best practices N° 1 : tâches de maintenance
A l’installation d’une instance SQL Server, il y a au minimum quelques « best practices » à appliquer. Cette série […]
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 […]
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 […]
Azure Data Studio 1.46 and New Features
We’re rolling towards conference season and the Azure Data Studio engineers have been working hard on two things: […]
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 […]
[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. […]
How Effective Is Your Data Load Monitoring in SQL and ...
As organizations load an increasing amount of data from different sources into their data warehouses, monitoring these data […]
GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference?
The post GPT Base, GPT-3.5 Turbo & GPT-4: What's the difference? appeared first on SQLServerCentral.
12 Office Hours Questions I Don’t Have Answers For
Hey, you! You look smart. Here are highly-upvoted questions that fellow readers submitted at https://pollgab.com/room/brento that I don’t […]
Interactive Data Analytics With PowerShell, SQL, and ChatGPT (Sample Script)
Learn about the integration of PowerShell, SQL Server data, and ChatGPT for interactive data analytics.
Alternatives To SQL-2022 Built-in function GREATEST
If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […]
Azure SQL Edge Update – September 2023
Today, I am providing an update on the supported configurations of Azure SQL Edge, the version of SQL […]
PostgreSQL 101: A guide to PostgreSQL documentation & useful resources
The post PostgreSQL 101: A guide to PostgreSQL documentation & useful resources appeared first on SQLServerCentral.
GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]
SQL Server Execution Plan Issues when using TOP Clause and ...
The post SQL Server Execution Plan Issues when using TOP Clause and Various Parameters appeared first on SQLServerCentral.
Meetup du Club Power BI, pilote de la saison 8, ...
Le 11 septembre 2023, le Club Power BI a organisé un nouveau meetup titré « Pilote de la […]
SQL Server Row Level Security Deep Dive. Part 4 – ...
One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. […]