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 […]
sqlservercentral.com
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 […]
The Mastering Azure Data Studio Series
This is the index for a series of articles on Azure Data Studio (ADS), which will help you […]
Adding Cookie Consent to SQL Server Central
To comply with various regulatory requirements, we are adding a cookie consent form to the website. You will […]
Connecting SQL Server to SaaS applications with a Linked Server
The post Connecting SQL Server to SaaS applications with a Linked Server appeared first on SQLServerCentral.
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 […]
Machine learning K-Means applied to SQL Server data
Introduction In this article, we will use K-Means applied to SQL Server using Python. We will learn what […]
New Power BI Explore this Data Feature: An Alternative to ...
The post New Power BI Explore this Data Feature: An Alternative to Excel Pivot Tables appeared first on […]
Dijkstra's Algorithm
Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of […]
SQL Window Functions Series: NTILE()
Continuing our journey through SQL’s handy window functions, we now tackle the NTILE() function. After exploring LAG(), LEAD(), […]
Kickstart the year with our free Livestream! Navigating the database ...
The post Kickstart the year with our free Livestream! Navigating the database landscape in 2024 appeared first on […]
Comparing Azure Analysis Services with On-Premises SQL Server Analysis Services
The post Comparing Azure Analysis Services with On-Premises SQL Server Analysis Services appeared first on SQLServerCentral.
Backup SQL Server on Linux Databases using SQL Server Agent ...
The post Backup SQL Server on Linux Databases using SQL Server Agent on Windows appeared first on SQLServerCentral.
The Profiler Extension in Azure Data Studio (ADS)
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]