A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one that is straightforward to answer via the Twitter medium though, so I wanted to share some more detail here. Consider that the action of disabling a SQL Server Index […]
I received an email from a reader the other day, asking for a spot of advice. You know, that highly sought after and dangerous free stuff. Our SQL community chum posed some rather splendid questions, some of which you have likely pondered too. Since a chap only has so many keystrokes in life, I’m sharing my thoughts […]
Good reads from around the Web. It’s the final day of February today meaning that 2 whole months of 2014 are already behind us. How about those New Year resolutions and goals then folks, still going strong? I’m delighted to report that the gym is no longer as busy as it was a month ago […]
I encountered an interesting question over on the MSDN forums concerning a poster that was reporting experiencing an issue whereby the “sa” account kept being locked out. In scenarios such as this the SQL Server Error Log is your friend, as it can be configured to record failed login attempts for an instance. Of course […]
This is a quick post to announce the winner of my blog giveaway for a free conference pass to SQL Server Live! in Las Vegas. Those rather nice folks at SQL Server Live are also offering SQL Brit readers (that’s you lot) an exclusive discount of $500 for their upcoming event in Las Vegas in March. All you have to do to take advantage […]
Good reads from around the Web. It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week. This week I’ve been playing (read as, pulling my hair out) with Extended Events. Without a doubt a powerful feature but it is a bit of a hard graft to work with in SQL Server 2008, […]
Good reads from around the Web. It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week. Those rather nice chaps over on the Toad World Community have only gone and made yours truly their SQL Pro of the Month. Far too generous an accolade. Here’s your weekly roundup of SQL Server Blog […]
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy of Automate Everything and DBA administrative tasks are no exception. I don’t want to be doing the same task by hand twice, if I can help […]
I received a blog comment from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. I only have a finite number of keystrokes left in me after all, so I’m blogging my thoughts and replying to the comment with a link to this post. Hi John, […]
If you could give a DBA just one piece of advice, what would it be? I asked 20 successful and experienced SQL Server professionals this exact question. You can find their answers inside DBA JumpStart, a unique collection of inspiring content just for SQL Server DBAs. Just Another Blog Post It’s hard to believe that […]
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit readers (that’s you lot) an exclusive discount of $500 for their upcoming event in Orlando this November. All you have to do to take advantage of this offer […]
Taking responsibility for your own Professional Development and making it a priority is essential to being a successful Data Professional. Courtesy SQL Server Live! I’ve got an outstanding opportunity for you to do exactly that. Together we’re giving you the chance to Win a FREE conference pass to SQL Server Live! in Orlando. SQL Server Live! […]
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. Since I only have so many keystrokes left in my life, I am blogging my thoughts and emailing a link. Dear Sir, I am 37 years old. I’ve never worked in […]
Senior Database Administrators (DBAs) through experience develop and practice a variety of habits that become key contributors to their success. Here are 10 habits of successful DBAs that you can begin to put to work for you right away. Habit #1: Use Free SQL Server Tools What if I told you that you can get […]
It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week! Some of you may have noticed that I’ve been a tad quieter in the SQL community of late. No not because I’ve been slacking off dear reader but because I needed to focus my efforts in on a single goal in order […]
Test your SQL Server knowledge in a fun and unique way with this exclusive crossword.
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.
In this post I share with you what I have learned about keeping your cool in a crisis and what I believe is the most vital component to effective incident response.
I’m becoming increasingly concerned that security has fallen from the forefront of peoples minds. Data Professionals just don’t seem to be giving security the attention that it deserves. The threat to you, your company and your customers is very real.
For me, one of the most rewarding things about blogging are the conversations we have together. The opportunity to connect, share and grow with passionate people from all over the world is a great privilege. I’ve met so many wonderful people through our community, learning something from each of you about technology and even life.
That’s why I started the SQL Brit Community Forum.
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Here I share a free and easy way for you to get valuable insight into the performance of your Microsoft SQL Server instances.