2024-08-23
28 reads
Blog Posts
Back to Syracuse for SQL Saturday
Syracuse is having their first SQL Saturday on Sept 7, 2024. I’ll be there and hope to see you there as well. If you’re anywhere close, come on over...
2024-08-22
37 reads
Don’t run CHKDSK while SQL Server is running
On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...
2024-08-21 (first published: 2024-08-09)
380 reads
Grouping by Object Type in SQL Compare
A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...
2024-08-21 (first published: 2024-08-12)
215 reads
Building Studio in Public: Maintaining High Performance in Our Local Development App for Enhanced UX
In this post, we share the strategies and techniques we've implemented to ensure our Electron-based Studio app runs smoothly, delivering a high-performance user experience.
2024-08-20
29 reads
How to Excel in Board Meetings as a CFO
The post How to Excel in Board Meetings as a CFO appeared first on Joyful Craftsmen.
2024-08-20
26 reads
Master Advanced SQL: 2 Essential Courses for Every Data Analyst
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a...
2024-08-19
214 reads
Monday Monitor Tips- Enabling Index Tracking in Redgate Monitor
There is a new index feature in Redgate Monitor, but it’s disabled by default. This post shows how to enable things. This is part of a series of posts...
2024-08-19 (first published: 2024-08-05)
146 reads
Monday Monitor Tips: Changing the Fragmentation Alert
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
44 reads
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github…
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github ActionsI recently received a request on how to Dockerize a Ruby on Rails application after...
2024-08-19
60 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
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...
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 specify only the Resource Database?
See possible answers