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 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 […]
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 […]
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.
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.
I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with you here.
Experts are always in popular demand and they come in all manner of different flavors.
In this post we look at exactly what it means to be an expert and how you can develop into the expert that you want to be.
Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.
Discover out how to achieve dramatic career growth and results from your professional development efforts.
It’s SFTW Time, I hope you’ve had a great week! Make sure you don’t miss this weekly round-up of SQL Server Links, community news and technology banter by Subscribing to the Blog Feed. You can also Get posts delivered direct to your Inbox free via Email. I don’t typically syndicate (that’s share using RSS technology to you non bloggers) […]
Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.
There’s no such thing as multitasking. At least, not how most of us think about it. By using the task management system that I share here, you can keep an accurate track of workload, prioritise and ensure that you spend more of your time delivering on what’s really important.