Quick and Effective Migration Between CosmosDB Collections Using ADF
This document aims to explain the process of using ADF (Azure data Factory) to make a copy of […]
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 […]
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Managed Vs Unmanaged Tables Microsoft Fabric was released as general availability on November 15th, 2023. I will be […]
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.
Find Unused or Backup Tables
In this article, I am going to demonstrate how we can identify the unused tables of a given […]
The difference between BIN2 and Case-Sensitive collations in SQL
A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally […]
SQL Server to PostgreSQL Database Schema Conversion
The post SQL Server to PostgreSQL Database Schema Conversion appeared first on SQLServerCentral.
Will AI end with SQL, Is this the end of ...
Introduction to the End of SQL Will the AI end with SQL? That is the question. The AI […]
Why Test-Driven Development? (Part 2)
The post Why Test-Driven Development? (Part 2) appeared first on SQLServerCentral.
SSRS 2022 Install, Setup and Configuration
The post SSRS 2022 Install, Setup and Configuration 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 […]
Dynamically Move Multiple Tables in Bulk using Azure Data Factory ...
The post Dynamically Move Multiple Tables in Bulk using Azure Data Factory ForEach and Lookup Activities appeared first […]
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 […]
Live webinar: How to excel at managing multiple database platforms
The use of multiple database platforms is on the rise, however, managing them can be challenging, with issues […]
A Few Best Practices for Strong SQL Server Security
Databases serve as the critical infrastructure for numerous applications. They safeguard essential data that fuels both business operations […]
SQL Server Clustered Index Seek Operation Generates Poor Query Performance
The post SQL Server Clustered Index Seek Operation Generates Poor Query Performance appeared first on SQLServerCentral.
“As DBAs, should we be worried about our jobs because ...
The post “As DBAs, should we be worried about our jobs because of AI?” and other burning questions […]
Add Additional Nodes to SQL Server 2022 and Windows Server ...
The post Add Additional Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster – Part 3 […]
Meet Claude, the new AI
Introduction to Claude This time we will meet Claude, a new AI technology. Previously, we talk about ChatGPT, […]
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.
Dynamically Create Tables in Power BI with DAX Functions
The post Dynamically Create Tables in Power BI with DAX Functions appeared first on SQLServerCentral.
Forget the Models, Your Data is the Secret Sauce for ...
Credit: Image generated by Google Bard Generative AI (GenAI) models like GPT, Gemini, PaLM, DALL-E, and others offer […]
Tutorial: Using the hierarchyid Data Type
The post Tutorial: Using the hierarchyid Data Type appeared first on SQLServerCentral.
JQ – Tool for Querying JSON documents using the CLI
In my role as a Data Engineer, I have an ever-increasing need for Querying JSON documents using the […]
Attention SQLBits 2024 Attendees!
Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote […]
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, ...
The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on […]
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting […]
Planning a Database Testing Strategy for Flyway
The post Planning a Database Testing Strategy for Flyway appeared first on SQLServerCentral.
Fun with Powershell
The post Fun with Powershell appeared first on SQLServerCentral.
Use a Table Variable for Logging Entries that Need to ...
Introduction Table variables are special types of local variables that can be used to store data temporarily, similar […]
LangChain Prompt Templates with OpenAI LLMs
The post LangChain Prompt Templates with OpenAI LLMs appeared first on SQLServerCentral.
Dimensional Modeling Case Study Part 2 – Days Dimension
Introduction In our second case study on dimensional modelling, we delve into the intricacies of managing time-related dimensions, […]
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 […]
Announcing the first Microsoft Fabric Community Conference!
We are excited to welcome attendees to the 1st Microsoft Fabric Community Conference (previously known as the Data […]
Fixing the Synapse Error « Available workspace capacity exceeded error (Livy ...
If you are working with Notebooks in Azure Synapse Analytics and multiple people are using the same Spark […]
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets […]
Adding an AI Policy for Authors
In the last few months, we’ve noticed quite a bit of content submitted that seems overly structured in […]
Install SSMS using Powershell DSC
Introduction In the previous article, we have seen how to install the SQL Server database engine using Powershell […]
Gracefully Handle Errors using TRY CATCH Logic in SQL Server ...
The post Gracefully Handle Errors using TRY CATCH Logic in SQL Server Stored Procedures appeared first on SQLServerCentral.
Server Dashboards in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]
State of the Database Landscape 2024: Shifting skills to match ...
The post State of the Database Landscape 2024: Shifting skills to match constant demands appeared first on SQLServerCentral.
Django's ORM vs. Raw SQL: When to Use Which
When it comes to building websites, how you work with your database can make a huge difference in […]
Code Visibility: Browsing through Flyway Migration Files
The post Code Visibility: Browsing through Flyway Migration Files appeared first on SQLServerCentral.
Understanding the Importance of Data Lineage in Modern Data Management
The post Understanding the Importance of Data Lineage in Modern Data Management appeared first on SQLServerCentral.
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 […]
Buy on-demand access for Summit 2023 today
The post Buy on-demand access for Summit 2023 today appeared first on SQLServerCentral.
Leveraging AI Tools for SQL Queries
Some of the many benefits that AI offers include task automation, increased productivity, and increased efficiency. As an […]
A Simple Method to Load Excel Data
Problem When we need to load data from Excel sheets to a SQL Server table, we typically use […]
Dimensional Modelling Case Study Part 1 – Age Group
Background Age plays an important role in medicine and medical research. A patient’s ages is commonly grouped into […]