Disaster Recovery and High Availability Solutions in SQL ServerWhen managing a database, ensuring data availability and integrity is paramount, especially in the face of hardware failures, […] 15 avril 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL EnthusiastsIntroduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […] 12 avril 2024 dans Sites anglophones étiqueté #sql interview questions / Advanced SQL / Azure SQL / BI / Data / Database / SQL Script / Uncategorized par sqlservercentral.com
SQL Server Patching Using PowerShell DSCIntroduction In the previous article we have seen how to install SQL Server Management Studio (SSMS) using PowerShell […] 5 avril 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 22 mars 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Correct SQL Server Transactional Replication Issues with T-SQL and SSMSThe post Correct SQL Server Transactional Replication Issues with T-SQL and SSMS appeared first on SQLServerCentral. 18 mars 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Power BI Auto Detect Relationship FailureIn this article, we will talk about how to manually create a relationship by identifying the primary and […] 8 mars 2024 dans Sites anglophones étiqueté Cardinalities / Data Joins / Data Modeling / Power BI / Uncategorized par sqlservercentral.com
Reverse Creating the PBIP file from Source ControlOn my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to […] 6 mars 2024 dans Sites anglophones étiqueté Blogs / Git / Microsoft Fabric / Power BI / Source Control / Uncategorized par simple-talk.com
Evolving Role of Data Professionals in Artificial Intelligence EraThis image is generated by Google Gemini Introduction The way we work is about to change drastically. Generative […] 4 mars 2024 dans Sites anglophones étiqueté AI / Artificial Intelligence / data engineering / generative ai / LLM / RAG / Retrieval Augmented Generation / Uncategorized par sqlservercentral.com
What Every DBA Should Know about Always On Readable SecondariesThis article aims to demonstrate the lesser-known impact of Always On Readable secondaries. In this article, we will […] 23 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Redgate Summit: The Database LandscapeThe post Redgate Summit: The Database Landscape appeared first on SQLServerCentral. 23 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Attention SQLBits 2024 Attendees!Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote […] 14 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 5 février 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Configuration of Azure SQL Database AuditingEnhance the security, compliance, and monitoring capabilities of your database system with Azure SQL Database Auditing, a feature-rich […] 22 janvier 2024 dans Sites anglophones étiqueté azure database / azure database auditing / azure sql server / sql server auditing / Uncategorized par sqlservercentral.com
An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page AllocationWhen it comes to managing data in SQL Server, efficient page allocation is crucial for performance and storage […] 10 janvier 2024 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Advanced SQL Server installation using Powershell DSCIntroduction In the previous article, we learned how to install a SQL Server instance with basic parameters like […] 22 novembre 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Scheduling SQL Agent Jobs on Alternating WeeksBi-week… semi-week… fortnight… « every two weeks » Recently on the SQL Community Slack group, someone asked if there was […] 17 novembre 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 15 novembre 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Transform your Winning team into a Champion TeamIntroduction The clearest illustration of the importance of a champion team occurred in the 2014 World Cup semifinal […] 23 octobre 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 20 octobre 2023 dans Sites anglophones étiqueté CTE / TSQL / Uncategorized par sqlservercentral.com
Integrating Python with MongoDBIntroduction MongoDB has gained significant popularity as a NoSQL database solution due to its flexibility, scalability, and document-oriented […] 13 octobre 2023 dans Sites anglophones étiqueté JSON / MongoDB / NoSQL / Python / Uncategorized par sqlservercentral.com
Using SQLite with FlutterStoring, retrieving, and modifying data are common tasks in many applications. In a cross-platform application, it is important […] 6 octobre 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 13 septembre 2023 dans Sites anglophones étiqueté Data Lake / data platform / lakehouse / Microsoft Fabric / notebook / Power BI / Uncategorized par simple-talk.com
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 […] 18 août 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 8 août 2023 dans Sites anglophones étiqueté Blogs / Uncategorized par simple-talk.com
Managing Query Store HintsI wrote about query store hints before when they were first released in Azure SQL databases. However, […] 2 août 2023 dans Sites anglophones étiqueté Blogs / query optimization / Query Store / SQL Server 2022 / Uncategorized par simple-talk.com
The Hidden Impact of Microsoft Defender for Azure SQLRecently, we received a call from a customer who was experiencing timeouts on multiple SQL Server instances. We […] 28 juillet 2023 dans Sites anglophones étiqueté Cloud Performance Testing / cloud security / Uncategorized par sqlservercentral.com
A Beginners Guide to MySQL Replication Part 3: Multi-Source ReplicationWelcome back to the world of MySQL Replication! If you’ve been following this series, thank you for […] 18 juillet 2023 dans Sites anglophones étiqueté Blogs / MySQL / Uncategorized par simple-talk.com
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 […] 12 juillet 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 27 juin 2023 dans Sites anglophones étiqueté BenJohnston_DynamicDataMasking / Uncategorized par simple-talk.com
How to Find the SQL Server VersionThis article explains various methods to find the SQL Server version for an instance. Knowing the SQL Server […] 23 juin 2023 dans Sites anglophones étiqueté #sql server interview questions / Database Administration / Microsoft SQL Server / SQL Script / sqlcmd / Uncategorized par sqlservercentral.com
Building a Kimball Data WarehouseIntroduction I sat through a YouTube webinar on Data Lakes, and I’ll have to admit that it was […] 14 juin 2023 dans Sites anglophones étiqueté Data Warehouse / Uncategorized par sqlservercentral.com
How to Filter a SQL Server Audit with a PredicateThe post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral. 5 juin 2023 dans Sites anglophones étiqueté SQL Server / Uncategorized par sqlservercentral.com
MuleSoft Integration with Azure Key VaultIntroduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As […] 2 juin 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Microsoft Build Announcements for Data ProfessionalsThis week was Microsoft Build. After four years, it was back in person in Seattle and available online. […] 26 mai 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Microsoft Fabric: Enabling your Free TrialAfter the great announcement of Microsoft Fabric this week, it’s time to get a trial and start […] 24 mai 2023 dans Sites anglophones étiqueté Data Warehouse / lakehouse / Microsoft Fabric / Power BI / Synapse / Uncategorized par simple-talk.com
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 […] 10 mai 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 26 avril 2023 dans Sites Microsoft étiqueté Uncategorized par SQL Server Blog
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 […] 13 avril 2023 dans Sites Microsoft étiqueté Uncategorized par SQL Server Blog
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 […] 7 avril 2023 dans Sites anglophones étiqueté cloud analytics / Cloud Data Management / elt / Uncategorized par sqlservercentral.com
DAX CASE Statement Functionality with IF, SWITCH and SWITCH TrueThe post DAX CASE Statement Functionality with IF, SWITCH and SWITCH True appeared first on SQLServerCentral. 3 avril 2023 dans Sites anglophones étiqueté CASE Equivalent / DAX / t-sql / Uncategorized par sqlservercentral.com
Snowflake Temporary Tables vs. Transient TablesThe post Snowflake Temporary Tables vs. Transient Tables appeared first on SQLServerCentral. 31 mars 2023 dans Sites anglophones étiqueté snowflake / tables / Uncategorized par sqlservercentral.com
Shrink Database Log Files One by OneI have about 25-30 client databases on my computer for testing purposes when I support or do new […] 31 mars 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
How to use the SQL WHERE Clause with ExamplesThe post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral. 27 mars 2023 dans Sites anglophones étiqueté MS SQL Server / Uncategorized par sqlservercentral.com
The Basics of PostgreSQL ViewsArticle Overview This article will help you to understand what is a database view in general and in […] 17 mars 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
SQL Server 2022: Intel® QuickAssist Technology overviewPart of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced […] 9 mars 2023 dans Sites Microsoft étiqueté SQL Server 2022 Blogging Series / Uncategorized par SQL Server Blog
PostgreSQL Basics: Object Ownership and Default PrivilegesIn the first security article, PostgreSQL Basics: Roles and Privileges, I discussed how roles (users and groups) […] 21 février 2023 dans Sites anglophones étiqueté Homepage / PlanetPostgresqlRyanBooz / PostGreSQL / Uncategorized par simple-talk.com
A Simple Tutorial for DML TriggersIntroduction The trigger is a method provided by SQL Server to programmers and data analysts to ensure data […] 15 février 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
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 […] 10 février 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
PostgreSQL Temporary TableOverview In this tutorial, we will learn about a PostgreSQL temporary table and its usage. We will study […] 10 février 2023 dans Sites anglophones étiqueté Uncategorized par sqlservercentral.com
Petit guide de Transact SQL – Partie 1Des types de données aux tables temporelles… Ce petit guide est constituée de 4 parties qui vont être […] 9 février 2023 dans Sites francophones étiqueté auto-incréments / clonage d'une base / CREATE OR ALTER / historisation des données / identity / instantané de bases de données / Sécurité au niveau ligne / sequence / SQL Server / tables temporaires / tables temporelles / Transact SQL / type de données / Uncategorized / variables / vues indexées par mssqlserver.fr