Why You Should Test Your SQL Server Backups
My number one reason that you should test your backups is to make sure you know how to restore/recover. The absolute worst time to learn how to restore is...
2023-07-10
7 reads
Tim Radney
Why Aren’t You Monitoring SQL Server
I repeat the phrase “If you aren’t monitoring it, you can’t measure it” all the time. Through my IT career, this has been a constant. If you don’t have...
2023-06-14
1 reads
Stop Using Balanced Power with SQL Server
The OS default Power Plan for Windows is Balanced Power. This can cause degraded overall performance for SQL Server. Balanced Power is a great concept to help conserve energy...
2023-05-16
5 reads
Reasons Why SQL Servers Don’t Get Configured to Industry Best Practices
Throughout my career, I’ve worked on a LOT of different SQL Servers. Many that were installed and configured by application administrators, developers, vendors, and data professionals. I’ve seen servers...
2023-04-11
3 reads
Children at Technical Conferences Part II
Nearly 10 years ago I wrote a blog post about having my son tag along at various conferences I was speaking at. So much has changed in the past...
2023-03-22 (first published: 2023-03-13)
213 reads
Microsoft SQL Server Management Studio Error
I came across an issue with SSMS not loading properly recently. Regardless of launching from the start menu with or without administrator, SSMS would error out. Due to this...
2023-01-18 (first published: 2023-01-09)
499 reads
SQL Server 2022 is Here!
SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting. A major Azure-enabled...
2022-11-17
9 reads
SSRS Management for the DBA
Things a DBA should know about SSRS
The post SSRS Management for the DBA appeared first on Tim Radney.
2022-09-13
16 reads
Common Issues with SQL Server Backups
I absolutely love talking about SQL Server backup and restores. It is one of my favorite sessions to give at user groups and conferences all over the world. I’ve...
2022-08-08
16 reads
SQL Server Partitioning for Performance
Often enough I get questions regarding partitioning to try to help alleviate performance issues with very large tables. A common misconception is that due to the table being large,...
2022-07-12
35 reads
Blogs
Friday Flyway Tips: State-based deployment with Flyway Teams
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Advice I Like: The Main Thing
By Steve Jones
The main thing is to keep the main thing the main thing. – from...
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
ExecutionLog3 table in Reportserver Database
I have a SSRS report for which users are complaining to be slow, but...
SQL Server Maintenance Plan Feedback
Hi I set this up today. I wanted to get some feedback. I have...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers