Why customers love SQL Prompt
The post Why customers love SQL Prompt appeared first on SQLServerCentral.
sqlservercentral.com
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.
Big Northwind with AI
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking […]
SQL Local Variables and Performance Issues
The post SQL Local Variables and Performance Issues appeared first on SQLServerCentral.
Auditing SQL Server – Part 3 – SQL Server Configuration ...
The post Auditing SQL Server – Part 3 – SQL Server Configuration Audit appeared first on SQLServerCentral.
A New and Improved Data Warehouse: Data Engineering with Fabric
Microsoft Fabric is their fourth version of a Data Warehouse. Back in September of 2008, Microsoft bought DATAllegro […]
Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT
The post Reduce SQL Server Blocking with READ_COMMITTED_SNAPSHOT appeared first on SQLServerCentral.
Data Prediction with SQL Server Machine Learning Services, Python, and ...
AI is increasingly becoming part of everyday life across various domains. For the uninitiated, AI which stands for […]
10 tips for Test Data Management success
The post 10 tips for Test Data Management success appeared first on SQLServerCentral.
Recover a Database from Suspect Mode Step by Step
On 19th June 2024, the world faced a major outage. The computer on which the Windows operating system […]
SSIS in One Hour: Hands-On Tutorial
The post SSIS in One Hour: Hands-On Tutorial appeared first on SQLServerCentral.
Introducing PASS Summit Charitable Organization Scholarship
The post Introducing PASS Summit Charitable Organization Scholarship appeared first on SQLServerCentral.
Hiring in IT and Relevance of Domain Experience
We recently wanted to hire two candidates (SQL developers with around 5-10 years of experience) to join our […]
Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces
The post Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces appeared first on SQLServerCentral.
Introducing the pre-con schedule for PASS Summit 2024
The post Introducing the pre-con schedule for PASS Summit 2024 appeared first on SQLServerCentral.
Promote Simple Talks podcast episode 2: Coffee chat with Huxley ...
The post Promote Simple Talks podcast episode 2: Coffee chat with Huxley Kendell appeared first on SQLServerCentral.
Express a Number or Currency in Words with T-SQL Code
The post Express a Number or Currency in Words with T-SQL Code appeared first on SQLServerCentral.
Choosing a File Format – Data Engineering with Fabric
Microsoft Fabric has OneLake Storage at the center of all services. This storage is based upon existing Azure […]
The full agenda for the Redgate Summit New York is ...
The post The full agenda for the Redgate Summit New York is live! appeared first on SQLServerCentral.
Level up your learning in 2024 with PASS Data Community ...
The post Level up your learning in 2024 with PASS Data Community Summit appeared first on SQLServerCentral.
Create Document Templates in a SQL Server Database Table
The post Create Document Templates in a SQL Server Database Table appeared first on SQLServerCentral.
Git, GitHub and Visual Studio Code for SQL Server
Introduction This article will teach us to integrate Git, GitHub, and Visual Studio Code. Visual Studio Code (VSCode) is […]
Redgate Summit: The Database Landscape – New York
The post Redgate Summit: The Database Landscape – New York appeared first on SQLServerCentral.
Using Registered Servers in SSMS
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have […]
Getting Started with Azure CLI to Manage Azure Resources
The post Getting Started with Azure CLI to Manage Azure Resources appeared first on SQLServerCentral.
PASS Summit Futures Scholarship
The post PASS Summit Futures Scholarship appeared first on SQLServerCentral.
Getting Started With Azure Cosmos DB for PostgreSQL
Article Overview In this article we will learn about Azure Cosmos DB PostgreSQL, which is the latest addition […]
Migrate a SQL Server Database to a PostgreSQL Database
The post Migrate a SQL Server Database to a PostgreSQL Database appeared first on SQLServerCentral.