JC Bootcamp Stories – Nikola
Od minulého roku jsme spustili náš 4-týdenní Joyful Craftsmen Bootcamp pro budoucí Data Engineers. Jedná se o intenzivní studium přímo u nás v Joyful Craftsmen HUBu, které posouvá datové...
2023-03-14
17 reads
Blog Posts
Continuing on the Journey of Azure Synapse Analytics
Azure Synapse Analytics has always enamored me. With its analytics service capabilities bridging the gap between enterprise data warehousing and Big Data analytics, it provides the end users much...
2023-03-13 (first published: 2023-03-03)
315 reads
Daily Coping 13 Mar 2023
Today’s coping tip is to start today by appreciating your body and that you’re alive. I greatly appreciate my body today. I had a long weekend, with a lot...
2023-03-13
5 reads
On the Road at SQL Bits
I may try to blog, but I know this is a busy week. I’m leaving today for England and SQL Bits. Actually I fly to London and then spend...
2023-03-13
15 reads
Reading AFAS REST API Data with Azure Logic Apps
Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process...
2023-03-13 (first published: 2023-02-26)
234 reads
Restore AWS RDS Databases On-Premises
Did you know that you can restore AWS RDS databases to a SQL Server 2022 instance running locally using native backup and restore? Well you can. Let’s talk about...
2023-03-13
27 reads
Tales From The Field Weekly Wrap Up for the Week of 03-06-2023 & Pineapple on Peperoni
Hello Dear Reader! Last week was an incredible week. We dropped new content on Monday, Tuesday had the Community Round Table, Wednesday MS Tech Bits, and released YouTube Shorts...
2023-03-13
18 reads
Adding a Computed Column–#SQLNewBlogger
Recently I needed to add a computed column to a table and realized that I didn’t remember the syntax. This short post show how to do this. Another post...
2023-03-10 (first published: 2023-03-01)
324 reads
Daily Coping 10 Mar 2023
Today’s coping tip is to notice three things you find beautiful in the outside world. I haven’t been outside a lot lately. It’s been cold and I’ve been busy...
2023-03-10
11 reads
SQL Saturday Atlanta 2023 Recap
This past weekend, I had the pleasure of attending and speaking at SQL Saturday Atlanta! If you’re in the area, I highly recommend connecting with the local user group...
2023-03-10 (first published: 2023-02-27)
155 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers