Monday Monitor Tip: Compliance Checking for Old Versions
A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need...
2024-09-30
12 reads
Blog Posts
Monday Monitor Tips–Finding CUs for My Instance
How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every...
2024-09-30 (first published: 2024-09-16)
294 reads
Why CFOs Can’t Afford to Delay BI Adoption
The post Why CFOs Can’t Afford to Delay BI Adoption appeared first on Joyful Craftsmen.
2024-09-30 (first published: 2024-09-16)
296 reads
A New Word: the McFly effect
the McFly Effect – n. the phenomenon of observing your parents interact with people they grew up with, which reboots their personalities into youth mode, offering you a glimpse...
2024-09-27
16 reads
Connect to Power BI as a Guest User in another Tenant
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another tenant. This happens quite a lot when you’re a...
2024-09-27 (first published: 2024-09-19)
328 reads
Simple Talks Episode 7
The season 1, seventh episode of Simple Talks is out. Check it out, with Ryan as the main host. Simple Talks is the Redgate podcast from myself, Grant, Ryan,...
2024-09-27
12 reads
What I learned volunteering at a children's summer camp
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly moves forward, with schools starting and kids returning to their routines, the memories of the...
2024-09-27 (first published: 2024-09-13)
145 reads
Get mentored and coached by me and other industry experts!
This fall you can take the next step in your data leadership journey by joining a cohort of industry peers and get mentored by experts in the field. In...
2024-09-26
8 reads
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there and I was asked: Can You See Who Forced a Plan? I didn’t know the...
2024-09-25 (first published: 2024-09-16)
129 reads
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
50 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers