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
I don’t! There’s no such thing as multitasking. At least, not how most of us think about it……
Being successful as a Data Professional is hard. When you’re good at what you do, you are in demand.
It was early one morning and I was working on a production deployment to add a new Subscriber to an existing Publication. A routine task and one that I had performed many times before.
With SSMS open in front of me, I highlighted the relevant portion of my deployment script… Read more
Are you a Technical Expert or a Manager? You certainly cannot be both.
At least that’s the consensus that I frequently encounter. A belief that you can only be one or the other but definitely not both.
This is outdated thinking. It sounds to… Read more
The start of a new working year is often a time for self reflection. This is a great thing, it’s the first step toward you achieving growth, improvement and ultimately better results.
My fellow countrymen from Team GB know all about striving for growth and improvement to achieve outstanding results.… Read more
This post is part of the T-SQL Tuesday Meme, this month hosted by Jason Brimhall. His chosen theme, to come up with a story where you “stood firm” and relate it to these words: resolve, resolution, or resolute.
Regular readers will know and tell you that I’m resolute in… Read more
Short and sweet today, here’s what you enjoyed reading the most this year on the blog. No accounting for taste then.
- How To Become a SQL Server DBA
- My Guide To Passing Exam 70-432
- Top 10 Junior DBA Interview Tips
- The Database Administrators Primary Responsibility
It’s holiday season which means it’s a
time for you all to buy me gifts super busy time for Data Professionals!
Bosses are keen to take of advantage of the opportune downtime to get maintenance done and your colleagues are abandoning the office in droves. Leaving their… Read more
I am delighted to welcome to the blog someone who is without a doubt one of the biggest names in our SQL community. A name that I am sure many, if not all of you will recognise, they’re one of the very first bloggers that I myself began to… Read more
It’s one of the most enjoyable things about being a consultant.
I’m not talking about my suspect dance moves here. I’m actually talking about a very powerful problem solving technique.
Customers don’t hire consultants to work on easy problems. They’ve got those covered already. My customers are some of the… Read more
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 receive posts via Email.
I don’t typically syndicate ( that’s share using… Read more
Have you ever looked back on a conversation where someone asked you “what do you do?” and felt disappointed with your reply? Same here.
So how do you explain to someone, who is not familiar with your field, what it is exactly that you do?
Just last week my girlfriend… Read more
I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will have read and enjoyed their work before, being a prolific blogger of awesome content over on Simple-Talk. A renowned personality in the UK SQL community, he is… Read more
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with the community in response to my post What’s it Like to Be a DBA. I found their story compelling and their message really resonated with me, so much so… Read more
One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it Like To Be a DBA” post series, we’re privileged to have with us a gentleman that not only flexes his technical muscles regularly on his blog but… Read more
This year there are to be no excuses, and I mean it.
You know what I’m talking about. There’s always some reason why you can’t go to the PASS Summit, why you can’t make it this time around. Maybe the timing is just not quite right, you can’t get the… Read more
Today I am delighted to be able to share with you a guest post from one of my all time favourite bloggers in the SQL community. Their high quality, unique and creative content regularly making the cut for a place in the SFTW post roundup. I’ve been an avid reader… Read more
Absolutely fantastic of course!
You regular readers know that the Becoming a DBA area of the blog is one of the most visited and talked about, with the professional development posts often proving popular. All the comments, questions and emails you guys send tells me that there’s a lot of… Read more
Last week the SQL community and in particular the blogosphere, was buzzing with interest noise following the Microsoft Learning site publishing details of significant changes to SQL Server Certifications.
Here We Go Again
You know the drill. It’s the usual dance we go through every 5 years or so, where… Read more