T-SQL Tuesday #147 Invitation – Upgrade Strategies
It is time for T-SQL Tuesday #147 and this month I get to be the host. Since I’m in charge, I usually try to ensure I remember what this...
2022-02-01
25 reads
Blog Posts
Creating Azure DB for MySQL – Single Server
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
40 reads
Daily Coping 31 Jan 2022
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...
2022-01-31
13 reads
DP-900 Preparation Guide
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-01-31
50 reads
Trusting the Fine Print or connecting Azure Data Factory with Salesforce
(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...
2022-01-31 (first published: 2022-01-20)
537 reads
Two Clustered Indexes?
Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...
2022-01-31 (first published: 2022-01-18)
447 reads
Ohio North Database Training User Group Presentation 1 Feb 2022
I am looking forward to presenting to the Ohio North Database Training User Group this Tuesday, February 1st, starting at 4:00pm CST. It is exciting for me to kickoff...
2022-01-29
40 reads
CosmosDB and Consistency
I was doing a little work with CosmosDB recently, and there were a few things that surprised me about the platform. I’m also not 100% sure I completely understand...
2022-01-28 (first published: 2022-01-17)
241 reads
Daily Coping 28 Jan 2022
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...
2022-01-28
34 reads
Get SQL Server Configuration using T-SQL
As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
2022-01-28
309 reads
Blogs
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Sudirman Mansion Telpon/WA:08137887595
BCA KCP Sudirman Mansion Telpon/WA:08137887595.Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G...
BCA KCP Graha Paramita Telpon/WA:08137887595
BCA KCP Graha Paramita Telpon/WA:08137887595.Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blok D-2,...
BCA KCP Gandaria City Telpon/WA:08137887595
BCA KCP Gandaria City Telpon/WA:08137887595.Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers