Daily Coping 21 Feb 2023
Today’s coping tip is to respond kindly to everyone you talk to today. This is often easy for me. I did this last week while traveling. I got coffee...
2023-02-21
16 reads
Blog Posts
What Happens On AWS RDS?
I was talking with some developers from my team about monitoring, and I said, “We all use the same tools,” referring to other monitoring software. Then, it hit me....
2023-02-21
9 reads
Daily Coping 20 Feb 2023
Today’s coping tip is to appreciate the good qualities of someone in your life. We have a person in Redgate that does a lot of work to support our...
2023-02-20
12 reads
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions. For 2023, the deadline...
2023-02-20 (first published: 2023-02-01)
142 reads
Rotating a Certificate Used by TDE
In terms of encryption, Key Rotation is the process of replacing your encryption keys on a periodic basis. This is considered good practice and is required by many security...
2023-02-20 (first published: 2023-02-06)
293 reads
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
621 reads
Daily Coping 17 Feb 2023
Today’s coping tip is to support a local business with a positive online review or friendly message. When I discover a business I like or one that delivers value...
2023-02-17
16 reads
Using SQL Data Compare from the Command Line with a Project
SQL Data Compare (SDC) is a great way to sync data among tables. It’s a software utility analogous to SQL Compare, but working with data rather than schema. I...
2023-02-17 (first published: 2023-01-25)
746 reads
Daily Coping 16 Feb 2023
Today’s coping tip is to focus on being kind rather than being right. This is one of the things that grows my wisdom over time. I don’t need to...
2023-02-16
15 reads
Context Info Across Databases–#SQLNewBlogger
Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get...
2023-02-15 (first published: 2023-02-01)
208 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
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 Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
BCA KCP Kertopaten Telpon. 083135766741
WhatsApp 083135766741 Jl. Pegirian No.114, RT.007/RW.10, Sidodadi, Kec. Simokerto, Surabaya, Jawa Timur 60145
BCA KCP Kas Palu Barat Telp:Cs.083831618816
Whatsapp:083831618816 Jl. Sungai Malei No.35, Ujuna, Kec. Palu Bar., Kota Palu, Sulawesi Tengah 94111
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