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 error, I also could not uninstall SSMS to try a repair. After much trial and error and Google/Bing searches I was able to correct the issue […]
Tag: sql server
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. […]
MVP for Another Year 2020-2021
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021 Microsoft Most Valuable Professional (MVP) award. This is my 7th award and I am just as excited and amazed as I was for my first one. There are so many others in the community that give their time to help others […]
T-SQL Tuesday #126 – Folding@Home and 3D Printing
This month’s T-SQL Tuesday is hosted by my friend Glenn Berry. Glenn invites us to write about what we have been doing as a response to COVID-19. Glenn shared how he has been dedicating his lab machines to Folding@Home to help understand the COVID19 virus. Glenn with his hardware background has been geeking out on […]
Understanding Database Fundamentals (98-364)
Kind of proud about this accomplishment. I get asked all the time at user groups and SQL Saturday events, “How can I get started with SQL Server”. There is tons of training out there on SQL Server, but most of it assumes you have a basic understanding of it, or have been working with it […]
SQL Saturday Louisville
Are you coming to town for SQL Saturday 883 in Louisville KY, if you are going to be around the area on August 2nd, I’ll be presenting an all day session on Common SQL Server Mistakes and How to Correct Them. This session is gear for the junior to mid-level DBA that is responsible for […]
I’m a Friend of Redgate for Another Year!
I am very proud and happy to be a Friend of Redgate for a ninth year! I had to ask Redgate when my first year of acceptance into the program was and they confirmed it was 2011. WOW, what an honor to be part of this program for so many years. If you’re not familiar with the […]