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…
Month: March 2011
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…
SQL Homework—UNION, INTERSECT, EXCEPT—Solutions
Here are the solutions to the homework problems I sent out. Compare my queries with yours. If they’re different, and you’d like some explanation on why they’re different. Let me know. I’ll be happy to explain any differences with you. 1. Give me a list of all the first and last names in both tables. …
SQL Homework–UNION, INTERSECT, EXCEPT
This homework will run from my training server, shaioshin.hopto.org. If you do not currently have access to this server, please let me know and I’ll set up credentials so you can complete the following homework assignment. In the AdventureWorks database on my server I have two tables: example.person and person.contact. Take a look at the…
Tell me about a time when…
During many of the interviews I’ve been in, I’ll be asked a very open ended question. To me this kind of question will give the interviewer some insight into how well you can summarize a larger topic into a brief, but informative comment. This skill can be very important for knowledge workers. Think about how…
Scotland 2011–Day One
I’ve been interested in history for as long as I can remember. About ten years ago, I turned my interest in history into a search to find out where my family comes from. What was our story? In this search I found that among other things the name Lowder has had many spellings. But all…
70-451 Prep–SQL Server Agent
Well, now that I’ve passed the 70-433, I’ve moved on to preparing for the 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008. It’s basically a follow-up to the last exam. The downside to this follow up is there are no books or self-paced study guides to help you get ready…