microsoft sql

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

microsoft sql

SQL 202-Data Tuning Advisor

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

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

Certification

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

SQL201

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

SQL201

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

career development

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

SQL201

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

SQL301

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

SQL301

SQL 301-XML EXIST Method

And now it's time to wrap up the XML in SQL posts. At least, this is the last of the information you're required to know for the 70-433. Anything above and

microsoft sql

SQL 301-The XML Data Type

We’ve spent the last few posts working on getting relational data out of our tables and into XML format.  Most of the time, that’s what I’ve used XML

SQL301

SQL301-Nesting For XML Queries

Given the 4 options I've shown you for creating XML output from SQL, you should be able to create nearly any structure you'd want (especially considering FOR