My upcoming Online Speaking Engagements
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-05-03
4 reads
Blog Posts
Introduction to Azure Database Services
Azure SQL database is a cloud based Database as a Service provided by Microsoft Azure platform. This service is based on the traditional SQL Server(more...)
2021-05-02
14 reads
Fix The “can’t start MySQL in XAMPP” Error in a Simple Way
XAMPP is an essential support software for website administrators and programmers, but installing XAMPP is not easy. Most of the time during the installation process, users often encounter an error...
2021-05-01
15 reads
Fix The “can’t start MySQL in XAMPP” Error in a Simple Way
XAMPP is an essential support software for website administrators and programmers, but installing XAMPP is not easy. Most of the time during the installation process, users often encounter an error...
2021-05-01
815 reads
Recent updates on my work with Data Vault and Azure Data Factory
(2021-May-01) My first time working with a Data Vault modeling was in 2018, where I started and continued my journey to explore this approach or creating a scalable mechanism to...
2021-05-01
519 reads
Cool Stuff in Snowflake – Part 11: RESULT_SCAN
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2021-04-30 (first published: 2020-02-04)
495 reads
Daily Coping 30 Apr 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-30
12 reads
Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)
I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on...
2021-04-30 (first published: 2020-02-01)
383 reads
Remote Work
This is going to be the first time I’m working remotely today in over a year. I’m in Omaha, and while I’ve gone to a few cities, I haven’t...
2021-04-30
12 reads
Daily Coping 29 Apr 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-29
11 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers