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 […]
sqlservercentral.com
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 […]
The PASS Data Community Summit Session Schedule is LIVE!
The post The PASS Data Community Summit Session Schedule is LIVE! appeared first on SQLServerCentral.
Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server ...
The post Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes appeared first on SQLServerCentral.
Setup Excel as Front End Application for SQL Server
The post Setup Excel as Front End Application for SQL Server appeared first on SQLServerCentral.
Microsoft return to PASS Summit 2024 as Sapphire sponsor
The post Microsoft return to PASS Summit 2024 as Sapphire sponsor appeared first on SQLServerCentral.
Download AWS RDS SQL Server Backup
The post Download AWS RDS SQL Server Backup appeared first on SQLServerCentral.
How to Add a New Shared Disk to a WSFC ...
DBAs often face situations when the disk gets full for user database files, logs, or system database files. […]
Introducing the New Stars of Data speakers for PASS Summit ...
The post Introducing the New Stars of Data speakers for PASS Summit 2024 appeared first on SQLServerCentral.
Event Streams for Persistent and Asynchronous Microservice Communication
The post Event Streams for Persistent and Asynchronous Microservice Communication appeared first on SQLServerCentral.
Delta Table Performance Is Governed By Transaction Size: Data Engineering ...
Relational Databases are known for their atomic, consistent, independent and durable properties (ACID). The first version of Apache […]
GitHub Desktop Tutorial
Introduction Previously, we created a tutorial to connect Visual Studio Code with GitHub. Now, we will show another […]
Using Containers to Avoid Installing SQL Server
I got a new laptop recently and instead of installing SQL Server, I decided to try and use […]
SQL ROUND Function vs. Bankers Rounding with T-SQL
The post SQL ROUND Function vs. Bankers Rounding with T-SQL appeared first on SQLServerCentral.
I Must Be an Idiot: Automatic Tuning Never Works for ...
The post I Must Be an Idiot: Automatic Tuning Never Works for Me. appeared first on SQLServerCentral.
How to Slice Data by Fiscal Month using DAX for ...
The post How to Slice Data by Fiscal Month using DAX for Power BI Reports appeared first on […]
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
The post Microsoft Fabric: Using Lakehouse data in Real Time Dashboards appeared first on SQLServerCentral.
Is it still worth it to sponsor PASS Summit?
The post Is it still worth it to sponsor PASS Summit? appeared first on SQLServerCentral.
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
The post Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level appeared first on SQLServerCentral.
Is your DevOps strategy missing a vital link?
The post Is your DevOps strategy missing a vital link? appeared first on SQLServerCentral.