The Code Freeze
Today Steve discusses code freezes, those times when you don't allow changes to be made by developers.
SQL Server Plan Cache Bloat Performance Impacts
Learn about the SQL Server plan cache and how SQL Server caches query plans, and the potential of plan cache bloat which could impact performance.
Joining Queries in Azure Data Factory on Cosmos DB Sources
This article shows how you can use two Cosmos DB dataets in Azure Data Factory and join them on a common column.
Option Recompile is a Magic Turbo Button That Actually Works.
Guy Glantser is an Israeli SQL Server guru with a ton of great presentations on YouTube. I’ve had the privilege of hanging out with him in person a bunch of times over the year, and I’ll always get excited to do it again. He’s not just smart, but he’s friendly and funny as hell.
To Each Their Own
I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first Fabric Community Conference. It was a great event, well attended. BUT... It was in Las Vegas. I am not a fan. First of all, Vegas is just far too noisy for me. […]
SQL Server Patching Using PowerShell DSC
In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.
When is it time for a new job?
Steve asks the question today about when you might think about changing employers. He has some advice for you, whether you're happy or in need of a new position.
Introduction to Python including Installation, Jupyter Notebooks and Visual Studio Code
In this step-by-step article, learn how to quickly install Python and start writing Python code using Jupyter Notebooks or Visual Studio Code.
Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)
A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Alamat kantor BCA KCP Kutabumi Telp:082144477715
Wa:0821-4447-7715 Jl. Raya Kutabumi No.16-17 Blok B-18, Kutabumi, Kec. Ps. Kemis, Kabupaten Tangerang, Banten...
Alamat kantor BCA KCU GADING SERPONG Telp:082144477715
Wa:0821-4447-7715 Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster Scientia Garden No.001...
ALAMAT BCA KCU JOMBANG Telp:08218154393
WA:08218154393 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers