Daily Coping 31 Oct 2022
Today’s coping tip is to find a new perspective on a problem you face. I don’t face many big problems, but I do face lots of small ones on...
2022-10-31
17 reads
Blog Posts
Granular Cost Management for Azure Data Factory
A new feature has been launched that allows you to have more granular control over the execution costs of your pipelines. By enabling the feature, you have a cost...
2022-10-31 (first published: 2022-10-19)
434 reads
Paid Flyway Advantages–Undo and Check
The Community edition of Flyway has some nice basic features, and it works well for many people. However, it requires you to do a lot of the heavy lifting...
2022-10-31
174 reads
Production Code (T-SQL Tuesday #156)
Background
T-SQL Tuesday - the brainchild of Adam Machanic and coordinated by Steve Jones (blog|Twitter) is a monthly blog party on the second Tuesday of each month. And I will...
2022-10-31
31 reads
Returning to PASS Summit
In just a couple of weeks, the PASS Summit will return to Seattle, Washington. This one will be extra special, since it’s going to be the first in-person Summit...
2022-10-31
20 reads
Tales From The Field Weekly Wrap Up for the Week of 10-24-2022
Hello Dear Reader! This past week was an extremely fun time over at the Tales From The Field show! Fall is here, the leaves change and fall in Florida...
2022-10-31
19 reads
Weaponizing Query Store
I may have occasionally talked about the importance of Query Store, but today I want to emphasize just how much Microsoft is weaponizing query store. Of course, I don’t...
2022-10-31
14 reads
Where did this database come from??
Happy Tuesday, blog reader. Have you ever come across a database you had not seen before or was in a different naming convention than you are used to seeing?...
2022-10-31 (first published: 2022-10-18)
606 reads
A Good Cause #SeattleSummitMoments
This is another memory of the PASS Summit, this one inspired by Argenis Fernandez, who wanted to raise money for Doctors Without Borders. I wrote a bit about the...
2022-10-28
17 reads
Composite Models in PowerBI -- The solution to poor search performance in SSAS
With the release of composite models in PowerBI, Ive been able to solve a long-standing issue with SQL Server Analysis Services: text search performance. In this article I am...
2022-10-28 (first published: 2022-10-17)
324 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers