Video: Maximize SQL Server Performance with SQL Tuning

This presentation is a bit old, but largely still applicable.  It will help you understand Microsoft tuning techniques. It will teach tips and tricks for making queries perform better, and how to use tools to tune SQL. Posted March 27, 2007. … [Read more...]

DBTA: The Future of Coding for SQL Server, Part 2

In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology introduced by Microsoft in late 2008. LINQ to SQL promised to make developers' lives much easier by allowing them to focus on writing programs in their favorite Visual Studio language and letting LINQ to SQL write all the Transact-SQL code. The problem is that LINQ to SQL writes very bad Transact-SQL code. [READ MORE] … [Read more...]

DBTA: The Future of Coding for SQL Server

In a two-part article over the next two months, I'm going to address an important issue for the SQL Server community: the future direction of coding for SQL Server, as directed by Microsoft. I'll start by telling you a bit about the current situation with writing code on and for SQL Server, and, in the next installment, talk more about the ramifications brought on by the current coding environment. I'm curious if you agree with my assertions.  You also have the added advantage of hindsight, since I wrote these a while ago. [READ MORE] … [Read more...]

Free Poster – SQL Server Dynamic Management Views

I enjoy working at Quest Software partly because we do a lot to give back to the community. Here's one example, a free poster describing all of the SQL Server 2005 and 2008 dynamic management views.  Get it here.  It's the perfect compliment to the free system map poster available from Microsoft here. … [Read more...]

New Fast Features Video – Toad for SQL Server

Fast Features for Quest Tools. Someday soon, I promise. I've been trying hard to get more videos out the door about the SQL Server tools from Quest Software (my employer).  I'd sent a new one over to the program marketing team a while back, but it's not showing up in the Coffee Break Bytes section like it should.  These little videos show a single feature in detail, usually taking no more than 5 minutes to watch in their entirety. In the meanwhile, check out the excellent video series here.  And the blogs are really good too, available on the interwebs here. Thinking about cloud … [Read more...]

The Data Detective is on the Case (And I Can Hook You Up for Free!)

You may have seen a new super sleuth around Quest.com and Toad World - The Data Detective! The team at Quest Software has created a new comic series where users can learn how Toad for Data Analysts will help you find, understand and report on data.  Plus, you can take part in a contest to win a free one-year license of TDA! The first in the comic book series is posted here.  And there's one each month.  If you contact me directly, I can help you get to the front of the line for the contest! … [Read more...]

Join Me May 19th for 24 Hours of PASS

Join Us for 24 Hours of SQL Server Training (with a special focus on SQL Server 2008 R2) Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!? The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May 19. Get an in-depth look at the hottest SQL Server and BI topics, including (but not limited to!) - the new SQL Server 2008 R2, with its business intelligence and data management innovations, and much more. When does it start? 12:00 GMT … [Read more...]

Free Training for You, Punishing Workload for Me. Thank You for Enjoying My Misery.

Everybody enjoys a little free training now and then.  I've got mountains of free training in the works.  Some of it is in-person and local while some are in webcast format.  Please join me as you're able! Tomorrow - Wednesday! Wed, Feb 10, 2010 at 12 pm (noon) MST - PASS DBA Virtual Chapter; Top 10 Administration Mistakes on SQL Server There are a short list of mistakes that, if you know of them in advance and prepare for them, will make your life much easier.  This presentation shows you these mistakes, the "low hanging fruit" of database administration.  Once you apply the lessons … [Read more...]

Upcoming Seminar and SQL Saturday in Florida, Oct 13-17

Please join me for SQL Saturday #21 coming up on Saturday, October 17th.  There are over 50 sessions on tap with great speakers from the area and across the nation.  Some of the notable speakers include: Andy Leonard (blog here) Andy Warren (blog here) Brian Knight (blog here) Buck Woody (blog here) Chad Miller (blog here) Joe Celco (blog here) Joe Webb (blog here) Jonathan Kehayias (blog here) Kendal Van Dyke (blog here) Ken Simmons (blog here) Not only do we have SQL Saturday coming up, but Andy & company put together five world class seminars the week … [Read more...]

Bitemporal Data

Any IT pro with more than a year or two of experience will have faced the challenges of version control for an application, but what if you have to implement version control for data? The most common way to tackle this problem is implementing something called "bitemporal data". Under this method, each row in a table includes the current valid time and the transaction time. Since two distinct time values are stored, we get the term bitemporal. A great place to start is Adam Machanic's excellent article at … [Read more...]