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. Read more
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… Read more
Taking responsibility for your professional development and making it a priority is essential to being a successful Data Professional. It’s why so many of you get involved and share great advice in the Community Forum.
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login.
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… Read more
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…
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.
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.
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… Read more
When there’s something worth celebrating, such as a birthday or achieving the Microsoft Certified Master (MCM) SQL Server certification, I like to mark the occasion here on the blog with a SQL Server Crossword. I know, living it up right!
Same as before, the answers are all SQL Server words… Read more
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.
Things can and will go wrong in your environments. Even the greatest software contains bugs and hardware fails, often.
When an unforeseen issue arises your reaction can directly influence… Read more
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… Read more
Ensuring excellent performance for users and customers is a high priority for Database Administrators.
Today I want to share a free and easy way for you to get valuable insight into the performance of your Microsoft SQL Server instances.
There are so many features in the SQL Server product that… Read more
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.
A customer environment was suddenly receiving high CPU alarms and I was called in to take a look.
Having… Read more
Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them extremely well. More commonly we know them as experts.
Experts are always in popular demand and they come in all manner of different flavours.
Of course they are just everyday… Read more
Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.
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… Read more
Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.
Whilst covering the Production Ops Shift in our shop over the weekend I discovered that Database Mail had not been configured for the SQL Server Agent on a number of servers.… Read more