Goal of this demo: Update a Power BI model schema by adding a column to the data model without opening a PBIX file and ensure the scheduled refresh still...
2021-10-13 (first published: 2021-10-01)
110 reads
I was fortunate to present a pre-con at the PASS Summit alongside Kendra Little in 2019. That was the last in person event, and I really enjoyed the session....
2021-10-13
4 reads
Yesterday, I had about 30 existing queries (and some multi-query processes) that I needed to turn into individual stored procedures. […]
The post SQL Server meta-development (with regular expressions and...
2021-10-13
96 reads
This is the third post in the series about system-versioned ledger tables, a new feature introduced in Azure SQL Database. You can read Part 1 and Part 2 if...
2021-10-13
10 reads
I’m late, but I wanted to get this out. I started the post, then got distracted with travel to Europe late last week. In any case, this month the...
2021-10-13
15 reads
I decided to resume tech blogging after a long break and this tsql-tuesday came in handy. This month’s blog part is hosted by John McCormack (B|T). He would like...
2021-10-13
14 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
13 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
6 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
1 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
2 reads
By DataOnWheels
For anyone who read the title of this and immediately thought, “Oh no, I...
By Kevin3NF
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello everyone! We have a small group of users (4) using MS Access 2000...
The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...
I have had a server crash and although I was able to recover the...
Ask SSC