Daily Coping 26 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-26
39 reads
Blog Posts
Daily Coping 25 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-25
18 reads
Data is not immutable
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the hardiest data storage designed...
2022-05-25
36 reads
Logic Apps and Source Control (with PowerShell)
At a data warehouse project I’m using a couple of Logic Apps to do some lightweight data movements. For example: reading a SharePoint list and dumping the contents into...
2022-05-25 (first published: 2022-04-20)
311 reads
Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
30 reads
Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
32 reads
Techorama 2022 – Session Materials
You can find my slidedeck for the session “Introduction to Azure Data Factory” on Github:https://github.com/KoenVerbeeck/SessionMaterials All demos given in the session are explained in the ADF tutorial at MSSQLTips.com.
The...
2022-05-25
20 reads
Visualizing SQL
While I think SQL is interesting, I know some people struggle with the way the language work. Someone at work posted a link to this site: https://animatesql.com/ I think...
2022-05-25 (first published: 2022-04-18)
1,107 reads
Daily Coping 24 May 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-05-24
19 reads
New Extended Events in SQL Server 2022
SQL Server 2022 CTP is here
It has been announced today (2022-05-24) during the MS Build event. The blog post includes a download link. Unfortunately, the Docker container is...
2022-05-24
13 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Sql query to check the status change for an item
I have a table dbo.tblPresentationStatus (sql script attached - table script.txt) I have to...
Migration of on-premises SQL Server to an AWS PostgreSQL database
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers