How to Optimize Power BI Semantic Model Performance with Vertipaq ...
The performance of a Power BI semantic model – formerly known as dataset – depends on a variety […]
Uncategorized
Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
The post Correct SQL Server Transactional Replication Issues with T-SQL and SSMS appeared first on SQLServerCentral.
Power BI Auto Detect Relationship Failure
In this article, we will talk about how to manually create a relationship by identifying the primary and […]
Reverse Creating the PBIP file from Source Control
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […]
Evolving Role of Data Professionals in Artificial Intelligence Era
This image is generated by Google Gemini Introduction The way we work is about to change drastically. Generative […]
What Every DBA Should Know about Always On Readable Secondaries
This article aims to demonstrate the lesser-known impact of Always On Readable secondaries. In this article, we will […]
Redgate Summit: The Database Landscape
The post Redgate Summit: The Database Landscape appeared first on SQLServerCentral.
Attention SQLBits 2024 Attendees!
Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote […]
Resolving the MERGE statement attempted to UPDATE or DELETE the ...
The post Resolving the MERGE statement attempted to UPDATE or DELETE the same row more than once error […]
Configuration of Azure SQL Database Auditing
Enhance the security, compliance, and monitoring capabilities of your database system with Azure SQL Database Auditing, a feature-rich […]
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation
When it comes to managing data in SQL Server, efficient page allocation is crucial for performance and storage […]
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like […]
Scheduling SQL Agent Jobs on Alternating Weeks
Bi-week… semi-week… fortnight… « every two weeks » Recently on the SQL Community Slack group, someone asked if there was […]
SQL Server Table Design Guidelines – Data Types, Designing for ...
The post SQL Server Table Design Guidelines – Data Types, Designing for Deletes and Primary Keys appeared first […]
Transform your Winning team into a Champion Team
Introduction The clearest illustration of the importance of a champion team occurred in the 2014 World Cup semifinal […]
What Exactly Is a CTE in T-SQL? A Comprehensive Guide ...
Background A Common Table Expression (CTE) in T-SQL is like a versatile tool in the toolbox of a […]
Integrating Python with MongoDB
Introduction MongoDB has gained significant popularity as a NoSQL database solution due to its flexibility, scalability, and document-oriented […]
Using SQLite with Flutter
Storing, retrieving, and modifying data are common tasks in many applications. In a cross-platform application, it is important […]
Microsoft Fabric: Using notebooks and table partitioning to convert files ...
When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays […]
A LEFT OUTER JOIN in SQL: What Is It?
What is a LEFT OUTER JOIN? In SQL, a LEFT OUTER JOIN is a type of join operation […]
A Beginners Guide to MySQL Replication Part 4: Using GTID-based ...
Welcome back to another replication series! As a quick reminder, we explored various methods of using MySQL’s […]
Managing Query Store Hints
I wrote about query store hints before when they were first released in Azure SQL databases. However, […]
The Hidden Impact of Microsoft Defender for Azure SQL
Recently, we received a call from a customer who was experiencing timeouts on multiple SQL Server instances. We […]
A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication
Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for […]
Let Your Data Do the Talking with PowerPoint Plus Power ...
What is this about This article will be about Power BI and PowerPoint collaborating. Both tools are well-known […]
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted ...
This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of […]
How to Find the SQL Server Version
This article explains various methods to find the SQL Server version for an instance. Knowing the SQL Server […]
Building a Kimball Data Warehouse
Introduction I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was […]
How to Filter a SQL Server Audit with a Predicate
The post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral.
MuleSoft Integration with Azure Key Vault
Introduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As […]
Microsoft Build Announcements for Data Professionals
This week was Microsoft Build. After four years, it was back in person in Seattle and available online. […]
Microsoft Fabric: Enabling your Free Trial
After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […]
How to Create a SQL Database on a New Drive ...
This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This […]
Capitalize on your investments with the new centrally managed Azure ...
Introducing the new centrally managed Azure Hybrid Benefit for SQL Server. Today, Microsoft is pleased to announce the […]
5 reasons to join us at Securely Migrate and Optimize ...
The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft […]
Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud ...
The post Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches appeared first on […]
DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Snowflake Temporary Tables vs. Transient Tables
The post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral.
Shrink Database Log Files One by One
I have about 25-30 client databases on my computer for testing purposes when I support or do new […]
How to use the SQL WHERE Clause with Examples
The post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral.
The Basics of PostgreSQL Views
Article Overview This article will help you to understand what is a database view in general and in […]
SQL Server 2022: Intel® QuickAssist Technology overview
Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced […]
PostgreSQL Basics: Object Ownership and Default Privileges
In the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) […]
A Simple Tutorial for DML Triggers
Introduction The trigger is a method provided by SQL Server to programmers and data analysts to ensure data […]
Steps to add a new disk to SQL Server failover ...
The post Steps to add a new disk to SQL Server failover cluster instance and move a user […]
PostgreSQL Temporary Table
Overview In this tutorial, we will learn about a PostgreSQL temporary table and its usage. We will study […]
Petit guide de Transact SQL – Partie 1
Des types de données aux tables temporelles… Ce petit guide est constituée de 4 parties qui vont être […]
Schedule Jobs on a Clustered SQL Server
High availability or Always On is achieved in SQL Server using Cluster. Clustering is a logical collection of […]
Privileges and Roles in SQL Server, Oracle and PostgreSQL – ...
The post Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1 appeared first on SQLServerCentral.
SQL Server 2016 CTP2 – les nouveautés à l’installation
Disponible depuis peu en téléchargement, il est désormais possible de découvrir et de s’amuser avec les nouveautés SQL […]