SQL302
Checking for Computed Columns
So I've been building an auditing system for my new employer that will help track all the changes to the data. Right now, some changes could be made, and we
microsoft sql
sql202
SQL 202-Performance Tuning
Honestly, choosing which level to put this content under was one of the harder decisions I had to make when putting this content together. Before you get into
product reviews
Product Review: DTS xChange
Late last week I was informed our new servers would be available January 3, and I should be ready to set up my new SQL 2008R2 two-node cluster. I can't begin to
SQL402
SQL 402:Deprecation in SQL Server
Last week at the Charlotte SQL Server User Group, Aaron Bertrand covered What's New in Denali. During that presentation he mentioned a few of the things that
SQL302
Types of Optimization
One of the things I love most about my current position is the fundamental shift in the types of optimization I'm doing. Early on in my career I was
SQL102
Foreign Keys and Witchcraft
I've worked with hundreds databases in my career. I could probably design a handful of them from memory if asked. I have notes to remind me of lessons learned
microsoft sql
Hitting the Ground Running
I’ve been on the job a couple days now, and I feel like I’m well on my way to contributing to my new company. On the first day I started pulling the latest backups to my local machine, and setting up a development environment where I can start diagramming the databases, and looking into the… Continu
microsoft sql
SQL 101 — the 11/24 presentation
Wednesday night I had the opportunity to give my SQL 101, the basics presentation. I hadn't given this one since just before leaving IntegrationPoint earlier
SQL101
SQL 101 Training
Wednesday November 24th, from 5 - 7pm I'll be offering my SQL 101 course. I was thinking about adding a remote option for those of you who can't make it up to
microsoft sql
The Query Your Query Could Run Like
If you don't know about the Old Spice Guy, seriously...go hit youtube.com now. The past few weeks we've been preparing for a conversion of data from two systems
Certification
70-433:Dynamic Management Views
I just laid hands on a great little guide to the Dynamic Management Views in SQL Server 2008. It's a great introduction / quick reference guide sort of book.
sql202
Modifying Data in Partitioned Views
Yesterday I covered the basics of partitioned views. I also mentioned there were some gotchas when it comes to modifying the data in those partitioned views.