Things a DBA should know about SSRS
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 also written a couple of books on the topic. Over the many years of working with Microsoft SQL Server, I tend to see the same mistakes […]
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, when queries are run against it and SQL Server has to read the entire table, if you partition the table, SQL Server will read less data. […]
How to Reset the SA Password When Locked Out
Getting locked out of a SQL Server instance can happen due to a number of situations. The most common scenario I’ve encountered is when a SQL Server is moved from one domain to another without the domain being trusted or having a local SQL admin account. I recently encountered another incident where a DBA was […]
SQL Server Backups
I’ve written many blog post and articles over the years about SQL Server backups and restore options. I am constantly amazed at how often I find databases that are not being properly backed up and are critical to the organizations that utilize them. Fortunately, as organizations move to cloud solutions, things are getting slightly better. […]
Online Training Courses
Today Paul sent out the quarterly numbers to the team letting us know the hours our courses have been viewed during March. Being a data guy, I decided that after nearly 5 years of having courses available, I should crunch some numbers. I currently have 4 courses available. SQL Server: Consolidation Tactics and Best Practices […]
SQLFAMILY Folding@Home Makes Top 100 Team
Back in March 2020 Glenn Berry created the #SQLFamily Folding@Home team and many of us joined in donating compute cycles to helping find a cure for various diseases to include the COVID19 virus. Many of us felt anxious during the start of the pandemic and this helped give us something to do to help. As […]
MVP for Another Year 2021-2022
A few minutes ago, I received an email from Microsoft presenting me with the 2021-2022 Microsoft Most Valuable Professional (MVP) award. This is my 8th award and I am just as excited and amazed as I was for my first one. This award is extra special this year considering the challenges and struggles of the […]