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…
Category: Microsoft SQL
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…
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. …
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…
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…
SQL201-The Syllabus
It’s that time again! Time to start up a new class and cover some more advanced topics in SQL Development. Before beginning these lessons, You need to be comfortable with all the material in my SQL101 series. Specifically you’re going to need to know SELECT, INSERT, UPDATE, and DELETE. With those skills in hand, I’ll…
SQL301–XML VALUE Method
Last time, I covered the EXIST Method. This time around I wanted to show you how to pull out values from XML stored in SQL. Let’s start with what should have been a simple example. I wanted to pull the first and last name for a job applicant along with their resume in XML format….