Daily Coping 26 Oct 2021
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-10-26
15 reads
Blog Posts
#PowershellBasics: Adding data to a string using subexpressions.
I’m working on a project right now where I want to add the date/time to the end of a filename. ... Continue reading
2021-10-25 (first published: 2021-10-14)
272 reads
Daily Coping 25 Oct 2021
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-10-25
118 reads
Power BI, Maps, and Publish to Web
October 2021 is mapping month over at Workout Wednesday for Power BI. As part of our challenges, we build a sample report and use the Publish to Web functionality...
2021-10-25 (first published: 2021-10-14)
495 reads
3 Important Queries for Testing Your Availability Group Endpoints
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-22 (first published: 2021-10-12)
662 reads
A New Form of Address: Mx
When I was presenting at the dataMinds Connect conference, I called on someone in the audience. At the time, I called on someone raising their hand and said something...
2021-10-22
153 reads
Daily Coping 22 Oct 2021
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-10-22
22 reads
Do Full Backups Break Log Shipping?
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs,...
2021-10-22 (first published: 2021-10-15)
321 reads
Daily Coping 21 Oct 2021
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-10-21
42 reads
Azure Purview is generally available
After a very long public preview (9 months), Azure Purview is finally generally available (GA). I described Purview in a previous blog (New Microsoft data governance product: Azure Purview)....
2021-10-20 (first published: 2021-10-05)
410 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers