Creating a “Real” Copy of a View: #SQLNewBlogger
I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table....
2024-12-23 (first published: 2024-12-11)
632 reads
Blog Posts
Microsoft Fabric Training and Tutorials
Microsoft Fabric is the new data offering in Microsoft Azure and there is a great deal of interest in it. How do you get started? Where are the tutorials?
2024-12-23 (first published: 2024-04-29)
777 reads
A New Word: Suente
suente– n. the state of being so familiar with someone that you can be in a room with them without thinking, without holding anything back, or without having to...
2024-12-20
21 reads
Data Strategy Checklist for 2025
The post Data Strategy Checklist for 2025 appeared first on Joyful Craftsmen.
2024-12-20 (first published: 2024-12-16)
379 reads
Grinding Away: Brent Ozar
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...
2024-12-20 (first published: 2024-12-09)
623 reads
My 2024 in Data: Music
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-20
18 reads
My 2024 in Data: Health and Workouts
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-19
7 reads
My 2024 in Data: Reading
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-18
19 reads
Ways to land data into Fabric OneLake
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as its central data storage hub for all Fabric-integrated products. A variety of tools and methods...
2024-12-18 (first published: 2024-12-12)
459 reads
My 2024 in Data: Speaking
This is my last week of the year working (I guess I come back on the 30th for a minute), so I decided to do some analysis of my...
2024-12-17
16 reads
Blogs
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...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
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