It’s time for the T-SQL Tuesday blog party, and I’m hosting this month. I don’t host too often, but since I had some schedule mix ups, I’ll handle this...
2021-04-12 (first published: 2021-04-06)
327 reads
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...
2021-04-12
16 reads
While XML is, without a doubt, a giant pain in the bottom, sometimes, the best way to deal with Extended Events is to simply embrace the XML. Now, I...
2021-04-12 (first published: 2021-04-05)
230 reads
An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...
2021-04-12
15 reads
Transparent Data Encryption (TDE) is one of the easiest ways of encrypting your data at rest. In my prevous post we looked at what TDE is and how it...
2021-04-12
278 reads
Being aligned to a global cloud like Microsoft Azure you have choices. Whether that is Azure SQL Database or Azure Database for MySQL for your relational database, it does not matter...
2021-04-12
14 reads
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...
2021-04-09
14 reads
I started a poll today on the naming for future SQL Saturdays. You can answer here: https://twitter.com/way0utwest/status/1380524526455390209 The current votes (51 votes) look like this: That’s interesting, as I...
2021-04-09
17 reads
A few of my colleagues can relate with the title of this article, they might have experienced an issue with the database in production. Dear colleague, you are not...
2021-04-09 (first published: 2021-04-03)
866 reads
I’m pleased to announce that I have selected an initial board of directors for the SQL Saturday Foundation. I’m honored to be a part of this group: Andy Warren ...
2021-04-09 (first published: 2021-04-02)
233 reads
I was asked to do a review of the book Microsoft Power BI Performance...
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Comments posted to this topic are about the item A Strange Result
First time here...hoping I can find some direction and answers so I can devise...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers