Aggregate Functions in Power BI including Running Total, Running Average ...
The post Aggregate Functions in Power BI including Running Total, Running Average and Max appeared first on SQLServerCentral.
sqlservercentral.com
Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with ...
Before the invention of shortcuts in Microsoft Fabric, big data engineers had to create pipelines to read data […]
The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be ...
Every SQL Server developer has heard it: « Don’t use NOLOCK in production! » But this common rule isn’t as […]
Calculate a Moving Average with T-SQL Windowing Functions
The post Calculate a Moving Average with T-SQL Windowing Functions appeared first on SQLServerCentral.
JSON in PostgreSQL
Overview In this article, we will learn about JSON datatypes, functions, operators in PostgreSQL and how to use […]
An introduction to Terraform
My first exposure to Terraform was when I started to work with data in the AWS cloud. As […]
SQL IS NULL and SQL IS NOT NULL Examples
The post SQL IS NULL and SQL IS NOT NULL Examples appeared first on SQLServerCentral.
Execute Stored Procedures in the Microsoft GraphQL API
The post Execute Stored Procedures in the Microsoft GraphQL API appeared first on SQLServerCentral.
Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric
Many companies have technical debt which consists of applications and/or databases that are no longer in support or […]
A First Look at SSMS 21
This isn’t really a first look, per se. I’ve seen Erin Stellato present on this a few times […]
Announcing SQL Server 2025
This week we have announced SQL Server 2025 now available in private preview. SQL Server 2025 is an […]
How to Develop Custom T-SQL Code Snippets in Azure Data ...
To get started, follow these steps to find and use the default snippets in Azure Data Studio. In […]
Microsoft SQL announcements at PASS Data Community Summit 2024
It was an amazing week at the PASS Data Community Summit 2024 in Seattle, Washington. Microsoft made several […]
Explore Pandas in Python to Analyze and Manipulate Tabular Data
The post Explore Pandas in Python to Analyze and Manipulate Tabular Data appeared first on SQLServerCentral.
Making Temporal Databases Work, Part 3: Saving Data
The post Making Temporal Databases Work, Part 3: Saving Data appeared first on SQLServerCentral.
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Representational State Transfer (REST) is a software architectural design that has been employed throughout the software industry to create stateless web […]
Relationships with Microsoft Fabric GraphQL API
The post Relationships with Microsoft Fabric GraphQL API appeared first on SQLServerCentral.
A Tidy Database is a Fast Database: Why Index Management ...
Everyone knows that indexes make databases faster, well not everyone as I once came across a team that […]
Step by step guide to setup PostgreSQL on Docker
Introduction PostgreSQL is a powerful open-source relational database management system with robust features for handling large datasets and […]
What’s In Your Development Database? The Answer: Production Data
The post What’s In Your Development Database? The Answer: Production Data appeared first on SQLServerCentral.
The SQLskills Black Friday Super Sale!
The post The SQLskills Black Friday Super Sale! appeared first on SQLServerCentral.
Your Personal ChatGPT Tutorial
Introduction We are currently in a golden age of AI, with the emergence of large language models (LLMs) […]
Live webinar – Prioritizing security: Essential strategies for IT leaders
The post Live webinar – Prioritizing security: Essential strategies for IT leaders appeared first on SQLServerCentral.
A Guide to SQL Security in Django
The web apps we see today handle a lot of sensitive user data and this makes security of […]
Optimize SQL LIKE Wildcard Searches
The post Optimize SQL LIKE Wildcard Searches appeared first on SQLServerCentral.
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with ...
Before the invention of shortcuts in Microsoft Fabric, big data engineers had to create pipelines to read data […]
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
NEW YORK, October 29, 2024 – Timescale, the leading PostgreSQL database platform, today expanded its PostgreSQL AI offerings […]
Leveraging SQL Transaction Control in Python Applications
Transactions are the unsung heroes of data consistency/integrity in database operations. For us Python devs working with databases, […]
Audit SQL Server Extended Stored Procedures Usage
The post Audit SQL Server Extended Stored Procedures Usage appeared first on SQLServerCentral.
Microsoft at the PASS Data Community Summit 2024
Microsoft is once again excited to the be top sponsor at the PASS Data Community Summit in 2024 […]
Using a Service Account in Microsoft Fabric
The post Using a Service Account in Microsoft Fabric appeared first on SQLServerCentral.
Troubleshoot Chained SQL Server CTE
The post Troubleshoot Chained SQL Server CTE appeared first on SQLServerCentral.
The GitHub Web Platform
Introduction to the GitHub Web Platform In a previous article, we explained how to sign up for the GitHub […]
Data Lake Implementation – Data Lake Zones and Containers Planning
The post Data Lake Implementation – Data Lake Zones and Containers Planning appeared first on SQLServerCentral.
Uncover SQL Server Missing Indexes
The post Uncover SQL Server Missing Indexes appeared first on SQLServerCentral.
PASS Summit Livestream and on-demand
The post PASS Summit Livestream and on-demand appeared first on SQLServerCentral.
Use Logic Apps To Save Money In Azure: Data Engineering ...
Many companies have under provisioned lower environments since they are continuously running. What if you can turn on […]
Azure Managed Instance Download and Restore SQL Server Backup
The post Azure Managed Instance Download and Restore SQL Server Backup appeared first on SQLServerCentral.
Enhancing SQL Server Searches with Elasticsearch and Python
As a seasoned SQL developer and tech enthusiast, I often encounter scenarios where traditional SQL Server searches struggle […]
PASS Summit 2025 Dates
The post PASS Summit 2025 Dates appeared first on SQLServerCentral.
Identify CPU Intensive SQL Server Queries from an Implicit Conversion
The post Identify CPU Intensive SQL Server Queries from an Implicit Conversion appeared first on SQLServerCentral.
Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor
Join Microsoft at PASS Summit 2024 to explore the latest database innovations and how Azure solutions enhance app […]
Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, ...
The post Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star appeared first […]
How to Delete Large Amounts of Data in Microsoft SQL ...
Deleting large volumes of data in Microsoft SQL Server can be a challenging task. If not done correctly, […]
Why customers love SQL Prompt
The post Why customers love SQL Prompt appeared first on SQLServerCentral.
Exploring Time Travel and Row Level Concurrency: Data Engineering with ...
The Delta file format supports ACID properties by storing data in parquet files and actions in JSON files. […]
Casino night is back at PASS Summit 2024!
The post Casino night is back at PASS Summit 2024! appeared first on SQLServerCentral.
SQL Index Rebuild vs Reorganize Comparison
The post SQL Index Rebuild vs Reorganize Comparison appeared first on SQLServerCentral.
Converting Old Running Total Code to Window Functions
I ran across an article that showed calculating a running total with a twist. In this case, the […]
Diving Deeper into the Import Extension in Azure Data Studio
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles […]