This week in twitter I’ve participated in discussions on resumes and how to construct them and how to improve them. Most of us only really think about our resume when we find ourselves needing them. We’ve either just ended a contract, or we’re looking to improve our position. As a result, changes and improvements are…
Scotland 2011-Day Three
We got up early on our third day in Scotland. We had planned on taking a pretty long route to get from Edinburgh to Inverness. We wanted to take in Stirling Castle, Stirling Bridge, the Wallace Monument, Doune Castle, Loch Ness, and Urqhart Castle before turning in for the night. It was going to be…
70-451:Linked Servers
I’m coming to the end of my posts on identifying which SQL Server components to use to support different business requirements. I’ve already covered SQL Server Agent, DB mail, Service Broker and Full-Text Search This time I’m going to go over linked servers. Not exactly the link I was talking about! Linked servers allows your…
SQL Best Practices: Backup Compression
There are quite a few products out there that help you compress your backups. Acronis, RedGate, and many more. This got me to thinking about whether or not I should be compressing my own backups. I know I’m not going to get any additional budget for it this year, so I’m not going to invest…
What questions do you have for me?
This might be my last interview question I cover for a while. It’s been a great run, but there are so many more topics in career development I want to cover. If you have any tough interview questions you’d like me to cover, please send them in, and I’ll discuss them here. For now, let’s…
Scotland 2011-Day Two
This is the slideshow from day two in Edinburgh, Scotland. We got up early by Eastern Standard Time, but it wasn’t too early by local standards. After a light breakfast, we hopped a double-decker buss to make our way to the Royal Mile and the sites in the old city. The bus took us by…
SQL 202-Data Tuning Advisor
70-451: Full-Text Search and Service Broker
Ok, over the past two posts I’ve been discussing some SQL Server Components and what they’re good for. I’ve already spent some time with the SQL Server Agent and others. In this article I want to dig into some scenarios you can solve using Full-Text searches. Let’s dive right in. Scenario 1 You have a…
70-451: SQL Server Components
Looking through the skills measured by the 70-451, the very first component measured has you “Identify which SQL Server components to use to support business requirements.” To do this you’ll need to be able to recognize the strengths of the different components of SQL Server. In my last 70-451 article I covered SQL Server Agent. …
What salary range are you looking for?
I’ve had more anxiety about this question, or some variation of this question, than any other in the interview process. When you need the job, you’re afraid to ask too much. But after you get a job where you did lower your asking price, you have to deal with the fact you’re then underpaid. How…