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
11 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
12 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
806 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)
493 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
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers