Posted in: Microsoft SQL
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...
microsoft sql
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
career development
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
travel
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
microsoft sql
SQL 202-Data Tuning Advisor 2011 March 30 by Shannon Lowder Related posts: SQL 202-Performance Tuning SQL Session – Performance Tuning in SSIS SQL 101 – Summarizing Data SQL 301-The XML Data Type Moving Data Between Tables from → Microsoft SQL
Certification
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
Certification
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
Posted in: Career Development
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...
SQL201
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
SQL201
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
career development
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
travel
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